Mysql Help

[shaticus]

I am running fedora core 3 and have mysql installed but cannot connect. When the computer boots the mysql service starts but "mysql has ended" displays almost immediately afterward. If I manually start it I get the error could not connect to the database using the port in mysql.socket(111)

What do I have to do to get it to connect?

Thanks in advance,
shaticus

[mairving]

The general problem is that mysql doesn't have write permission in the tmp directory. Chmod the tmp directory to 777 (RWX-owner, RWX-group, RWX-anybody).

[shaticus]

I gave that a try but still get the same error.

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

Thanks,
Shaticus

[mairving]

You might look at this article on the MySQL site for help.

[neouser99]

Originally Posted by shaticus I gave that a try but still get the same error. ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) Thanks, Shaticus

I ran into this problem some time ago. The app you are attempting to use is looking for the socket where it doesn't exist. there are two fixes for this, if you haven't gotten it figured out already. Put a soft link in the /var/lib/mysql folder pointing to the real socket, which is usually existing in the /tmp directory.

ln -s /tmp/mysql.sock /var/lib/mysql/mysql.sock

The other way is to change the mysql-server properties to put the socket in the /var/lib/mysql folder instead of tmp...which i believe the article posted can help you with that.

-neo

[shaticus]

Thanks for the quick responses. I appoligize for not getting back here sooner but I have been bogged down between work and college.
Read through the article but could not get it working. I created the link to the file but it still will not connect.
Only other thing I can think to try would be a reinstall of mysql.

Thanks,
Shaticus