Hi:

I downloaded FC3 and MYSQL. When I tried to start MYSQL, I get the popular error message:

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

The problem is mysql.sock doesn't exist anywhere. I checked
/tmp/mysql.sock
/var/lib/mysql/mysql.sock
find / -name mysql.sock

I couldn't find mysql.sock on my system . I appreciate any suggestions

What do your logs tell you? mysql.sock is started and created when mysql is started. Do both your /var/lib and /var/run have the correct permissions and ownerships, which should be the mysql user? My guess would be that you need to do:

chown -R mysql.mysql /var/lib/mysql

this is one of the great problems in mysql

if u are working in redhat then u have to start the mysql using " service mysqld start" from the root and then
type mysql.

Ok so did that fix your problem? I'm confused by your response. I'm well aware of how Redhat works and operates to start services.

It's not ownership issue, I logged in as root.

This is what I get when I try service mysqld service.
mysqld: unrecognized service

Once I had simillar issue in Mandrake and I started mysql using
service mysql start, but it didn't work here.
The issue here is that mysql.sock doesn't exist. How would mysql know how to connect? I am missing something.

mysql.sock is a file thats created by MYSQL when MYSQL starts up.

I believe that if mysql is running and the file hasnt been created, then its because MYSQL doesnt have the permissions on the folder to create the file.

I use Fedora 3, and I had to do the following :

# chown -R mysql /var/lib/mysql
# chgrp -R mysql /var/lib/mysql

This changes the ownership and the group of the /var/lib/mysql folder so that the account that mysql uses has the correct permissions on the folder to create the file. Then things like phpmyadmin and php use the sock file to establish a connection to mysql.

Did you install mysql yourself?

Did you enter this command...
# /usr/bin/mysql_install_db

To start mysql you could also try the following command

# /usr/bin/mysqld_safe --user=mysql &

I did a tutorial for Fedora 3 which you may like to take a look at, it might help you a little seeing as Fedora is Redhat(in a way).

http://www.linuxquestions.org/questi...hreadid=343061

Thanks a lot fuelinjection.
you solved my problem and I will go through your tutorial.

Funny how fuelinjection mentions to do this:

# chown -R mysql /var/lib/mysql
# chgrp -R mysql /var/lib/mysql

When I mention the same steps by telling you to do this which changes both user and group, notice the mysql.mysql:

chown -R mysql.mysql /var/lib/mysql

Though forgot to ask if you had actually installed a DB but it seemed you ignored my first reply anyhow..

Hi:

fuelinjection advised about the command /usr/bin/mysql_install_db. In it, I found the command /usr/bin/safe_mysqld & which started mysql daemon. It wasn't the ownership change that made it.
Of course I appreciate all responses and efforts from all users regardless of the results.

Your actual /sbin/service mysqld start should actually use the /usr/bin/safe_mysqld command but I simply overlooked and assumed you had already installed the default database before trying to start a database application..