LinuxQuestions.org
Welcome to the most active Linux Forum on the web.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Server
User Name
Password
Linux - Server This forum is for the discussion of Linux Software used in a server related context.

Notices


Reply
  Search this Thread
Old 05-03-2011, 03:24 AM   #1
thoufiq
LQ Newbie
 
Registered: Apr 2011
Posts: 22

Rep: Reputation: Disabled
Can't connect to local MYSQL server through socket '/tmp/mysql.sock' (2)


Hello All,
When i am trying to upgrade from mysql5.1 to mysql5.5, i got a errors like this

root@dhcppc4:~# mysql_upgrade
Looking for 'mysql' as: mysql
Looking for 'mysqlcheck' as: mysqlcheck
Running 'mysqlcheck' with connection arguments: '--port=3306' '--socket=/tmp/mysql.sock'
mysqlcheck: Got error:2002:Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) when trying to connect
FATAL ERROR: Upgrade failed


Also, when i am trying to stop and start the mysql server, it tells that dhcppc4.pid file is not found.

Pls, anyone help me to overcome from this error.

Thanks a lot.
 
Old 05-03-2011, 03:51 PM   #2
rylan76
Senior Member
 
Registered: Apr 2004
Location: Potchefstroom, South Africa
Distribution: Fedora 17 - 3.3.4-5.fc17.x86_64
Posts: 1,552

Rep: Reputation: 103Reputation: 103
Are you sure your MySQL server is running when you try to do that?

E. g. your error message looks exactly like what you should get if MySQL is not running...

E. g. as far as I know, the /tmp/mysql.sock only exists if MySQL is running - if it is not there, your MySQL is either not running at all or has been switched to have its socket file (used for communication with the MySQL server instance running on the machine) somewhere else.

Last edited by rylan76; 05-03-2011 at 03:53 PM.
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
HTTPD: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' markseger Fedora - Installation 2 02-10-2011 12:53 AM
Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) sammy007 Linux - Networking 1 01-30-2010 07:32 AM
Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) cygnus-x1 Linux - Software 2 06-05-2008 02:14 PM
Buzilla issue: "Can't connect to local MySQL server through socket '/tmp/mysql.sock'" vitopn Linux - General 3 05-21-2007 11:13 AM
Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) Splenden Linux - Server 1 04-05-2007 09:34 PM

LinuxQuestions.org > Forums > Linux Forums > Linux - Server

All times are GMT -5. The time now is 10:57 AM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Open Source Consulting | Domain Registration