473,856 Members | 1,631 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Error 1130 when accessing MySQL from another IP??

Hi,

I am trying to run the MySQL DB on a Linux machine that is part of a home
LAN (IP=192.168.0.3 ), while trying to access it from another WinXP machine
(IP=192.168.0.5 ). I keep getting the following error:

MySQL Error Number 1130
#HY000Host '192.168.0.5' is not allowed to this MySQL server

Ping works fine.

On searching the internet, I find reference to "allow list" hidden somewhere
in the guts of MySQL. Can anyone provide me hints on how to add to this
list?

Thanks!
SB
Aug 29 '05 #1
4 144734
Spare Brain wrote:
Hi,

I am trying to run the MySQL DB on a Linux machine that is part of a home
LAN (IP=192.168.0.3 ), while trying to access it from another WinXP machine
(IP=192.168.0.5 ). I keep getting the following error:

MySQL Error Number 1130
#HY000Host '192.168.0.5' is not allowed to this MySQL server


The first thing I would try is to grant access to the given user from
that client IP address:

# mysql -u root mysql
mysql> grant all on test.* to 'username'@'192 .168.0.3';

See http://dev.mysql.com/doc/mysql/en/adding-users.html for more
information.

I don't know of any "allow list" mechanism in MySQL, except for the one
with which you can restrict client access to a single IP address (the
"--bind-address=<ip-address>" option of mysqld).

Regards,
Bill K.
Aug 29 '05 #2
"Bill Karwin" <bi**@karwin.co m> wrote in message
news:de******** @enews4.newsguy .com...
Spare Brain wrote:
Hi,

I am trying to run the MySQL DB on a Linux machine that is part of a home
LAN (IP=192.168.0.3 ), while trying to access it from another WinXP
machine (IP=192.168.0.5 ). I keep getting the following error:

MySQL Error Number 1130
#HY000Host '192.168.0.5' is not allowed to this MySQL server


The first thing I would try is to grant access to the given user from that
client IP address:

# mysql -u root mysql
mysql> grant all on test.* to 'username'@'192 .168.0.3';

See http://dev.mysql.com/doc/mysql/en/adding-users.html for more
information.

I don't know of any "allow list" mechanism in MySQL, except for the one
with which you can restrict client access to a single IP address (the
"--bind-address=<ip-address>" option of mysqld).

Regards,
Bill K.

Thanks!! That seems to work!

I generalized it (based on the URL in your note) to 'grant all privileges on
*.* to 'root'@'192.168 .0.%' with grant access;'.

What is surprising to me is that my installation of MySQL on the WinXP is
accessible without any such modifications from other machines (including the
Linux), while the installation on the Linux machine needed this fix. Wonder
why??

Thanks again.
Angus
Aug 29 '05 #3
As linux is more security minded, you have to change the mysql config
file. try this

http://linux-discovery.blogspot.com/...m-outside.html

Spare Brain wrote:
Hi,

I am trying to run the MySQL DB on a Linux machine that is part of a home
LAN (IP=192.168.0.3 ), while trying to access it from another WinXP machine
(IP=192.168.0.5 ). I keep getting the following error:

MySQL Error Number 1130
#HY000Host '192.168.0.5' is not allowed to this MySQL server

Ping works fine.

On searching the internet, I find reference to "allow list" hidden somewhere
in the guts of MySQL. Can anyone provide me hints on how to add to this
list?

Thanks!
SB

Aug 29 '05 #4
Spare Brain wrote:
"Bill Karwin" <bi**@karwin.co m> wrote in message
news:de******** @enews4.newsguy .com...
Spare Brain wrote:
Hi,

I am trying to run the MySQL DB on a Linux machine that is part of a home
LAN (IP=192.168.0.3 ), while trying to access it from another WinXP
machine (IP=192.168.0.5 ). I keep getting the following error:

MySQL Error Number 1130
#HY000Host '192.168.0.5' is not allowed to this MySQL server


The first thing I would try is to grant access to the given user from that
client IP address:

# mysql -u root mysql
mysql> grant all on test.* to 'username'@'192 .168.0.3';

See http://dev.mysql.com/doc/mysql/en/adding-users.html for more
information .

