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

Trackback URI | Comments RSS

Leave a Reply

You must be logged in to post a comment.