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