MySQL problems

[Boodlooder]

I'm not able to launch mysql, or the mysql administrator gui component.

The error seems to be related to a missing mysql.sock file.

Here is the error (same in command line, and gui)

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

When I run 'locate mysql.sock' as root, I get nothing. I'm not sure what could be wrong, I have a fresh-clean install of php, mysql, php-mysql and PHP is working great, but I'm sitting at the install screen waiting to continue, needing to first make user changes to mysql before I continue. Dropped to the console, and the 'mysql.sock' issue stopped me dead in my tracks.

I understand what it is looking for, but I am at a loss to explain why the file would not be there, or what to do to substitute this file.. (the gui version allows you to specify a socks file).

Any help would be greatly appreciated.

[Boodlooder]

cd /etc/rc.d/init.d
./mysqld start

(might help)

[zence]

I get the same error :

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

but when I try cd /etc/rc.d/init.d/mysql start I get: -bash: cd/etc/rc.d/init.d./mysqld: The file or the catalog doesn't exist. The installation went fine.

[Sarthan]

# rpm -qa | grep mysql

and verify if these packages are listed :

mysql-5.0.18-2.1
mysql-server-5.0.18-2.1

[landoncz]

cd /etc/init.d/rc.d/mysql start

will give an error beacuse that is an attempt to cd to a file, which is not allowed.

You should instead be typing as two separate commands (or place a semicolon between them) as root:

cd /etc/init.d
./mysqld start

or just type this one command:

/etc/init.d/mysqld start

and see what the output says...

[icydog]

Or use

service mysqld start

=)

[Boodlooder]

Actually, the best way to go about this (for my purposes anyhow) is to add..

# Start httpd  for Apache
666:345:respawn:/etc/rc.d/init.d/httpd start

# Start vsftpd  For VSFTP
667:345:respawn:/etc/rc.d/init.d/vsftpd start

# Start mysqld  For MySQL
668:345:respawn:/etc/rc.d/init.d/mysqld start

to your inittab under /etc. (I thought it was in there by default. Unfortunately this is the second box I've set up and it's been so long since I set the other one up I forgot I did this..

You may not want respawn, look at your options to decide which way is best. Respawn causes the service to restart if it farts on you.

[zence]

Thank you all for your answers and thank's Boodlooder ......it solved the problem.

[pinkydaemon]

I have the same problem as zence
(ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
)
but when i enter /etc/rc.d/init.d/mysqld start
i get a
¨Initializing MySQL database: Neither host 'bhai.b-hive' nor 'localhost' could be looked up with
/usr/bin/resolveip
Please configure the 'hostname' command to return a correct hostname.
If you want to solve this at a later stage, restart this script with
the --force option
[FAILED]¨
i tried /etc/rc.d/init.d/mysqld start --force. I get the same error.
bhai is my local hostname and b-hive domain.
I ran hostname command which give me ¨bhai.b-hive¨

[Boodlooder]

check your /etc/hosts file.

Also, try to ping the two domains. Your domain, if properly configured should return your ip address. pinging the localhost should return 127.0.0.1 (loopback).

If neither of these work, again, check your hosts file. (and possibly your dns settings, especially if you are trying to host your own dns server).

[pinkydaemon]

i checked my /etc/hosts file. I contained just 2 commented lines. I actually dont know what it is supposed to contain. can u tell me what i shud enter into it.

pinging localhost didnt return anything. i have started httpd

[Boodlooder]

post your /etc/hosts file -


Something's not right.

[triax]

you should have at least the following in your hosts file
127.0.0.1 your_hostname localhost localhost.localdomain