I've installed MySQL 4.1 with Fedora Core4.
Apache2 & PHP5 are installed manual.

When i type # mysql i console, i get this error:

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

The dir '/var/lib/mysql/' is empty..

What can i do to fix it?

Have you tried uninstalling all the mysql packages and then reinstallng mysql and mysql-server.

If i try to uninstall mysql it says:


[root@ ~]# rpm -e mysql
error: Failed dependencies:
libmysqlclient.so.14()(64bit) is needed by (installed) mod_auth_mysql-2.6.1-4.x86_64
libmysqlclient.so.14()(64bit) is needed by (installed) php-mysql-5.0.4-10.x86_64
libmysqlclient.so.14()(64bit) is needed by (installed) perl-DBD-MySQL-2.9007-1.x86_64
libmysqlclient.so.14()(64bit) is needed by (installed) mysql-server-4.1.11-2.x86_64
libmysqlclient_r.so.14()(64bit) is needed by (installed) mysql-server-4.1.11-2.x86_64
libmysqlclient_r.so.14()(64bit) is needed by (installed) MySQL-python-1.2.0-1.x86_64
mysql = 4.1.11-2 is needed by (installed) mysql-devel-4.1.11-2.x86_64
mysql = 4.1.11-2 is needed by (installed) mysql-server-4.1.11-2.x86_64
mysql is needed by (installed) MySQL-python-1.2.0-1.x86_64

If i try to upgrade it says:

[root@ home]# rpm -U MySQL-server-4.1.12-1.glibc23.x86_64.rpm
error: Failed dependencies:
libmysqlclient.so.14()(64bit) is needed by (installed) mod_auth_mysql-2.6.1-4.x86_64
libmysqlclient.so.14()(64bit) is needed by (installed) php-mysql-5.0.4-10.x86_64
libmysqlclient.so.14()(64bit) is needed by (installed) perl-DBD-MySQL-2.9007-1.x86_64
libmysqlclient_r.so.14()(64bit) is needed by (installed) MySQL-python-1.2.0-1.x86_64


I'v chosen all the mysql-packages in the install.. Grr..
I guess i have to find 'libmysqlclient.so.14' and install it.

Like I said in my previous post, uninstall all packages related to mysql and then reinstall using yum e.g. "yum install msql mysql-server".

I have now installed MySQL via. yum.
Hvem i type "mysql" it says:

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

I haven't got a "mysql.sock" on my system... The same problem every time i tro to install MySQL.

If i create a blank file called "mysql.sock" i says same as above, just error code (111)

hi,

I am not sure but:

# service mysqld start


because:
# service mysqld start
# ls /var/lib/mysql
ibdata1 ib_logfile0 ib_logfile mysql mysql.sock test

and after stop

# ls /var/lib/mysql
ibdata1 ib_logfile0 ib_logfile mysql test

best regards
lu

Yup.. it worked...
Thanks :-)