Linux ilug wrote:
> Unfortunately It's still giving the same error! Anyone else have any
> ideas ?
do a 'netstat -lp | grep mysql' and you should see a line like:
tcp 0 0 *:mysql *:*
..which shows that mysql is running and listening on the port.
>>>> On Apr 6, 2005 7:04 PM, *Linux ilug* <linux.michael at gmail.com> <mailto:linux.michael at gmail.com>> wrote:
>> actually I found it with a bit of googling it was under /etc/my.cnf
>> Thanks man
>>> On Apr 6, 2005 6:49 PM, *Barry Flanagan* <barryf-lists at flanagan.ie> <mailto:barryf-lists at flanagan.ie>> wrote:
>> Linux ilug wrote:
>>>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
>>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
>>>>>>> You are trying to connect with it over TCP but the mysql
> server is only
> using unix sockets, as in some dists tcp is turned off for
> security reasons.
>> Tell your java program to use unix sockets or, look in
> /etc/mysql/my.conf (or similar) and comment out the line
> "skip-networking", then restart mysql.
> Teach CanIt if this mail (ID 24880) is spam:
> /NOTE:/ This message has been trained as non-spam. If this is wrong,
> please correct the training as soon as possible.
> Spam <http://canit.flanagan.ie/b.php?c=s&i=24880&m=b24393700b80>
> Not spam <http://canit.flanagan.ie/b.php?c=n&i=24880&m=b24393700b80>
> Forget previous vote
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!