MySQL Error

brokenflea · 08-05-2004, 06:35 PM

i've installed mysql-4.0.20 on my slack 10 machine and everytime i try to run /usr/local/bin/mysql
it comes up with this error:

"ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

i've googled up this error and everything i've done doesn't work.... please help

TIA

kmoffat · 08-05-2004, 06:42 PM

Is it running? Try "ps -e | grep mysql" to see if processes are running.
Make sure /etc/rc.d/rc.mysqld is executable.
You can start it using:
/etc/rc.d/rc.mysqld start

(or restart instead of start.)

brokenflea · 08-05-2004, 06:44 PM

i don't see a rc.mysqld file in the /etc/rc.d directory..... i know i messed up somewhere, but is the file automatically generated or do i have to make up a script ?

shilo · 08-05-2004, 06:47 PM

Maybe this will help:

http://www.unixfool.com/mysql-slack.shtml

/etc/rc.d/rc.mysqld is automatically generated. Did you use the official Slackware package to install mysql?

brokenflea · 08-05-2004, 06:56 PM

ok, i finally managed to copy the executable script from mysql/support-files to /etc/rc.d , and i have the daemon running, but when i try to do /usr/local/bin/mysql, it comes up as :

ERROR 1045: Access denied for user : 'root@localhost' (Using password: NO)

i know this has something to do with the mysql user, but i'm stuck in a rut with this one.
thanks for all your help

TBomb · 08-12-2004, 11:44 AM

I'm getting a similar problem.

"ERROR 2002: Can't connect to local MySQL server through socket '/var/run/mysql.sock' (2)

I did the mysql_install_db thing like it said at http://www.unixfool.com/mysql-slack.shtml, it does it without any errors, but then when I type mysql again, it shows the same old error. I had this problem when I installed Slack 9.1, official packages. Now I'm having the exact same problem after doing a clean install of slack 10.

gbonvehi · 08-12-2004, 11:51 AM

Hey TBomb do you have a firewall running? MySQL needs port 3306 to work trough socket.
brokenflea, that means that you have to supply a password when trying to connect, if i don't remember wrong you have to issue the mysql command with the -p parameter.

TBomb · 08-12-2004, 11:56 AM

I don't have a firewall running locally, but on my router. But I'm running this command locally, so I don't see how thats effecting it.

TBomb · 08-12-2004, 11:58 AM

I checked the /var/run directory, which is where the error says it can't connect to. The directory is completely empty.

gbonvehi · 08-12-2004, 12:09 PM

Check your mysql config file and see if you have this:

Code:

# The following options will be passed to all MySQL clients
[client]
port            = 3306
socket          = /var/run/mysql/mysql.sock

# The MySQL server
[mysqld]
port            = 3306
socket          = /var/run/mysql/mysql.sock

And this line must not exist or be commented like here (i'm talking about skip-networking line):

Code:

 # Don't listen on a TCP/IP port at all. This can be a security enhancement,
# if all processes that need to connect to mysqld run on the same host.
# All interaction with mysqld must be made via Unix sockets or named pipes.
# Note that using this option without enabling named pipes on Windows
# (using the "enable-named-pipe" option) will render mysqld useless!
# 
#skip-networking

By the way, it's strange that you have /var/run empty, a lot of programs (like Apache, Samba, SSH) uses it as a holding directory for their pids or socks.

Cedrik · 08-12-2004, 12:15 PM

I checked the /var/run directory
re-check it as root

Make sure /var/lib/mysql is assigned to mysql user and mysql group, and all the files and subdirectories in it too.

TBomb · 08-12-2004, 12:36 PM

damnit, I can't even start up KDE now. My computer was booting into gnome rather than KDE, so I changed /etc/rc.d/rc.4 and removed the gnome entry, so that it would load kde by default.

Just rebooted and it's still going to the gnome login manager, I tried logging in again to change the file again, but it just freezes when the gnome logo appears.

(nvm - fixed this)

TBomb · 08-12-2004, 12:41 PM

I rechecked /var/run as root. It isn't empty, however there is no mysql.sock there, however there is a mysql directory, which is also empty.

The permissions of /var/lib/mysql is set to:

Owner: Can view & modify content
Group: Can view content
Other: Forbidden

Ownership:
User: mysql
Group: mysql

TBomb · 08-12-2004, 01:08 PM

All fixed

When I changed the permissions of the directory, I assumed it would automaticly change the permissions of all files and folders under it, it didn't. Changed them all manually and it works!

Cedrik · 08-12-2004, 01:12 PM

You can always use the -R switch (with caution) in this case

chown -R mysql:mysql /lib/mysql