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
Maintained by the ILUG website team. The aim of Linux.ie is to
support and help commercial and private users of Linux in Ireland. You can
display ILUG news in your own webpages, read backend
information to find out how. Networking services kindly provided by HEAnet, server kindly donated by
Dell. Linux is a trademark of Linus Torvalds,
used with permission. No penguins were harmed in the production or maintenance
of this highly praised website. Looking for the
Indian Linux Users' Group? Try here. If you've read all this and aren't a lawyer: you should be!