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?
These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.