Web Hosting Talk : Web Hosting Main Forums : Hosting Security and Technology : MySQL said: Documentation

[Criminal#58369]

Just installed fedora core 3, started apache, and mysql, uploaded phpmyadmin, and i get this,

MySQL said: Documentation
#2002 - Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (13)

How do i fix this problem?...Rebooting?... How to fix it?

[Unknown_User]

Hi, I read that you need to do:

chown -R mysql /var/lib/mysql/*
chgrp daemon /var/lib/mysql/*

Give it a try see if it works.

dislexiK

[Unknown_User]

Also, check to see if you have: mysql.sock in /var/lib/mysql or somewhere else, IIRC if it is in a different place you need to create a symlink to it or change the properties in MySQL config or something alike - don't take my word for it, I have not even installed MySQL, just going off what I have read.

DislexiK

[Criminal#58369]

Edited:

I just logged in as root, checked, there is a mysql.sock in /var/lib/mysql/mysql.sock

What could be the problem, mysql starts ok...? Maybe a bug in fedora core 3? If so i guess id have to report that to them?... so they can make it better

[Criminal#58369]

In my.cnf in /etc/ i have the following in the file:

[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock

[mysql.server]
user=mysql
basedir=/var/lib

[safe_mysqld]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid


That looks right to me...
Is there anything i should add, or files to check?

[Unknown_User]

Have you done:

chown -R mysql /var/lib/mysql/*
chgrp daemon /var/lib/mysql/*

DislexiK

[Criminal#58369]

Yes the funny thing is though, the mysql.sock does not have anything in it...?.. I dont get it..

[Criminal#58369]

Heres what i get when i check it:


[root@localhost ~]# rpm -qa | grep mysql
mod_auth_mysql-20030510-5
mysql-devel-3.23.58-13
freeradius-mysql-1.0.1-1
libdbi-dbd-mysql-0.6.5-9
gda-mysql-1.0.4-3
mysql-3.23.58-13
mysql-server-3.23.58-13
php-mysql-4.3.9-3
mysql-bench-3.23.58-13
[root@localhost ~]#

Maybe i should install an up-to-date version of mysql? like version 4?

[Unknown_User]

ITs always a good idea to update your services, and it is even better to compile them

DislexiK

[LP-Trel]

You can fix it by not running a developer preview OS on a server.

See http://www.centos.org/ for a better server operating system.

[Criminal#58369]

But i like fedora lol

[Burhan]

Get a decent server OS. Like FreeBSD or RHE. Gentoo is good too, but its really optimized for the desktop.

Updating MySQL would be a step in the right direction.

[EastHill]

yes fedora is good