Hi Jon,
The socket is created on demand. The error message said the server
failed to start, not that your socket has disappeared ipso facto the
socket will not have been created.
That is why you can't connect, your server is not running. You need to
check the system and mysql logs as mentioned in the message and relay
what the error messages are in there. That will give you a good idea as
to the possible cause of it failing to start.
We need to identify why the server didn't start before going to such
drastic lengths as re-installing.
Regards
---------------------------------------------------------------
********** _/ ********** David Logan
******* _/ ******* ITO Delivery Specialist - Database
***** _/ ***** Hewlett-Packard Australia Ltd
**** _/_/_/ _/_/_/ **** E-Mail: [EMAIL PROTECTED]
**** _/ _/ _/ _/ **** Desk: +618 8408 4273
**** _/ _/ _/_/_/ **** Mobile: 0417 268 665
***** _/ ******
****** _/ ******** Postal: 148 Frome Street,
******** _/ ********** Adelaide SA 5001
Australia
i n v e n t
---------------------------------------------------------------
-----Original Message-----
From: Jon Miller [mailto:[EMAIL PROTECTED]
Sent: Saturday, 7 January 2006 7:58 PM
To: Logan, David (SST - Adelaide)
Subject: RE: missing mysqld.sock
Tried everything on that page and nothing help. As I've stated the
mysqld.sock file is no longer on the system. This was working prior to
me trying to remove the older version of mysql.
Should I just bite the bullet and do a apt-get purge mysql-server and do
a reinstall?
Jon
>>> "Logan, David (SST - Adelaide)" <[EMAIL PROTECTED]> 3:45:59 pm
7/01/2006 >>>
Hi Jon,
This reference will give you all the info you need.
http://dev.mysql.com/doc/refman/4.1/en/can-not-connect-to-server.html
Regards
---------------------------------------------------------------
********** _/ ********** David Logan
******* _/ ******* ITO Delivery Specialist - Database
***** _/ ***** Hewlett-Packard Australia Ltd
**** _/_/_/ _/_/_/ **** E-Mail: [EMAIL PROTECTED]
**** _/ _/ _/ _/ **** Desk: +618 8408 4273
**** _/ _/ _/_/_/ **** Mobile: 0417 268 665
***** _/ ******
****** _/ ******** Postal: 148 Frome Street,
******** _/ ********** Adelaide SA 5001
Australia
i n v e n t
---------------------------------------------------------------
-----Original Message-----
From: Jon Miller [mailto:[EMAIL PROTECTED]
Sent: Saturday, 7 January 2006 5:59 PM
To: mysql@lists.mysql.com
Subject: missing mysqld.sock
I've installed mysql 4 and noticed that both mysql 4.0 and 4.1 was on
the system. In my attempt to remove the older version I may have done
away with my mysqld.sock. When I try to access mysql i'm getting the
following message:
debOS:~# /etc/init.d/mysql start
Starting MySQL database server: mysqld...failed.
Please take a look at the syslog.
/usr/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket
'/var/run/mysqld/mysqld.sock' (2)'
Check that mysqld is running and that the socket:
'/var/run/mysqld/mysqld.sock' exists!
Any ideas?
Thanks
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
