[ILUG] MySQL Problems

[Barry Flanagan]

Linux ilug wrote:

> but is it no running on port 5690 when it should be running on port 
> 3306. or is 5690 representing something else ?
>
No, that is the process ID, the bit to the left  - '*:mysql' shows that 
it is listening on all interfaces ( the *) on the well-known port 'mysql'

'netstat -nlp|grep mysql ' will show the actual number of the port.

Your problem lies elsewhere.

Are you sure the error is the same?

Can you log into mysql on the command line to the same database and with 
the same username as you are asking the java app to?

# mysql -h 127.0.0.1 -u your_user -p your_database

-Barry


> On Apr 6, 2005 8:41 PM, *Barry Flanagan* <barryf-lists at flanagan.ie 
> <mailto:barryf-lists at flanagan.ie>> wrote:
>
>     Linux ilug wrote:
>
>     > That's what I got back.  Is there anyway to chance the port mysql is
>     > listening on?
>     >
>
>     Why? That looks fine.
>
>     -Barry
>
>     >
>     > linux:~ # netstat -lp | grep mysql
>     > tcp        0      0 *:mysql                 *:*
>     > LISTEN      5690/mysqld
>     > unix  2      [ ACC ]     STREAM     LISTENING     16531
>     > 5690/mysqld         /var/lib/mysql/mysql.sock
>     >
>     >
>