MySQL does not run (no socket)

tot · n00b Joined: 09 Jun 2003 Posts: 12 Location: Canada

try adding a -p at the end of
mysqladmin -u root -h localhost password ladida -p
like so.
i was getting that error for hours. a major irritance.

violator · n00b Joined: 28 Oct 2003 Posts: 25

has anyone found a solution to this problem? I'm having it too, and I've tried all the methods in the bugs.gentoo.org report, but none seem to work and I can't find any way to fix it. Permissions are set correctly on all dirs, and the /var/tmp solution just makes mysql hang after login.

Decker · Posted: Mon Dec 15, 2003 9:26 am Post subject:

Did you ever try to give all permissions to everyone to /var/run/mysqld/ ?

Why does mysql hang? How did you connect to mysql? Can you please post the contents of the following log files:
/var/log/mysql/mysql.log
/var/log/mysql/mysql.err

jflasch · n00b Joined: 02 Sep 2002 Posts: 12

My permissions for /var/run were 770. I changed them to 775 and now mysqld works as user mysql. Seems when I made my self user mysql (su - mysql) you can't do a cd /var/run/mysqld or a touch /var/run/mysqld/xx . After the change this works and I can start /etc/init.d/mysql start , and all works..... :lol:

derheld42 · Posted: Tue Jan 27, 2004 2:10 am Post subject:

Check the permissions of the database directories in /var/lib/mysql:

ls -la /var/lib/mysql

I noticed that mine were owned by root.root -- I don't know how that happened.... and so I fixed them:

cd /var/lib/mysql
chown mysql.root *

Hope it helps!

AceTheFace · n00b Joined: 16 Aug 2003 Posts: 49 Location: Germany/Ulm

Hi there,

i've got this problem, too. After starting mysqld with /etc/init.d/mysql start I can't connect to it:

derheld42 · Posted: Thu Mar 18, 2004 8:52 am Post subject:

What do these two files contain?
/var/log/mysql/mysql.log
/var/log/mysql/mysql.err

AceTheFace · n00b Joined: 16 Aug 2003 Posts: 49 Location: Germany/Ulm

rodericj · Posted: Sun Mar 21, 2004 10:17 pm Post subject:

[quote]
/usr/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'
Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists!
[\quote]

And if it doesn't exist?

I seem to see in this thread that everyone has a /var/run/mysqld/mysqld.sock file. I do not.

What does a sock file do? Does it determine the socket information or something?
What do I do in order to find or create mysqld.sock file?

Thanks guys.

rockfly · Apprentice Joined: 27 Apr 2003 Posts: 179

after i updated mysql, it got "solved"

infecticide · Posted: Tue Apr 13, 2004 8:33 pm Post subject:

I've got a slightly different variation of this problem. I'm sure that it has to do with permissions as well. I currently have a WinXP installation on /dev/hda1 and my Gentoo is on /dev/hdb1(boot) and /dev/hdb2(root) I began with Linux by using a copy of Knoppix and I setup a Apache, PHP, MySQL. Worked just fine. I have the same setup on the windows install. When I had knoppix I was able to have it retrevie the files from the windows drive and interact with them without a problem.

I can't seem to get MySQL or Apache to utilize the files on the other drive anymore. I attempted to chown mysql.mysql /mnt/windows/data

infecticide · Posted: Tue Apr 20, 2004 10:27 am Post subject:

Problem fixed by adding gid=users, uid=0000 to fstab on the vfat line.

b060 · Posted: Mon Apr 26, 2004 10:53 pm Post subject: Lost mysql pass!!

Kinda stuck here help!!!

vyral_surfer · n00b Joined: 18 Jul 2004 Posts: 3

I had the same problem many of you are having and managed to get rid of it (although now i've got a problem with phpBB accessing the database, but thats for a different topic

). I mounted the directory that mysql's databases are stored in (/var/lib/mysql) like this in fstab:

lysergicacid · Posted: Thu Aug 19, 2004 5:01 am Post subject:

lysergicacid · Posted: Thu Aug 19, 2004 5:29 am Post subject:

bah so much for that idea, i dropped all socket restrictions and its still the same

G3n2 · Tux's lil' helper Joined: 09 Aug 2004 Posts: 127

im getting this error:

G3n2 · Tux's lil' helper Joined: 09 Aug 2004 Posts: 127

well , i chmodded 775 to /var/run/mysql and chowned mysql:root to it , now e107 works , but phpmyadmin gives this error :

qno · n00b Joined: 26 Aug 2004 Posts: 1

Hello!

I had exactly the same problems - after some searching i found a solution for this problem.

In mysql.err - file was a problem reported with bdb

uninstall mysql and do:

G3n2 · Tux's lil' helper Joined: 09 Aug 2004 Posts: 127

not to pick on u or anything

but i have mysql and berkdb together :

Adwin · Posted: Tue Apr 11, 2006 7:05 pm Post subject:

Fool proof solution is here:

https://forums.gentoo.org/viewtopic.php?t=373031

It seems like the new ebuilds screw around with improper permissions.

maigret · Posted: Mon Apr 17, 2006 4:10 pm Post subject:

For me, the solution was in this topic:

https://forums.gentoo.org/viewtopic-t-361978-highlight-error+iblogfile0+mysql.html

richard.scott · Posted: Tue Apr 18, 2006 11:56 am Post subject:

I think that I've found a possible fix for this

When executing /etc/init.d/mysql for the first time, it tells us to run the mysql_install_db

and when you execute mysql_install_db it doesn't set the file access rights on /var/lib/mysql/*

to fix this, I've been running: