ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
hi experts ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) iam facing the above error while connecting the mysql database. i am also checked the mysql.sock socket file is not in /tmp. could you please help me to fix this problem. what i have to do now.. is there any way to replace the socket file from another mysql server or i have to reinstall mysql software in this server. if re-installation from the scratch mean what are the steps i have follow before and after installation to safeguard the existing databases.. please provide you assistance to fix this issue.. many thanks in advance.. Best Regards Faizal S GSM : 9840118673 Blog: http://oradbapro.blogspot.com
Re: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
The socket hets created when you start the server It might be in the mysql home dir, it might be in /var/run. See if its declared in my.cnf Sent via BlackBerry from T-Mobile -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
Hi thanks for your reply. i found the problem, the problem was due to maintenance activity IT team rebooted the machine but they didn't start the mysql server after reboot. i executed mysqld with root credit. i got the below output but still the cursor not return to prompt bash-2.03# /usr/local/mysql/libexec/mysqld -u root 091027 15:35:09 InnoDB: Started; log sequence number 0 625687 091027 15:35:10 [Note] /usr/local/mysql/libexec/mysqld: ready for connections. Version: '5.0.51-log' socket: '/tmp/mysql.sock' port: 3306 Source distribution can you verify this. is it correct. thanks in advance.. Best Regards Faizal S GSM : 9840118673 Blog: http://oradbapro.blogspot.com On Tue, Oct 27, 2009 at 12:03 PM, li...@up-south.com wrote: The socket hets created when you start the server It might be in the mysql home dir, it might be in /var/run. See if its declared in my.cnf Sent via BlackBerry from T-Mobile
Re: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
Hello. See: http://dev.mysql.com/doc/mysql/en/can-not-connect-to-server.html Billy Pilgrim [EMAIL PROTECTED] wrote: Hello, I installed MySQL 4.1.10 on Debian Ubuntu based following these directions: http://dev.mysql.com/doc/mysql/en/installing-binary.html I then logged in, changed root password, used test database, etc. Now after reboot I cannot connect. I get this: [EMAIL PROTECTED]:/usr/local/mysql/bin # ./mysql -u root -p Enter password: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) Please give options if this involves: manual server start, setting up autostart, etc. Thanks -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [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]
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
Hello, I installed MySQL 4.1.10 on Debian Ubuntu based following these directions: http://dev.mysql.com/doc/mysql/en/installing-binary.html I then logged in, changed root password, used test database, etc. Now after reboot I cannot connect. I get this: [EMAIL PROTECTED]:/usr/local/mysql/bin # ./mysql -u root -p Enter password: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) Please give options if this involves: manual server start, setting up autostart, etc. Thanks -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
