Help with MySQL4 on Fedora Core 4

Dsupreeme · 08-18-2006, 12:16 PM

Im fairly new to the linux world but im pretty famailiar with pc's all around. My problems come from an installation of mysql(4) on fedora(4). i guess my main problem would b this message :
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
So i guess i'll jus start with that, hopefully thas the beginning and end of all the issues. Please help if u can or even if u kno of any good tutorials on line please link em. Any user input would be gladly appreciated.

david_ross · 08-18-2006, 02:44 PM

If mysql is running - check with:
ps -ef | grep mysql

Then check if there is a socket open with:
netstat -nlp

You can configure the exact location of your mysql socket file for clients and the server itself in /etc/my.cnf. If you change the location for the mysqld server you will need to restart mysql.

Dsupreeme · 08-18-2006, 02:51 PM

I've attempted the above and i have sockets open, but i cant configure the location of my socket file. It says that the permission is denied. Is there a step that i am missing???

david_ross · 08-18-2006, 02:59 PM

The mysql server will probably need write access to wherever you try to create the socket so the permissions on the directory above will probably need changed.

Dsupreeme · 08-21-2006, 12:45 PM

Now whenever i try an add a new group the shell tells me that groupadd is an invalid command. Im running Fedora Core 4. Is it the wrong command, and if so what is the correct command to add a new group???

david_ross · 08-21-2006, 12:56 PM

Is the command in your $PATH?

Try using the full path:
/usr/sbin/groupadd

kstan · 08-27-2006, 09:50 AM

u did install custom version of mysql before (mysqlclient or server)? I have the similar problem before, it keeping search the socket at /tmp/mysql.sock, but the actual socket at /var/lib/mysql.

After restart mysql, check your server where it put the socket, then try using socket parameter with mysql client.

kstan · 08-27-2006, 09:53 AM

Suddenly i remember another ideal,if previous cannot solve your problem, you can try to backup all dabase (stop mysql server and backup the /var/lib/mysql folder), then remove all the content. Then restart the mysql server, see whether any error or not.
It may occur if you have some problem with the mysql datafile too.