I am trying to set up a MySQL server on ubuntu behind a router, following this great setup tutorial. The server has been set up running on my machine on port 3306. I also let the router forward (TCP and UDP requests) from port 3306 to my machine. But when I tried to connect MySQL server, by mysqladmin -h 70.24.xx.xx -u root passowrd myrootsqlpassword it returns "mysqladmin: connect to server at '70.24.xx.xx' failed error: 'Host 'randomcharacterstrings.yyy.net.cable.zzzzz.com' is not allowed to connect to this MySQL server' " Here, 70.24.xx.xx is the external IP of my router. And I am guessing the Host 'randomcharacterstrings.yyy.net.cable.zzzzz.com' is the name that My ISP uses (the name of my router?). Any ideas of what the problem is? Thanks!
You must use the hostname that is listed in the mysql.user table in the MySQL database. You can also change the hostname there or put % instead of a hostname there (% allows connections with all hostnames). Restart MySQL afterwards.
