How i can have mysql on one server and the vb php files on another

[TheRealRage]

The topic title shoud explain very well what im trying to figure out.

I wanna have the mysql database of vb on one server and the php files on a diffrent one,
does anybody have and idea if thats possible and when ya how.

Regards

[sebbe]

// ****** 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;

Change these values in includes/config.php

[TheRealRage]

so i change localhost to the ip of the server where the databse is on right ?

If ya that didnt worked out well nothing happends when i got to the server with the php files... the server where the database is on runs under plesk maybe the port is diffrent or such ... does somebody might know where i find the port of the mysql ....

any idea someone ?

[Ntfu2]

Yes, but be warned if you are transfer your database over public network you'll need a port speed of atleast 100mbps, and tons of spare bandwidth. Its best to have private connection between the two servers since most the time private bandwidth is free.

And i think plesk mySQL uses 8306 for connections, or something like that

[jason|xoxide]

The port Plesk uses is the default mysql port. However, DB users created through the Plesk interface can only access the DB from the localhost. If you want to connect from a remote system then you'll need to log into the mysql console and add a user that can connect remotely.

[Ntfu2]

login via SSH and get to the mysql console, using by typing mysql will get you there


GRANT ALL PRIVILEGES ON database_name.* TO 'database_user'@'db.server.ip.address' IDENTIFIED BY 'password';