"Host "xxx.xxx" not allowed to connect to this MySQL server"
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?