Remote Connect To Mysql Server
 

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

uncomment the line SKIP="--skip-networking"

and also make sure that the host column doesn't contain localhost or you will never be able to connect to that host :D

It means put sharp sign # in the front of variable SKIP in file /etc/rc.d/rc.mysqld. See line 32 of the script for Slackware64 13.1.

Why not simply connect with this line
from the Lan. You will well need to set this user and host up on the server first to allow access. it should then just work. Have a look at the Mysql manuals if unsure.