I've tried searching for an answer, but can't quite find it.
I need to remotely access a MySQL instance through the local MySQL Workbench. The port is turned on (I believe). I can Telnet into it.
All the examples I see say something along the lines of
GRANT ALL PRIVILEGES ON *.* TO USER-NAME@IP IDENTIFIED BY "PASSWORD";
The trouble with this is that I'm remoting in from a dynamic IP. The error I get is
Access denied for user 'root'@'c-67-166-150-41.hsd1.ca.comcast.net' (using password: YES)
How do I set it up to allow me in? I do have root access to the MySQL Workbench on the remote machine if I remote control in.