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