MySQL Forums
Forum List  »  Install & Repo

Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
Posted by: Tim Vantag
Date: March 07, 2007 02:41AM

Hi.

I noticed that I had old Mysql-version in my computer. (I haven't used it ever)

Now I wanted to update my MySQL and I downloaded these rpm-packets
(I have FC3)
MySQL-client-standard-5.0.27-0.rhel3.i386.rpm
MySQL-server-standard-5.0.27-0.rhel3.i386.rpm

And When I tried to update my MySQL I get error:
libmysqlclient.so.10 is needed by (installed) perl-DBD-MySQL-2.9003-5.i386
libmysqlclient.so.10 is needed by (installed) libdbi-dbd-mysql-0.6.5-9.i386
libmysqlclient.so.10 is needed by (installed) MyODBC-2.50.39-25.FC3.1.i386
libmysqlclient_r.so.10 is needed by (installed) MySQL-python-0.9.2-4.i386

So I downloaded also this rpm-packet
MySQL-shared-compat-5.0.27-0.rhel3.i386.rpm

Now When I installed MySQL-server-standard rpm
I get this kind error:
070307  8:57:40 [Warning] Can't create test file /var/lib/mysql/trinity.lower-test
070307  8:57:40 [Warning] Can't create test file /var/lib/mysql/trinity.lower-test
070307  8:57:40 [Warning] Can't create test file /var/lib/mysql/trinity.lower-test
070307  8:57:40 [Warning] Can't create test file /var/lib/mysql/trinity.lower-test

Starting MySQLCouldn't find MySQL manager or server [FAILED]

Now When I try to start mysql-server I get error:
Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

I tried to change my.cnf

[mysqld]
socket=/tmp/mysql.sock

But it still gives me same error.

And I have tried to start mysql, but I get error:
/etc/init.d/mysql start
Starting MySQL
Couldn't find MySQL manager or server        [FAILED]


EDIT:

My.cnf looks like this:
[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

When I comment out the basedir line then I was able to start mysql, but it fails
Starting MySQL...................................          [FAILED]


What can I do ?



Edited 2 time(s). Last edit at 03/07/2007 04:13AM by Tim Vantag.

Options: ReplyQuote




Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.