2010/10/11 Sabika M sabika.makhd...@gmail.com:
are the permissions on that directory correct? The .sock file is created at
start up by mysql
mysqld doesn't start because are missing /var/run/mysqld dir and
/var/run/mysqld/mysqld.sock file. Dir and file are created on mysqld
boot, i presume. It's
Hi,
This can be useful...
http://mafiree.com/blg/?p=124
-Partha
www.mafiree.com
- Original Message
From: spacemarc spacem...@gmail.com
To: MySQL mysql@lists.mysql.com
Sent: Mon, 11 October, 2010 12:37:24 AM
Subject: MySQL sock file is missing: server doesn't start
hi
MySQL server
2010/10/11 partha sarathy par...@mafiree.com:
Hi,
This can be useful...
http://mafiree.com/blg/?p=124
i've checked your link but it doesn't work.
mysqld server is not running and if i want to start it i obtain 2002
error because the /var/run/mysqld/mysqld.sock file is missing.
If i start it
More often than not, this is a file permission issue. Does the MySQL
user have permission to create a socket in /var/run/mysqld ?try
ls -ld /var/run/mysqld
ls -l /var/run/mysqld
and make sure everything is owned by the MySQL user.
- michael dykman
On Mon, Oct 11, 2010 at 2:09 PM,
hi
MySQL server doesn't start because #2002 the
/var/run/mysqld/mysqld.sock is missing.
The server only start with sudo mysqld_safe but without the mysqld.sock file.
I've checked my /etc/mysql/my.cnf file and the paths are correct for
[client] and [mysqld]: /var/run/mysqld/mysqld.sock
I run
ERROR 2002: Can't connect to local MySQL server through socket
'/tmp/mysql.sock'
I accidentally deleted the above file, I can not connect any new connections
in the CLI, old stuff seems to still be ok.
I can not seem to shut down the server, as that file is needed.
Any way I can recreate it,
Shut it down with mysqladmin, from another machine using the -h (host)
option.
When you are using the CLI locally it connects through the socket, but
if you do it from another machine it will use TCP, getting around the
need for the missing socket file.
You may also be able to connect via TCP
michael johnson [EMAIL PROTECTED] wrote:
When trying to start mysql on a lx50 I get the following message:
Error 2002 Cannot connect to local MySQL server through socket
/var/lib/mysql/mysql.sock (111).
What can I do to resolve this problem pls?
Start MySQL or change the correct path to
When trying to start mysql on a lx50 I get the following message:
Error 2002 Cannot connect to local MySQL server through socket
/var/lib/mysql/mysql.sock (111).
What can I do to resolve this problem pls?
Regards
Michael Johnson