[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Remote connection error 1130/2003

Posted on 2005-04-20
6
Medium Priority
?
264 Views
Last Modified: 2008-02-01
I have a Mysql server running on a fedora 3 box. I want to use a winxp client to remotely administer the databases.

On both machines  i am using the "mysql control center"as the admin client.

I have used webmin to set up the hosts allowed

On the win machine i get the following error
                      [Server] ERROR 2003: Can't connect to MySQL server on '10.1.1.30' (10065)
10.1.1.30 being the ip address of the mysql server

However if i run the admin client on the linux machine, if i use anything but "localhost", i get the following error
          ERROR 1130: Host'10.1.1.30' is not allowed to connect to this mysql server

Regards Phill
0
Comment
Question by:PhillO
  • 4
  • 2
6 Comments
 
LVL 22

Accepted Solution

by:
JesterToo earned 1500 total points
ID: 13830776
It sounds like MySQL is configured to only allow the admin tool to connect from localhost... this is a common security setting.  Please read the sections 5.5.x (specifically 5.5.5, but be aware of the info in the others, too) of the MySQL manual.  Here's a shortcut to a couple of the relevant sections...

    http://dev.mysql.com/doc/mysql/en/connection-access.html 
    http://dev.mysql.com/doc/mysql/en/privilege-system.html

HTH,
Lynn
0
 

Author Comment

by:PhillO
ID: 13830920
Lynn

It would seem that this works out for the localhost in that from this info i figured out how to access mysql using 10.1.1.30 instead of local host. this was just a test anyway toctry and find where the problem was.

However i have fiddled with the ip addresses and usernames for the xp machine and still get

                             [Server] ERROR 2003: Can't connect to MySQL server on '10.1.1.30' (10065)
Any ideas

I agree that it seems to be a permissions problem though

Phill
0
 

Author Comment

by:PhillO
ID: 13830927
I forgot to mention that the client and server are on different subnets for security

Phill
0
Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

 
LVL 22

Expert Comment

by:JesterToo
ID: 13831027
Check the configuration file (my.cnf) to ensure that it doesn't contain "skip-networking".  If this is present you can only have local connections.  Alternatively you could issue the "mysql show variables;" command from the server to see the configuration options in effect.

Lynn
0
 

Author Comment

by:PhillO
ID: 13832323
lynn

"skip-networking" does not appear
0
 

Author Comment

by:PhillO
ID: 13833411
AHHHHHH!!!!

Damn Firewall!!!!!!!!!!!!!!

Phill
0

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Password hashing is better than message digests or encryption, and you should be using it instead of message digests or encryption.  Find out why and how in this article, which supplements the original article on PHP Client Registration, Login, Logo…
This post looks at MongoDB and MySQL, and covers high-level MongoDB strengths, weaknesses, features, and uses from the perspective of an SQL user.
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
Suggested Courses
Course of the Month20 days, 8 hours left to enroll

868 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question