MySQL sock file is missing: server doesn"t start

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.41 on Ubuntu 10.04

How to resolve this issue?

thanks

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

Re: MySQL sock file is missing: server doesn"t start

Hi, This can be useful...=0Ahttp://mafiree.com/blg/?p=3D124 -Part=
ha=0Awww.mafiree.com ----- Original Message ----=0AFrom: spacema=
rc =0ATo: MySQL =0ASent: Mon, 1=
1 October, 2010 12:37:24 AM=0ASubject: MySQL sock file is missing: server d=
oesn't start hi=0AMySQL server doesn't start because #2002 the=0A/var/=
run/mysqld/mysqld.sock is missing.=0AThe server only start with "sudo mysql=
d_safe" but without the mysqld.sock file. I've checked my /etc/mysql/m=
y.cnf file and the paths are correct for=0A[client] and [mysqld]: /var/run/=
mysqld/mysqld.sock=0AI run 5.1.41 on Ubuntu 10.04 How to resolve this =
issue? thanks -- =0AMySQL General Mailing List=0AFor list archive=
s: http://lists.mysql.com/mysql=0ATo unsubscribe: http://lists.mysql.com=
/mysql?unsub=3Dpartha@mafiree.com

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dgcdmg-mysql-2@m.gmane.o rg

Re: MySQL sock file is missing: server doesn"t start

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 mysqld_safe start" the server starts for some
seconds, the /var/run/mysqld/ dir is created and after it stops by
itself.

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

Re: MySQL sock file is missing: server doesn"t start

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, spacemarc wrote:
> 2010/10/11 partha sarathy :
>> Hi,
>>
>> This can be useful...
>> http://mafiree.com/blg/?p=3D124
>
> 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 mysqld_safe start" the server starts for some
> seconds, the /var/run/mysqld/ dir is created and after it stops by
> itself.
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: =A0 =A0http://lists.mysql.com/mysql?unsub=3Dmdykman@gmail=
..com
>
>



--=20
=A0- michael dykman
=A0- mdykman@gmail.com

=A0May the Source be with you.

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dgcdmg-mysql-2@m.gmane.o rg

Re: MySQL sock file is missing: server doesn"t start

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 cyclic!

2010/10/12 partha sarathy :
> once mysqld gets started then only we can see the sock file and use the same to
> connect to mysql prompt.
> check your error log... some error message will be there. make it correct
> otherwise reply the error msg.

101012 20:21:29 [Note] Plugin 'FEDERATED' is disabled.
101012 20:21:30 InnoDB: Started; log sequence number 0 44263
101012 20:21:30 [ERROR] Can't start server : Bind on unix socket: No
such file or directory
101012 20:21:30 [ERROR] Do you already have another mysqld server
running on socket: /var/run/mysqld/mysqld.sock ?
101012 20:21:30 [ERROR] Aborting
101012 20:21:30 InnoDB: Starting shutdown...
101012 20:21:31 InnoDB: Shutdown completed; log sequence number 0 44263
101012 20:21:31 [Note] mysqld: Shutdown complete


2010/10/12 Michael Dykman :
> 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.

now, i have created the /var/run/mysqld dir and change the own to mysql user:
"sudo chown mysql:mysql mysqld"
The ls -ld output is:
drwxr-xr-x 2 mysql mysql 40 2010-10-12 20:31 /var/run/mysqld

The result is still 2002 error!

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org