MySQL Error Number 1130 IP not allowed to connect to this MySQL Server

[Jörg Nowak]

Hello,

I try to connect from my local machine as "root" via MySQL Administrator to MySQL Cluster 4.1.14

The ping works but I can't connect to MySQL server because MySQL Error 1130 "xxx.xxx.xxx.xxx not allowed to connect to MySQL Server"

I remember that the database "mysql" is responsible for the hosts and user rights to allow to connect.

In this database in table "user" I have the following entries :

| xxx.xxx.xx.xx | lv30680 | | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | | | | | 0 | 0 | 10 |
| xxx.xxx.xx.xx | root | | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | | | | | 0 | 0 | 10 |


xx ist of course a real IP address and lv30680 is my local account on the machine from where I try to connect.

What can I do to allow this IP adress to connect to the MySQL Server ?

Joerg Nowak