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
Leave a Reply
You must be logged in to post a comment.