I did a fresh and full install of slack 9.

I've been reading a lot of on mysql and I wanted to start messing with tables. I tried to logon mysql and it gave me an error:

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

I checked the directory and there's nothing in there. I remember I didn't have to do any tweaking for slack8.1 so I'm not sure where to start from here or what to put for mysql.sock.

Does anyone know how to get mysql going? Or at least point me in the right direction.

is your mysql running?
ps -ef | grep mysql

when mysql deamon starts it creates a socket file thats mysql.sock
type top and look for mysql on the list if it not listes start it first then connect to it

Hello,

Thanks for the replies.

I ran:

bash> ps -ef | grep mysql

And it didn't find anything.

I ran top and I did not see anything mysql related.

Apparently, the mysql server isn't running at all. Am I forgetting a setting or conf file, and rc.d setting?

An small update.

I re-installed slackware 9 on one of my machines. The other is an updated 8.1 -> 9 slackbox.

They both gave the same error when trying to log into mysql.

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

And both machines do not have the mysql.sock file in the /var/run/mysql/ Plus, they don't have an instance of mysql running.

Not to be a smarty pants (as I know nothing of mysql), but google pulled up lots on your error message:

This one seemed good.

I checked that out. I don't have a /usr/local/mysql/ but I did find it in /usr/bin and ran safe_mysqld &.

This created an error log on /var/lib/mysql

mysqld started
/usr/libexec/mysqld: Table 'mysql.host' doesn't exist
mysqld ended

My concern is that this is a fresh install of slackware 9 and I can't mysql into the database. I didn't install mysql seperately.

I read a few other threads and some manuals. I got it working. What I did as a root user.

cd /var/lib
chown -R mysql mysql mysql
chgrp -R root mysql mysql
su mysql
mysqladmin -u root status
cd /var
/var/lib/mysql/mysql_install_db &

I guess the permissions weren't set properly, b/c the initial db files weren't created. I'm still a newb to mysql. Thanks to those who helped out.