View Full Version : How i can have mysql on one server and the vb php files on another

26 Oct 2006, 00:23
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.


26 Oct 2006, 01:46
// 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

26 Oct 2006, 03:17
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 ?

27 Oct 2006, 04:26
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

31 Oct 2006, 17:07
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.

31 Oct 2006, 18:08
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';