How to connect to MySQL remotely
I tried to connect to MySQL remotely (I need to go without SSH).
Commented bind-address with #.
Getting MySQL said: Access denied for user ‘root’@'myremoteip’ (using password: YES)
How can I connect? Searched internet. Found that I should run “`GRANT ALL PRIVILEGES ON . TO 'root’@’%’ IDENTIFIED BY 'PASSWORD’ with grant option; FLUSH PRIVILEGES;
it is not working for me. How can I achieve that?