ats2012
asked on
Unable to connect to remote Ubuntu mySQL Server
I have a website hosted on a windows server that is trying to connect to a remote mysql server. I think I setup the right to allow this server but I keep getting access denied for user root. This what the command I ran but didn't fix my issue.
GRANT ALL ON *.* to 'root'@'IP Address of Server' IDENTIFIED BY 'password';
FLUSH PRIVILEGES;
GRANT ALL ON *.* to 'root'@'IP Address of Server' IDENTIFIED BY 'password';
FLUSH PRIVILEGES;
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Here are my current rights to this server.
mysql-rights.PNG
mysql-rights.PNG
ASKER
Rebooted the server and now its working.
Glad it is working. You probably only need to recycle the services.
ASKER