Clean Redhat 8.0 install, starting MySQL
 

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.

Thanks,
Kevin

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.

starting to think running mysql for windows w/ wine would be easier...

can't get that to work either, lol.

try typing mysqld -uroot then type mysql .. that's what works for me.

i have the same problem..
somehow when i do phpInfo()
i found out that the php does not include mysql..

did you check if your mysql.sock is in /tmp ... sometimes it's there...

try "locate mysql.sock"

if it's there, there is an option that you can set while you do mysqld xxxx /var/mysql.sock

try the help or the man page to know how to specified the socket file...

it should work, or at least, give you a good hing

Have you fix it yet?
I got attack by cinik worm now..
i am thinking to upgrade the server to redhat 8 but i need the http server with mysql to work!

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.


So how?

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

can u explain more clear on that?
i dont get what you mean

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.

so that will be
INSERT INTO host SET('%' ,'%','Y','Y','Y','N','N','N','N','N','N')