Egor Egorov wrote:
"Phillip Mangwiro" <[EMAIL PROTECTED]> wrote:
I'm getting an Error 1130, ("MyDNSName is not allowed to connect to this
machine"), whenever I try to connect to MySQL server from any client by
using its IP or "friendly" DNS name other than 127.0.0.1 or localhost.
This has happened on three machines so far, is there something I forgot to
enable/disable?
Are you sure that GRANTs are correct? Take a look at http://dev.mysql.com/doc/mysql/en/GRANT.html
Here's what happens:
C:\mysql\bin>mysqlc -u root -p -h netadmin
Enter password: *********
ERROR 1130: Host 'netadmin.kptc.org.zw' is not allowed to connect to this MySQL
server
But if I try it without the host parameter I connect succesfully:
C:\mysql\bin>mysqlc -u root -p
Enter password: *****
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 31368 to server version: 4.0.20a-nt
Type 'help' for help.
mysql> \q
Bye
root has all priviledges but isn't allowec to connect when using the host parameter.
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
