MY SQL cant connect to sock

kizuna · 03-28-2005, 07:47 PM

I installed My SQL and when i try to start the it up i get this

Code:

~# mysql start
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111)

Any ideas to why this is happening and how to fix it.
thanks in advanced

BrianW · 03-28-2005, 07:56 PM

Quote:

/etc/rc.d/rc.mysql

# Before you can run MySQL, you must have a database. To install an initial
# database, do this as root:
#
# su - mysql
# mysql_install_db
#
# Note that step one is becoming the mysql user. It's important to do this
# before making any changes to the database, or mysqld won't be able to write
# to it later (this can be fixed with 'chown -R mysql.mysql /var/lib/mysql').

Try this.

kizuna · 03-28-2005, 08:19 PM

Quote:

Originally posted by BrianW
Try this.

nope still getting the sme message

raven.sorrow · 03-29-2005, 11:45 PM

I have a slack10 distro running the stock kernel (2.4.26) the default mysql package refused to start perperly so I removed it and built mysql frrom source, this worked flawwlessly. After that I followed these commands:

Code:

/etc/rc.d/rc.mysqld start

then

Code:

su - mysql
cd /usr/local/mysql/bin
./mysql_install_db
exit
/usr/local/mysql/bin/mysqladmin -u root password 'SoMePaSs'

I got this error:

Code:

/usr/local/mysql/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)'
Check that mysqld is running and that the socket: '/tmp/mysql.sock' exists!
root@biggeek:/usr/local/mysql#

/tmp/mysql.sock doesn't exist. I can create the file but what port/socket goes in the file so mysql knows how to connect to itself?

Patchy · 11-11-2005, 05:14 PM

Quote:

Originally posted by raven.sorrow
I have a slack10 distro running the stock kernel (2.4.26) the default mysql package refused to start perperly so I removed it and built mysql frrom source, this worked flawwlessly. After that I followed these commands:

Code:

/etc/rc.d/rc.mysqld start

then

Code:

su - mysql cd /usr/local/mysql/bin ./mysql_install_db exit /usr/local/mysql/bin/mysqladmin -u root password 'SoMePaSs'

I got this error:

Code:

/usr/local/mysql/bin/mysqladmin: connect to server at 'localhost' failed error: 'Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)' Check that mysqld is running and that the socket: '/tmp/mysql.sock' exists! root@biggeek:/usr/local/mysql#

/tmp/mysql.sock doesn't exist. I can create the file but what port/socket goes in the file so mysql knows how to connect to itself?

The 2 at the end means the mysql service isn't started. In SuSE, i use the command "rcmysql start" to start the mysql server.

Edit: my reasoning is that code 2 means mysql.sock doesn't exist. When the mysql server is started it creates the mysql.sock file. When the mysql server is stopped (e.g. when the computer is shut down) it removes it.

I am having the code 111 error like the topic starter. Attention back on this please?

I had code 111 error with SuSE 9.3 as well as 10.0. It was 'fixed' in 9.3 by manually restarting the server ("rcmysql restart") after it had automatically started at boot time. This doesn't work for SuSE 10.0.

The problem happened while I was configuring apache2 to have virtual sites. I had also used phpmyadmin to change user permissions in the mysql table.

Edit2:

In mysqld.log:

Quote:

051111 23:43:13 mysqld started
/usr/sbin/mysqld: Can't read dir of '/var/lib/mysql/tmp/' (Errcode: 2)
/usr/sbin/mysqld: Can't create/write to file '/var/lib/mysql/tmp/ibsf1v7z' (Errcode: 2)
051111 23:43:13 InnoDB: Error: unable to create temporary file; errno: 2
051111 23:43:13 [ERROR] Can't init databases
051111 23:43:13 [ERROR] Aborting

051111 23:43:13 [Note] /usr/sbin/mysqld: Shutdown complete

051111 23:43:13 mysqld ended

Any more thoughts?

Namaseit · 11-11-2005, 05:45 PM

use /etc/rc.d/rc.mysql start to start mysql. you might have to chmod it so you can execute it.

make sure your /var/lib/mysql directory is owned by the myqsl user and not root otherwise you'll be banging your head again.

Patchy · 11-11-2005, 06:03 PM

SOLVED

Following my post and edit 2.

I have:

- Stopped the mysql server using the SuSE command "rcmysql stop". I expect something like "/etc/rc.d/rc.mysql stop" for Slack'.
- Modified /etc/my.cnf so that [mysqld] has a datadir= variable, the path to the data. For me it is "/var/lib/mysql".
- Removed any existing mysql.sock file.
- Created a directory in the same directory that mysql.sock is created in called 'tmp' and given its ownership to user 'mysql' and group 'mysql'
- Started the mysql server.

It now works fine.

raven.sorrow · 11-12-2005, 07:49 AM

I as well solved this problem. When I had did this, I had changed my /tmp over to it's own partition to aliviate space issues on /. I neglecvted to 'chmod 1777 /tmp/' once I had done this, it allowed mysql to create '/tmp/mysql/sock' as it's self and it worked but I have since moved away from slack10 and use Gentoo now. A Much better, powerful and robust OS IMHO.