[ILUG] MySQL Problems

[Barry Flanagan]

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                 *:*                     
LISTEN     30661/mysqld   

..which shows that mysql is running and listening on the port.

-Barry


>
>
>
> 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
>         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
>>
>>
>>
>         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.
>
>         -Barry
>
>
>
> ------------------------------------------------------------------------
> 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 
> <http://canit.flanagan.ie/b.php?c=f&i=24880&m=b24393700b80>