Hi all

Having trouble with my SuSE box. Basically, MySQL doesn't want to play ball unless I manually start it.

Currently when I try to connect to mysql (using the CLI) after boot (using root) I get the following message:I can start mysql using the following command: mysqld_safe --user=mysql&

This is a development server, so needs to boot MySQL during startup.

Can anybody help me?

Find a file named mysql.server and create a symlink to this file in rc5.d or rc3.d (rc5 for x-windows and rc3 for command line login)
Make sure that mysql.server is executable (chmod +x mysql.server)

Worked a charm! Thanks!

hi all,

im a very newbie that got really badly stuck with this mysql.sock.....
so, i'm workin on a redhat 9....and i'm trying to set up ACID on snort.....usin mysql

all installation went fine, but when i try:
$mysql

i get an error:
ERROR 2002: Can't connect to local MYSQL server through socket '/tmp/mysql.sock'

I can't find this mysql.sock (neither find / nor locate worked)

looked for a while on the web, & tried all the different options proposed:

edit etc/my.cnf
change /tmp/ to /var/lib/mysql/



what am i supposed to so it work....

& when using the apache server to connect acid....guess what, i get the same error

plz, help

First of all don't change any config file yet because the error means that perhaps the daemon is not running. Check to see if mysqld is running:and if it's running then try to figure out what's wrong

i can't even lunch the mysql deamon....& 'im gettin the same error....I even tried reconfiguring with specifying the path of mysql.sock...... & still doesn't work.....

& it's not the hard drive problem.....

Did you follow the instructions for the installation of mysql? After the installation you must run the ./mysql_install_db script to create the initial users db and after that you must start the daemon with something like: ./safe_mysqld &
So undo the changes you made in my.cnf run those scripts (if not done yet) and if you get this error again take a look at the error logfile created in the directory you specified during installation for keeping the data. The file is named something like: hostname.err
Good luck

Bathory you hit it! I was having the same problems with Suse 9.1 and mysql.

I kept getting:
ERROR 2002: Can't connect to local MySQL server through '/var/lib/mysql/mysql.sock' (2)
after installing mysql through YAST.

The exact line in needed was:

ln -s /usr/share/mysql/mysql.server /etc/init.d/rc5.d/S99mysql

I was trying to figure this out for days!!! Thanks

Hey I also find the same error over SUSE Linux in . If anybody have idea about this error and removal of it please help.

Utkarsh