I don't know of any "allow list" mechanism in MySQL, except for the one
with which you can restrict client access to a single IP address (the
"--bind-address=<ip-address>" option of mysqld).

Regards,
Bill K.


Thanks!! That seems to work!

I generalized it (based on the URL in your note) to 'grant all privileges on
*.* to 'root'@'192.168 .0.%' with grant access;'.

What is surprising to me is that my installation of MySQL on the WinXP is
accessible without any such modifications from other machines (including the
Linux), while the installation on the Linux machine needed this fix. Wonder
why??

Thanks again.
Angus


Because Linux is more orientated on securty then windows is?

By the way - i dont know if you are running a windowsmanager on the
Linux machine, but there is a very nice free GUI MySQL administrator
utility available for both windows and Linux. Take a look here:

http://www.mysql.com/products/tools/...tor/index.html

Its makes setting rights, creating and mantaining users, databases etc.
as easy as a few mouse-klicks. It can take a lot of pain out of all
these tasks for newcomers, tough i admit its very usefull to learn to
manage all these things from the commandline too... ;-)

John.
Aug 29 '05 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
1524
by: mad | last post by:
I am new here and don't know if someone has encountered and discussed this problem before. I appreciate any help to this problem. I am building a new Oracle database (8.1.7) and Win 2000/IIS 5 for development. After I moved ASP pages over from another server (also Oracle 8.1.7 and Win 2000/IIS 5), the error occurred when recordset's MoveNext is called. Here is the code: <% Set cmdTemp = Server.CreateObject("ADODB.Command") Set rsProd...
2
1846
by: Les Szabo via AccessMonster.com | last post by:
Dear Community, > > I have encountered a frustration with MS Access 2003 on XP. When > attempting to run a wizard - the computer trys to access a DA0 file. And > returns a 1706 error. It appears that the computer thinks the MS-Access > file resides on the A: not by CD drive e:. I have uninstalled and > re-installed the whole office suite of programs - but no luck. > > Is there anybody who may have an answer to this question? >
4
1650
by: Phil Townsend | last post by:
Are there class libraries available for accessing MySQL DBs from .net? Coming from a SQL Server/MS shop this is a little new to me. Any other resources would be helpful as well... thanks! *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it!
0
1058
by: Roger | last post by:
when I attempt to create the outlook.application object in a windows environment, it works, but when I use the same code in ASP.Net, it throws a "server exception error". Googled the error and found only a handful of suggestions. It suggested changing the processmodel user id to "system". But, I still get the error. Any ideas how to use the object in a ASP.net environment?
3
2470
by: Steve Teeples | last post by:
I am writing my first database application. I am unable to even get to first base because I can't seem to access the data in the database. Each time the "Fill" command is executed I get an exception . Does anyone know why this may be? The database has only two small tables and I am just trying to access the first table. I have already enabled Remote connections on my system. private void GetData() { // Specify a connection string.
0
1779
by: Ramesh2006 | last post by:
Hi, The following error occurred when i programmatically compile another project from my present project. The Error: error CS0234:The type or namespace name 'Windows' does not exist in the namespace 'System' <are you missing an assembly reference> The Source Code:
1
7018
by: nandakumar.raghu | last post by:
Hi, I have written a javascript function that acceses properties from an activex object. - <OBJECT id="alertObj" classid="clsid:AEE77194-B98F-4E0E-A27F-4AD6B23F0038"></OBJECT> function onLoadfunc()
1
1633
by: David Schrader | last post by:
Hello all, Let me start by saying that I'm not certain whether this belongs here, in this notes group, or another more developmentally oriented one. I'll try starting here then go elsewhere if you decide otherwise. (Already forwarded here, sort-of, from: microsoft.public.windowsnt.registry.) I'm writing a Visual Basic program which stores and retrieves data in the registry - no big thing, I've got all that code written
10
9789
by: Anton | last post by:
Hi, when accessing a secured 3rd party webservice i'm getting a 401 HTTP Statuscode (unauthorized). When entering the url in a browser and entering the username and password manually, the wsdl is returned. So the username and password should be ok. I'm using this code: Merchant myMerch = new Merchant(); myMerch.merchantIdentifier=merchantId;
0
9904
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
11049
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
1
10772
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
9527
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
0
7086
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
5754
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
5956
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
4568
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
4169
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.