MySql server socket connection

ebarreto · 01-03-2005, 08:09 PM

after loading mysql from RedHat distb. Linux 3 (under root), I immediately
executed the application and got this error:

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

The /etc/my.cnf file contains:

[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
.
.

What am I doing wrong?
Thanks
EBarreto

tanveer · 01-04-2005, 02:19 AM

Hello ebarreto,
I think that your mysql server is not running. So first start your mysql server.
Be a SU and give this command :
[root@locahost root]# service mysqld restart
[root@locahost root]# mysql

I hope that will do the magic.

Proud · 01-04-2005, 05:03 AM

Which version of RedHat do you have??!

twantrd · 01-04-2005, 04:18 PM

He probably means RHEL v3.0.

For the mysql.sock problem:

1. Make sure mysqld is running.
2. If it is running and you are getting this, make sure the permissions are correct.

-twantrd

ebarreto · 01-04-2005, 04:20 PM

Hello Proud,

RedHat Linux ES, Kernel 2.4.21-4.EL

It seems that the file :/var/lib/mysql/mysql.sock
was not created during installation.

Thanks for reponding,

ebarreto

Proud · 01-04-2005, 04:27 PM

So did you try checking that mysql is running and is it working ok now?

ebarreto · 01-04-2005, 04:31 PM

Hello tanveer,

It seems that mysqld was not installed. When I try to
start the service I get : mysqld: unrecognized service.
I'm using Linux ES 2.4.21-4.EL

Thanks for reponding

ebarreto

Proud · 01-04-2005, 04:40 PM

Try service mysql status.

tanveer · 01-04-2005, 09:06 PM

Hello ebarreto,
Give this command ntsysv. If you find an entry like mysqld there then its already installed and you just have to enable it.
If its not there then following :
First check if you have installed these packages
1. mysql : contains a lot of client programs
2. mysql-server : contains the server daemon and the mysqld start-up script
3. mysqld-devel : libs and header files
4. php-mysql : if u want ot work with php & mysql

To find out if they are installed just give this comand: rpm -qa | grep mysql
let us all know the outcome.