problems connecting to mysql server across network... arg!!
Posted by:
Mike
Date: August 29, 2005 12:14PM
Hi all.
Right now I have two linux boxes running fedora core 4 on my home network, with mysqld up and running on "hostname_1" (a desktop). I want to log into the mysql server on the desktop using a mysql client on my laptop ("hostname_2"). Simple enough... but I must be missing something. check it out:
[user@hostname_1]$ mysqladmin ping -h hostname_1
mysqld is alive
[user@hostname_2]$ mysqladmin ping -h hostname_1
mysqladmin: connect to server at 'hostname_1' failed
error: 'Lost connection to MySQL server during query'
but then if I netstat it....
[user@hostname_1]$ netstat -ltp
Active Internet connections (only servers)
Proto Recv-Q Send-Q Local Address Foreign Address State PID/Program name
....... ------- ......
tcp 0 0 *:mysql *:* LISTEN -
....... ------- ......
and nmap gives me:
[root@hostname_1]$ nmap -sT -O hostname_1
PORT STATE SERVICE
..... ------ .......
3306/tcp open mysql
..... ------- .......
So it looks like the mysql server is up and running and listening on hostname_1.... but I can't figure out why I can't connect to it with the mysql client on hostname_2. Any ideas??
thanks a bunch, take it easy
Mike (linux & mysql semi-newbie)
Subject
Written By
Posted
problems connecting to mysql server across network... arg!!
August 29, 2005 12:14PM
September 02, 2005 12:35AM
September 04, 2005 11:06PM
September 13, 2005 06:54AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.