Can't connect to MySQL server

pons madunix at gmail.com
Thu Aug 10 12:58:04 UTC 2006


I installed a MySQL  on a RHEL server, and I want to connect to the database
from another computer.
but i keep getting "IP not allowed to connect to this MySQL server"
As you know RedHat Linux Enterprise enable firewall by default, I run the
firewall setting,
and allow port 3306.

What could be worng?

root at intra init.d]# mysql -u root -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 72 to server version: 5.0.24

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> quit
Bye
[root at intra init.d]# nmap localhost

Starting nmap 3.70 ( http://www.insecure.org/nmap/ ) at 2006-08-10 14:58
EEST
Interesting ports on intra (127.0.0.1):
(The 1654 ports scanned but not shown below are in state: closed)
PORT     STATE SERVICE
22/tcp   open  ssh
111/tcp  open  rpcbind
631/tcp  open  ipp
1521/tcp open  oracle
3306/tcp open  mysql
5520/tcp open  sdlog

Nmap run completed -- 1 IP address (1 host up) scanned in 0.206 seconds
[root at intra init.d]# telnet localhost 3306
Trying 127.0.0.1...
Connected to localhost.localdomain (127.0.0.1).
Escape character is '^]'.
4
5.0.24I0pd&-N#a,A^8;^I1XIDYrConnection closed by foreign host.
[root at intra init.d]# telnet 127.0.0.1 3306
Trying 127.0.0.1...
Connected to intra (127.0.0.1).
Escape character is '^]'.
4
5.0.24J|Q]`K6i2,ZN[[:O]ecCeQConnection closed by foreign host.
[root at intra init.d]# telnet 10.5.1.177 3306
Trying 10.5.1.177...
Connected to intra (10.5.1.177).
Escape character is '^]'.
CHost '10.5.1.177' is not allowed to connect to this MySQL serverConnection
closed by foreign host.
[root at intra init.d]#

-- 
Communications/Network and Systems Engineer



More information about the redhat-list mailing list