On Thu, Feb 10, 2011 at 06:35:13AM -0800, Erin Brinkley wrote:
Hi guys,

I came in ready to tackle my ongoing problems with this Lenny to Squeeze 
upgrade today, and found yet another one! :(

I run MySQL locally and access the databases all the time with phpmyadmin in a 
browser. Today I tried to log in and got this error:

#2002 Cannot log in to the MySQL server

So then I checked a local Wordpress install, and when I tried to load the URL 
it gave me this:

Error establishing a database connection

As root I tried "/etc/init.d/mysql restart" and got the same problem. But looking at 
"ps aux|grep sql" there's nothing listed, so that tells me that MySQL isn't running at 
all!

$ mysql -h localhost -u m -D bigdata
ERROR 2002 (HY000): Can't connect to local MySQL server through socket 
'/var/run/mysqld/mysqld.sock' (2)
$

Ok, something bad has happened here!

I didn't change anything at all. It was working perfectly a few days ago. All I 
did was upgrade. I am sort of afraid of doing anything radical right now that 
will hurt these databases. But this seems very wrong. Why would an upgrade make 
it so that mysql can't even run? Anyone have any idea where I should look or 
what to do?

Hi Erin,

Can you check to see if mysql-server is installed? After my upgrade on one machine from lenny to squeeze it went missing. The MySQL client was installed, but the server part was gone. An 'apt-get install mysql-server'
was enough to bring it back, including the database I had.

Remco

Attachment: signature.asc
Description: Digital signature

Reply via email to