Re: Newly installed mysql 4.0

[Paul DuBois]

At 11:32 -0800 3/17/04, ryan@stripped wrote:
>Hey,
>thanks for replying.
>
>>  Your mysql server is not running my friend! =)
>>
>>  Try /etc/init.d/mysqld start <-- this should be able to turn it on!
>>  You can not change the passwords with the server off
>
>
>I finally found the correct place to start  and did this:
>
>/usr/sbin/mysqld start
>
>but got back this message:
>
>Starting MySQL:                                            [FAILED]
>You have new mail in /var/spool/mail/root
>[root@bestweb root]# /usr/sbin/mysqld start
>040317 21:30:50  Can't start server: Bind on TCP/IP port: Address 
>already in use
>040317 21:30:50  Do you already have another mysqld server running 
>on port: 3306 ?
>040317 21:30:50  Aborting
>
>040317 21:30:50  /usr/sbin/mysqld: Shutdown Complete
>
>Now what do I do?

Okay, that appears to indicate that the server *is* running, so perhaps
it's using a different socket file than your old server.

Do you have a /var/lib/mysql/mysql.sock file?  How about /tmp/mysql.sock?

Try using mysqladmin to connect using a TCP/IP connection rather than
through the socket file:

mysqladmin -u root -h 127.0.0.1 variables

If that works, look through the output to see what the value of "socket"
is.

-- 
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB, www.mysql.com

MySQL Users Conference: April 14-16, 2004
http://www.mysql.com/uc2004/