[ILUG] MySQL Problems

Linux ilug linux.michael at gmail.com
Wed Apr 6 18:38:13 IST 2005


Can anyone help me with this? I have a MySQL server running on port 3306 
everytime I try to connect to the my sql database I get the following 
returned from the java program I am running.

java.net.BindException: Address already in use
SQL error--: java.sql.SQLException: Cannot connect to MySQL server on 
localhost:3306. Is there a MySQL server running on the machine/port you
are trying to connect to? (java.net.ConnectException) 0 08S01

I have checked for mysql processes and the following is returned

linux:/opt # ps aux | grep mysql
root 8509 0.0 0.5 3496 1324 ? S 13:48 0:00 /bin/sh /usr/bin/mysqld_safe 
--user=mysql --pid-file=/var/lib/mysql/mysqld.pid 
--socket=/var/lib/mysql/mysql.sock --datadir=/var/lib/mysql
mysql 8544 0.0 0.8 21748 2252 ? Sl 13:48 0:00 /usr/sbin/mysqld 
--basedir=/usr --datadir=/var/lib/mysql --user=mysql 
--pid-file=/var/lib/mysql/mysqld.pid --skip-locking --port=3306 
--socket=/var/lib/mysql/mysql.sock
root 9588 0.0 0.2 1696 632 pts/2 S+ 17:32 0:00 grep mysql

I have installed the latest version of mysql and I can connect on to it with 
mysql administrator, query browser and others. Is there something I'm 
missing that you guy can help me with? Or if I haven't given enough 
information can you help me to diagnose it.

Thanks again
Mike



More information about the ILUG mailing list