Skip navigation links

MySQL Forums :: MySQL Administrator :: MySQL Error Number 1130 IP not allowed to connect to this MySQL Server


Advanced Search

MySQL Error Number 1130 IP not allowed to connect to this MySQL Server
Posted by: Jörg Nowak ()
Date: November 07, 2005 02:32AM

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

Options: ReplyQuote


Subject Written By Posted
MySQL Error Number 1130 IP not allowed to connect to this MySQL Server Jörg Nowak 11/07/2005 02:32AM
Re: MySQL Error Number 1130 IP not allowed to connect to this MySQL Server Jörg Nowak 11/07/2005 05:10AM
Re: MySQL Error Number 1130 IP not allowed to connect to this MySQL Server Joost VanCappellen 05/31/2006 09:27AM
Re: MySQL Error Number 1130 IP not allowed to connect to this MySQL Server Waruna Ranasinghe 12/11/2007 05:43AM
Re: MySQL Error Number 1130 IP not allowed to connect to this MySQL Server Suraj Kanchana 02/18/2008 12:45AM
MySQL Error Number 1130 IP not allowed to connect to this MySQL Server Virul Patel 05/20/2008 09:05PM
javax.servlet.ServletException: null, message from server: "Host '192.168.0.17' is not allowed to connect to this MySQL server" Murali Boopathy 09/26/2007 03:33AM
MySQL Error Number 1130 IP not allowed to connect to this MySQL Server Suraj Kanchana 02/18/2008 12:50AM
Re: MySQL Error Number 1130 IP not allowed to connect to this MySQL Server Nanda Kumar 06/18/2008 09:02PM
Re: MySQL Error Number 1130 IP not allowed to connect to this MySQL Server Peter Wilson 05/29/2009 03:09AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.