ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysq

[Monyet]

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

I checked mysql folder, and there's nothing there.. I just installed LAMPP, it says that the status of mysql is running, but I'm not sure on how can I access mysql from the command line..? thx all

[RippleFX]

I use the same configuration that you are attempting. Here is how I set it up.

su
mkdir /var/lib/mysql
cd /var/lib/mysql
ln -s /opt/lampp/var/mysql/mysql.sock

This will allow you to use tools such as mysql-query-browser without any hassles.

To access mysql from the command line:

/opt/lampp/bin/mysql

Alternatively you can create a link in /usr/bin like so

su
cd /usr/bin
ln -s /opt/lampp/bin/mysql

This will allow you to simply call

mysql

from now on.

[Ragingmullet]

I am getting the following error when I try and start MySql.

[root@localhost /tmp Sat Dec 01]#mysql
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)

Can anyone help explain what is going on? I'm pretty new to both MySQL and Fedora and this is getting frustrating. Thanks.

[RippleFX]

I would be able to help you if I knew more about your set up. Do you have MySQL installed through the package manager or through XAMPP. If you are using XAMPP from apachefriends.org, ensure that the program is running then you can simply follow these steps:

su
mkdir /var/lib/mysql
cd /var/lib/mysql
ln -s /opt/lampp/var/mysql/mysql.sock

If you are using the MySQL from the package manager ensure that it is started as a service:

su
service mysql start

Then try it again.

Let me know how that turns out for you.

[Ragingmullet]

I would be able to help you if I knew more about your set up. Do you have MySQL installed through the package manager or through XAMPP. If you are using XAMPP from apachefriends.org, ensure that the program is running then you can simply follow these steps:

su
mkdir /var/lib/mysql
cd /var/lib/mysql
ln -s /opt/lampp/var/mysql/mysql.sock

If you are using the MySQL from the package manager ensure that it is started as a service:

su
service mysql start

Then try it again.

Let me know how that turns out for you.

I downloaded the package from the MySQL website. Both the server and the client packages.

When I run "service mysql start" I get a reply that "bash service:command not found".

I believe that my system does attempt to start up the service, but it gives me a failed reply.

[RippleFX]

try this:

su -
service mysql start

the extra dash after su enables all the commands in /sbin, one of which is 'service'.

Also, if you prefer GUI, in GNOME you can do System>Administration>Services scroll down and select mysql and hit the start button. If you want mysql to start automatically every time you start your computer, just make sure the box next to the service name is checked.

Finally, if that doesn't work for you I might suggest uninstalling mysql and reinstalling using yum or pirut and trying it again.

[fclock]

thnks brother succes