2010/10/11 Sabika M :
> 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 cyc
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, spacemar
2010/10/11 partha sarathy :
> 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 with "sudo mysq
Hi,
This can be useful...
http://mafiree.com/blg/?p=124
-Partha
www.mafiree.com
- Original Message
From: spacemarc
To: MySQL
Sent: Mon, 11 October, 2010 12:37:24 AM
Subject: MySQL sock file is missing: server doesn't start
hi
MySQL server doesn't start because #2002 th
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 5.1.
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 f
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, an
"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
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
