Linux - SoftwareThis forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.
Welcome to LinuxQuestions.org, a friendly and active Linux Community.
You are currently viewing LQ as a guest. By joining our community you will have the ability to post topics, receive our newsletter, use the advanced search, subscribe to threads and access many other special features. Registration is quick, simple and absolutely free. Join our community today!
Note that registered members see fewer ads, and ContentLink is completely disabled once you log in.
If you have any problems with the registration process or your account login, please contact us. If you need to reset your password, click here.
Having a problem logging in? Please visit this page to clear all LQ-related cookies.
Introduction to Linux - A Hands on Guide
This guide was created as an overview of the Linux Operating System, geared toward new users as an exploration tour and getting started guide, with exercises at the end of each chapter.
For more advanced trainees it can be a desktop reference, and a collection of the base knowledge needed to proceed with system and network administration. This book contains many real life examples derived from the author's experience as a Linux system and network administrator, trainer and consultant. They hope these examples will help you to get a better understanding of the Linux system and that you feel encouraged to try out things on your own.
Click Here to receive this Complete Guide absolutely free.
ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
that's the error I'm getting after installing the rpm for 4.something.
Everything worked fine with the one that installed with RH9. I searched this site and google and still haven't figured out this problem. From what I can tell, I don't have a mysql.sock file where it's supposed to be and I don't know how to get it. mysql does start on startup, is currently running, but I can't connect to it so I can't do anything with it. I read a lot of posts on here and the web and the only people that seem to have had success had to reinstall their OS and install mysql from source. I don't want to do anything that drastic. Any help?
I can restart mysql in the services window and it says successful. I really don't know a whole lot about mysql but I'm trying to learn now. I don't know where the log files are either. A lot of people seem to be having this problem so I think that there would have to be a bug or something in mysql.
I tried running mysqld_multi with the following option but I couldn't get it to work right either, just kept showing me the help:
--tcp-ip Connect to the MySQL server(s) via the TCP/IP port instead
of the UNIX socket. This affects stopping and reporting.
If a socket file is missing, the server may still be
running, but can be accessed only via the TCP/IP port.
By default connecting is done via the UNIX socket.
I don't have the socket file, so I just tried creating an empty file and putting it where the my.cnf file said it was looking for it but that didn't work. Is it possible to use a copy of somebody else's file? Or would that even work at all?
The mysql.sock file is only present when mysql is running. Are you sure it is started? Can you connect to it using the ip address (mysql -uUserName -pPassword -hIPAddress)?
If the answer to both of those is "yes", then either use 'find' or 'locate' to see where the mysql.sock is.
I checked out my RH7.3 machine. It is putting the mysql.sock in /var/lib/mysql, but I'm running 3.23, probably not the same version your using. I had to create link from /tmp/mysql.sock to /var/lib/mysql/mysql.sock. That fixed the problem, of connecting locally, but I was always able to connect if I treated it as a remote connection.