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.
Notices
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.
Get a virtual cloud desktop with the Linux distro that you want in less than five minutes with Shells! With over 10 pre-installed distros to choose from, the worry-free installation life is here! Whether you are a digital nomad or just looking for flexibility, Shells can put your Linux machine on the device that you want to use.
Exclusive for LQ members, get up to 45% off per month. Click here for more info.
ok, i just switched my dual AMD 1.6ghz server over to Redhat 8.0 from XP. I got apache and php working, but i cant seem to get MySQL working. I get this error:
ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
i chekced and that file isint there, any ideas where it is? any help would be great.
Originally posted by pagal did you install the mysql during install?
if you did, have you made sure that the service is running?
yea i did a full install, all 4gb of it. i can run commands on mysql, like login and crap, but after it is done asking for the password and tries to connect i get that error.
I have got the same problem. As soon as Redhat 8 came out I downloaded and installed it on one of my servers. I couldn't connect from any other host then localhost/localmachine to the mysql server .. using mysql client from shell is working (only when using root/trusted connection).
I've posted the problem on the forum of the biggest Dutch tech site with more then 75.000 registered members. It seemed that a lot of other people had the same problem as me and you.
I've not been workin on the problem a lot of time I have just down grade the server ... but trying again right now.
Isn't this a known bug?
One of the solution i know could be done is not installing the httpd server and mysql ... and then do a separate installation.
But this will make a lot of problem.. I did a search on the redhat they specificly telling redhat user that the httpd server is patch with postgresql . but .. i though mysql is better then postgresql.
I've added a 'host permission' to mysql or let's call it a trusted host for the client machine where I was/am connecting from.
And you know what happend .. acccess was granted.
So I think that there is actually a bug in the MySQL that was coming with RedHat 8 distro
Ok again ..
I've inserted a new record/row into the table 'host' in the 'mysql' database. This table defines the permissions you have when you connecting from specified host.
LinuxQuestions.org is looking for people interested in writing
Editorials, Articles, Reviews, and more. If you'd like to contribute
content, let us know.