hello everyone,

i am using slackware 12.1. i intend to use mysql on slackware but i get this error message

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

i tried to see if the mysql deamon is running through the command chkconfig but looks like slackware does not identify this command. what is the equivalent command in slackware or how do i go about this problem?

thanks in advance

Check if mysql is running by typing:
Did you run the mysql_secure_installation script and make rc.mysqld executable?

This will give you the process ID of the MySql daemon if it's running.

MySql won't work in Slackware without setting it up - have a look at the file /etc/rc.d/rc.mysqld for instructions - it's well commented and will show you how to set up starting databases and things.

edit: sorry neils - you beat me to it !!

First, you have to set execute permissions to /etc/rc.d/rc.mysqld

Second, you have to run mysql_install_db --user=mysql

Read this thread: http://www.linuxquestions.org/questi...roblem-417127/

As suggested i went thru the file /etc/rc.d/rc.mysqld and accordingly did these

1. gave execute permissions to /etc/rc.d/rc.mysqld
2. executed mysql_install_db --root=mysql

After this when i try using mysql as mysql -u root the same error appears

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

OK - I've just ran through the instructions on a clean VM of Slack 12.1 and it worked fine.

So -- you did restart after making your changes ? If so what messages about mysql did you see late on in the boot process ? Can you rerun
pidof mysqld as root to check it's running ?

yes i restarted after making the changes. mysqld did run at the boot time with following messages

starting mysqld daemon with databases from /var/lib/mysql
STOPPING server from pid file /var/run/mysql/mysql.pid
081018 21:39:42 mysql ended.

and ya pidof mysqld didn't return anything

Do you see any errors in /var/lib/mysql/*.err ?

(exchange * with your server name)

It should be just the command mysql on the server to test it. Remote doesn't work by default. Read /etc/rc.d/rc.mysqld

the error message in /var/lib/mysql/*.err was

081018 22:09:01 mysqld started
081018 22:09:03 InnoDB: Operating system error number 13 in a file operation.
InnoDB: The error means mysqld does not have the access rights to
InnoDB: the directory.
InnoDB: File name ./ibdata1
InnoDB: File operation call: 'create'.
InnoDB: Cannot continue operation.
081018 22:09:03 mysqld ended

Try this:

/etc/rc.d/rc.mysqld stop ; rm -fR /var/lib/mysql/* ; mysql_install_db --user=mysql ; /etc/rc.d/rc.mysqld start

and then

cat /var/lib/mysql/*err

still the same error ?

try chown mysql:mysql -R /var/lib/mysql

I am having the exact same problem with mysql, how do I get around this problem?

after installation of MySQL, you should run
or another solution is:

Hey I tried that but still no use


EDIT: Hey I had forgotten to restart mysqld, its working fine once mysqld was restarted..

I have a new question now, its not regarding mysql though, how do I set classpath for tomcat? I have downloaded apache-tomcat-6.0.18.tar.gz(which I used on my previous two distros also, mandriva 2009 and opensuse 11.0), now I have extracted to /home/user directory, I ran ./startup.sh and the server is indeed up and running. but I cant seem to find .bash_profile file to set classpath(like I did in my previous two installs).. there's only a .bash_history file. Also, there is no servlet api .jar file in /usr/share/java :-S

you can make it yourself using