mysql error: [host] is not allowed to connect to this MySQL Server
------------------------------------------------------------------
"GRANT ALL PRIVILEGES ON [dbname].* to
'[user]'@'[hostname]' identified by
'[password]'
replacing [dbname] with the name of your database, [user] with the user
name, [hostname] with the host that MySQL Connector/J will be connecting
from, and [password] with the password you want to use.
Be aware that RedHat Linux is broken with respect to the hostname
portion for the case when you are connecting from localhost. You need to
use "localhost.localdomain" for the [hostname] value in this case.
Follow this by issuing the "FLUSH PRIVILEGES" command."
mysql> GRANT ALL PRIVILEGES ON *.* to
-> 'root'@'igloo.its.unimacq.edu.au' identified by
-> 'goaway!!!';
mysql> select Host, User, Password from user where Host='igloo.its.unimacq.edu.au';
+--------------------------+------+------------------+
| Host | User | Password |
+--------------------------+------+------------------+
| igloo.its.unimacq.edu.au | root | 1de8e8d957ce703d |
+--------------------------+------+------------------+
1 row in set (0.00 sec)
|