mysql connect

raduciora · 07-19-2005, 03:44 AM

I have installed SUSE 9.2 Professional with MySQL version 4.0.21. I start the MySQL server at sistem start. I try to connect to the server from 3 computers within the same network. The clients run Windows 2000 Professional SP4. From one of them the connection runs O.K., but from the other I can't estabish a connection, not even through telnet. The result returned by the telnet query 'telnet Linux 3306' is:
Host 'xxx.xxx.xxx.xxx' is not allowed to connect to this MySQL server
Connection to host lost.

raduciora · 07-19-2005, 05:40 AM

I have installed SUSE 9.2 Professional with MySQL version 4.0.21. I start the MySQL server at sistem start. I try to connect to the server from 3 computers within the same network. The clients run Windows 2000 Professional SP4. From one of them the connection runs O.K., but from the others I can't estabish a connection, not even through telnet. The result returned by the telnet query 'telnet Linux 3306' is:
Host 'xxx.xxx.xxx.xxx' is not allowed to connect to this MySQL server
Connection to host lost.

rylan76 · 07-19-2005, 01:13 PM

Have you listed the servers' IP adresses that are allowed to connect to the Linux system in /etc/hosts.allow?

Are you running some form of firewall like IPTables?

It might be that iptables is blocking the portnumbers MySQL needs for all IP addresses except the machine that is working at the moment...

Tinkster · 07-19-2005, 08:51 PM

Please do not post the same thread in more than one forum. Picking the most relevant forum and posting it once there makes it easier for other members to help you and keeps the discussion all in one place.

http://www.linuxquestions.org/rules.php

raduciora, I have merged your two more or less identical threads and
would appreciate if you re-read the rules you agreed to.

raduciora · 07-20-2005, 01:58 AM

I used to create the database users like this: "user_name@host".
I created them just with "user_name" and now I can connect from any terminal of the network.
But still remains the question 'Why can I connect from 1 station with user_name@host ?'.

Tinkster · 07-20-2005, 03:54 AM

Do all machines have DNS entries on your LAN?
Are they all in the MySQL machine's /etc/hosts?
Or only the one?