hello,
i'm fr malaysia. i'm using slackware 11.0 as my mysql server. until today i already 2 weeks study how to connect mysql server in my lan. i tried to telnet mysql server on port 3306 but can't. when i run this command fr client here the result.
nmap -v 192.168.1.5
Starting Nmap 4.11 (
http://www.insecure.org/nmap/ ) at 2007-05-03 17:11 MYT
Initiating ARP Ping Scan against 192.168.1.5 [1 port] at 17:11
The ARP Ping Scan took 0.00s to scan 1 total hosts.
Initiating SYN Stealth Scan against testing.techmedia.com.my (192.168.1.5) [1680 ports] at 17:11
Discovered open port 22/tcp on 192.168.1.5
Discovered open port 113/tcp on 192.168.1.5
Discovered open port 37/tcp on 192.168.1.5
Discovered open port 3306/tcp on 192.168.1.5
Discovered open port 6000/tcp on 192.168.1.5
The SYN Stealth Scan took 0.10s to scan 1680 total ports.
Host testing.techmedia.com.my (192.168.1.5) appears to be up ... good.
Interesting ports on testing.techmedia.com.my (192.168.1.5):
Not shown: 1675 closed ports
PORT STATE SERVICE
22/tcp open ssh
37/tcp open time
113/tcp open auth
3306/tcp open mysql
6000/tcp open X11
MAC Address: 00:17:9A:3A:13:58 (D-Link)
i tried telnet from mysql server itself n here the result
root@test:~# telnet 192.168.1.5 3306
Trying 192.168.1.5...
Connected to 192.168.1.5.
Escape character is '^]'.
5
5.0.24ape-Lv0+%,uA#+O+(%#}p:Connection closed by foreign host.
root@test:~#
when i tried telnet fr client here the result
telnet 192.168.1.5 3306
Trying 192.168.1.5...
Connected to 192.168.1.5.
Escape character is '^]'.
DHost '192.168.1.1' is not allowed to connect to this MySQL serverConnection closed by foreign host.
here my mysql server startup command
usr/bin/mysqld_safe --bind-address="0.0.0.0" --datadir=/var/lib/mysql --pid-file=/var/run/mysql/mysql.pid $SKIP &
CAN ANYBODY GUIDE ME HOW TO CONNECT MYSQL SERVER