MySQL ERROR 2002 (HY000): Can't connect to local...

[bfyrth]

Yes AJ you know you shouldnt be allowed anywhere near code to start with

Ben

[mcwafflestix]

I think I've figured this one out; I was trying to install mysql on my machine. The machine is a Dell Mini 9 (yes, I know) with the original 4GB SSD (yes, I know, again).

I kept getting this message:

 subprocess pre-removal script returned error exit status 1
/etc/lsb-base-logging.sh: line 84: INITOUTPUT: unbound variable

I eventually managed to get this result:

 * /etc/init.d/mysql: ERROR: The partition with /var/lib/mysql is too full!

So I'm going to try to free up some space and complete the removal. For what it's worth, I am getting a 32GB SSD to install in this machine, which should give me plenty of space; and yeah, I know this isn't at ALL a normal use for a machine this tiny, but I just want to do some light development on the go, and it's the perfect form factor for it. And for what it's worth, Eclipse runs beautifully on it!

[sevenearths]

Yes AJ you know you shouldnt be allowed anywhere near code to start with

Ben

AHHHHH!!! 'First cup of Ubuntu' isn't that sweet!

[ardnet]

Hi All,

I'm new Ubuntu user, and also having the same problem like this.
And I've been read through all this post, and just wanna inform you guys that the conclusion is because..... the disk is full.

Try to restart mysql and it will tell you the problem,
by using this command: sudo /etc/init.d/mysql restart
And after that, I got this message:
* /etc/init.d/mysql: ERROR: The partition with /var/lib/mysql is too full!

Then I removed any file that I think is useless to save up some space, then restart mysql again... Voila!!! Works for me

Thanks

[susenj]

Thank you so much. When i opened Services from the administration , i got that Mysql server is checked by deafult. i unchecked it amd then checked it once again. Wow..it was running. Everything is peachy. Thanks

Your mysql server is not running!

I don't have my Ubuntu system available at this moment, but I believe if you navigate into the System->Administration pull-down, there is a menu option to control "services" or something to that effect.

From there, you can start the mysql server. Then you should be able to connect (that is, log on).

http://susenj.wordpress.com

[acho]

Yup

I had the same problem before. but re-installing fix the problem....thx.

[Fitch]

Ubuntu 9.10 doesn't have "services"
It's got the following:
Computer Janitor
Disk Utility
Hardware Drivers
Language Support
Logfile Viewer
Login Screen
Mount Manager
Netwrk
Network Tools
Printing
Samba
Software Sources
Synaptic Package Manager
System Monitoring
System Testing
Time and Date
Update Manager
USB Startup Disk Creator
User Groups

So now what?

I was trying to install ZoneMinder and after about a week, the aforementioned error is all I get.
And Yes mysql doesn't run on startup.

[jameshogan]

Hey Guys,

Yup, I've go the same problem, having just upgraded from 9.04 to to 9.10. I've gotta say, with 9.10, I've had nothing but hassles with this upgrade! Too soon?

I'm trying to figure out where its all going wrong too. From here: http://theos.in/desktop-linux/tip-th...-mysql-server/
I'm finding that starting mysql server isn't happening. Same story as above: I've installed, reinstalled, completely reinstalled, chmoded and everything. No joy.

I'll keep trying to nut it out and keep an eye here for answers, or (fingers crossed) to post some solutions.

[grantbuntu]

Just confirming that this is a problem. Everything stopped working after the upgrade to karmic. Uninstalling and reinstalling worked until I rebooted. Anyone know the answers?

[rugger0]

Deleted by author. Opening new thread since this one starts with SOLVED and talks about 8.04