as opposed to using safe_mysqld
try starting mysql using
/etc/init.d/rc.d/mysql start
and stopping using
/etc/init.d/rc.d/mysql stop
I had the same problem on a cobalt raq
running a variant of red hat and that
solved it.
Sean
-----Original Message-----
From: Adrian D'Costa [mailto:[EMAIL PROTECTED]]
Sent: 17 July 2001 08:32
To: Mysql Mailing List
Subject: mysql error
Hi,
I just installed a new version of mysql (not the latest) 3.23.36 which
came with rh 7.1 cd. I know that it is buggy but I have the following
problems that have been discussed in the list. I search the archives but
did not see how the problem got solved.
The error:
ERROR 2002: Can't connect to local MySQL server through socket
'/var/lib/mysql/mysql.sock' (111)
I did a ps aux | grep mysqld
root 924 0.0 0.0 1856 0 ? SW 09:55 0:00
[safe_mysqld]
mysql 974 0.0 0.0 12252 24 ? S 09:55 0:00 [mysqld]
mysql 986 0.0 0.0 12252 24 ? S 09:55 0:00 [mysqld]
mysql 987 0.0 0.0 12252 24 ? S 09:55 0:00 [mysqld]
When I try to restart or stop using /etc/init.d/mysqld stop
Stopping MySQL: [FAILED]
The log shows :
010717 12:34:42 mysqld started
010717 12:34:43 Can't start server: Bind on TCP/IP port: Address already
in use010717 12:34:43 Do you already have another mysqld server running
on port: 3306 ?
010717 12:34:43 Aborting
010717 12:34:43 mysqld ended
010717 12:50:02 mysqld started
010717 12:50:02 Can't start server: Bind on TCP/IP port: Address already
in use010717 12:50:02 Do you already have another mysqld server running
on port: 3306 ?
010717 12:50:02 Aborting
010717 12:50:02 mysqld ended
010717 12:55:26 mysqld started
/usr/libexec/mysqld: ready for connections
I tried to change the /etc/my.cnf socket to /tmp/mysql.sock but I still
get the error
ERROR 2002: Can't connect to local MySQL server through socket
'/var/lib/mysql/mysql.sock' (111)
How do I solve this as I am in the middle of a web database project
TIA
Adrian
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail
<[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php