Can't connect to MySQL server

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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@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@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@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@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@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@intra init.d]#

--
Communications/Network and Systems Engineer
--
redhat-list mailing list
unsubscribe mailto:redhat-list-request@xxxxxxxxxx?subject=unsubscribe
https://www.redhat.com/mailman/listinfo/redhat-list

[Index of Archives]     [CentOS]     [Kernel Development]     [PAM]     [Fedora Users]     [Red Hat Development]     [Big List of Linux Books]     [Linux Admin]     [Gimp]     [Asterisk PBX]     [Yosemite News]     [Red Hat Crash Utility]


  Powered by Linux