SBDavid
May 24th, 2009
May 24th, 2009
Setting up remote mysql server on DA
Setting up remote mysql server on DA
Make sure that port 3306 is open on the remote box.
Basically, you just run the “GRANT ALL PRIVILEGES ON *.* TO da_admin@localhost” command again, but you change localhost to the IP of your DA server.
GRANT ALL PRIVILEGES ON *.* TO user@16.15.4.1 WITH GRANT OPTION;
FLUSH PRIVILEGES;
Test it out by logging into your DA machine via ssh, and type:
mysql -uda_admin -p –host=16.15.4.1
