Re: MySQL sock file is missing: server doesn't start
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 cyclic! 2010/10/12 partha sarathy par...@mafiree.com: 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 mdyk...@gmail.com: 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=arch...@jab.org
Re: MySQL sock file is missing: server doesn't start
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 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=par...@mafiree.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: MySQL sock file is missing: server doesn't start
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 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=arch...@jab.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 spacem...@gmail.com wrote: 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 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=mdyk...@gmail.com -- - michael dykman - mdyk...@gmail.com May 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=arch...@jab.org
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=arch...@jab.org
Deleted sock file, how can I recover
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, and what do I put in it? I can force kill the server and I am guessing it would all come back up ok, but there must be a gentler way? -- - Scott HanedaTel: 415.898.2602 http://www.newgeo.com Novato, CA U.S.A. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Deleted sock file, how can I recover
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 from the local machine, depending on what address you use to connect to. (local IP, local host, actual hostname, etc). -Ryan Scott Haneda wrote: 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, and what do I put in it? I can force kill the server and I am guessing it would all come back up ok, but there must be a gentler way? -- - Scott HanedaTel: 415.898.2602 http://www.newgeo.com Novato, CA U.S.A. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: sock file
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 socket file. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
sock file
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