MYSQL database to a separate server

How hard is it to move one's MYSQL database to a separate server?

I am interested in doing this:

1 separate server everything else connected to the db
1 separate server Mysql databases

Any thoughts and/or help files on how this could help a server with slow loading times and higher than normal loads.

Thanks in advance

[UltimateOreo!]

Oh, lol, i misread the question. Nevermind, this can be pretty easily done.

[Feckie (Roger)]

Originally Posted by Dismounted

You just need to transfer the database to the new server, then change the DB access details in config.php to reflect the changes.

Would you be able to give a sample coding...thanks

[Freezerator]

	//	****** MASTER DATABASE SERVER NAME AND PORT ******
	//	This is the hostname or IP address and port of the database server.
	//	If you are unsure of what to put here, leave the default values.
$config['MasterServer']['servername'] = 'localhost';
$config['MasterServer']['port'] = 3306;

@localhost: The ip of your database server. It can't be more obvious.

[Feckie (Roger)]

tis ok me thick Bastard

So Would You Give Me An Example


thanks