Hi,
Thanks. After sending my mail I found out that the mysqld was not
running. Now it is fine.
Thanks once again
Adrian
On Tue, 17 Jul 2001 [EMAIL PROTECTED] wrote:
> 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
