Dear list,
It appears as if mysql 5.0.18-r30
sets up:
datadir = /var/lib/mysql-500
while my.cnf was from earlier version (I thought I deleted it with
etc-update) indicating:
datadir =/var/lib/mysql
After correction in my.cnf to:
datadir =/var/lib/mysql-500
everything works OK!
Fredrik
----- Original Message -----
From: "John Jolet" <[EMAIL PROTECTED]>
To: <gentoo-user@lists.gentoo.org>
Sent: Sunday, February 05, 2006 3:13 AM
Subject: Re: [gentoo-user] ... Can't connect to local MySQL server ...
On Feb 4, 2006, at 7:37 PM, Fredrik Lundgren wrote:
Thanks for the suggestions!
The problem is that
# /etc/init.d/mysql start
* ...
* Starting mysql (/etc/mysql/my.cnf)
* MySQL NOT started (0) [!!]
In my.cnf
....
....
[client]
# password = your_password
port = 3306
socket = /var/run/mysqld/mysqld.sock
...
...
[mysqld]
...
...
user = mysql
port = 3306
socket = /var/run/mysqld/mysqld.sock
....
...
So it appears that /var/run/mysqld/mysqld.sock somehow is corrupted
How should that be fixed?
not necessarily. make sure mysql is not running. check for the
existence of /var/run/mysqld/mysqld.sock...if it exists, delete it.
it shouldn't exist with mysql not running.
Fredrik
----- Original Message ----- From: "John Jolet" <[EMAIL PROTECTED]>
To: <gentoo-user@lists.gentoo.org>
Sent: Sunday, February 05, 2006 1:40 AM
Subject: Re: [gentoo-user] ... Can't connect to local MySQL server
...
On Feb 4, 2006, at 6:22 PM, A. Khattri wrote:
On Sun, 5 Feb 2006, Fredrik Lundgren wrote:
When I try to visit with
$ mysql -u root -p
password. *******
I get
ERROR 2002 (HY000): Can't connect to local MySQL server through
socket
'var/run/mysqld.sock' (2)
Evidently my configuration is wrong
Has anyone a tip or two ?
Maybe start mysqld?
/etc/init.d/mysql start
and make sure it's still running. and make sure there's an entry
for
the mysql client in the my.cnf pointing to the proper socket.
and how do I get mysql to start at boot?
Maybe use rc-update?
rc-update add mysql default
(Yes, its in the handbook)
--
--
gentoo-user@gentoo.org mailing list
--
gentoo-user@gentoo.org mailing list
--
gentoo-user@gentoo.org mailing list
--
gentoo-user@gentoo.org mailing list
--
gentoo-user@gentoo.org mailing list
