Host XXX.XXX.XXX.XXX is not allowed to connect to this MySQL server

you have to add the host in the users admin bit and set its access rights.

Try GRANTing the IP address of the server instead of using FQDNs. If
you are using FQDNs then you need to make sure that Forward and Reverse
DNS is working correctly for the MySQL server so that it can resolve the
host name.

mysql error: [host] is not allowed to connect to this MySQL Server<br />------------------------------------------------------------------<br /><br />"GRANT ALL PRIVILEGES ON [dbname].* to<br />                 '[user]'@'[hostname]' identified by<br />                 '[password]'<br /><br />replacing [dbname] with the name of your database, [user] with the user<br />name, [hostname] with the host that MySQL Connector/J will be connecting<br />from, and [password] with the password you want to use.<br /><br />Be aware that RedHat Linux is broken with respect to the hostname<br />portion for the case when you are connecting from localhost. You need to<br />use "localhost.localdomain" for the [hostname] value in this case.<br />Follow this by issuing the "FLUSH PRIVILEGES" command."<br /><br />mysql> GRANT ALL PRIVILEGES ON *.* to<br />     -> 'root'@'igloo.its.unimacq.edu.au' identified by<br />     -> 'goaway!!!';<br /><br />mysql> select Host, User, Password from user where Host='igloo.its.unimacq.edu.au';<br />+--------------------------+------+------------------+<br />| Host                      | User | Password          |<br />+--------------------------+------+------------------+<br />| igloo.its.unimacq.edu.au | root | 1de8e8d957ce703d |<br />+--------------------------+------+------------------+<br />1 row in set (0.00 sec)<br /></pre>        <pre>i had this problem with windows. downloading latest mysql 3.51 driver and granting all privileges to root from any location on mysql driver fixed error. mayb u should try this on linux. mysql> GRANT ALL TO 'root'@'%' IDENTIFIED BY 'somepassword';</pre>        <pre><div nd="10">Well I'm having similar problems.<br /><br />I have a Linux dedicated server running mySQL and am trying to connect to it via phpMyAdmin (which resides on the linux server as well).<br /><br />I did the GRANT command<br /><br />"GRANT ALL PRIVILEGES ON *.* TO 'someuser'@'%' IDENTIFIED BY 'somepass' WITH GRANT OPTION;<br /><br />and that worked fine. I know this because now I can login from the shell with the new account. Also, when I look at the user table I can see the new account.<br /><br />So the account works fine from the linux shell but when I pull up phpmyadmin in my browser and enter the username and password there it just won't let me in??<br /><br />Is it a firewall setting? (I wouldn't think so since I can access the shell via SSH from the same host?) Or did I setup the account incorrectly??<br /><br />Very confused, someone please help me!!!</div>