I'm trying to install mysql on suse 9.3 using apt. It seems to install ok and chkconfig --add mysql works. But when I try mysql start (in etc/init.d) I get: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) var/lib/mysql is empty. What am I doing wrong ? Thanks, Nathan ___________________________________________________________ How much free photo storage do you get? Store your holiday snaps for FREE with Yahoo! Photos http://uk.photos.yahoo.com
Nathan, On Saturday 05 November 2005 06:17, perlcgi2000 wrote:
I'm trying to install mysql on suse 9.3 using apt.
It seems to install ok and chkconfig --add mysql works.
But when I try mysql start (in etc/init.d) I get:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
var/lib/mysql is empty. What am I doing wrong ?
Most likely you were not root when you tried to start MySQL. After it runs the first time, all the necessary files in /var/lib/mysql will be created. Assuming you want to have MySQL running whenever your system is up, go to YaST -> System -> System Services (Runlevel) and set the mysql service to be running in runlevels 3 and 5.
Thanks, Nathan
Randall Schulz
On Sat, 2005-11-05 at 07:35 -0800, Randall R Schulz wrote:
Nathan,
On Saturday 05 November 2005 06:17, perlcgi2000 wrote:
I'm trying to install mysql on suse 9.3 using apt.
It seems to install ok and chkconfig --add mysql works.
But when I try mysql start (in etc/init.d) I get:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
var/lib/mysql is empty. What am I doing wrong ?
Most likely you were not root when you tried to start MySQL. After it runs the first time, all the necessary files in /var/lib/mysql will be created.
Assuming you want to have MySQL running whenever your system is up, go to YaST -> System -> System Services (Runlevel) and set the mysql service to be running in runlevels 3 and 5.
Isn't that what chkconfig --add mysql does (as stated above)?
Thanks, Nathan
Randall Schulz
-- Ken Schneider UNIX since 1989, linux since 1994, SuSE since 1998
Hi,
I'm trying to install mysql on suse 9.3 using apt.
It seems to install ok and chkconfig --add mysql works.
But when I try mysql start (in etc/init.d) I get:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
var/lib/mysql is empty. What am I doing wrong ?
This file will be empty unless mysqld is started first. (You were trying to start the mysql client, I think.) You should see mysql start up on boot, but anyway: rcmysql start /etc/init.d/mysql/start If you simply type mysql start it will try to start /usr/bin/mysql rather than the script file (you need ./ if the current directory is not in $PATH). -- /Paul "It's not about the ending, it's about the journey." - Lex Luthor
participants (4)
-
Ken Schneider
-
Paul
-
perlcgi2000
-
Randall R Schulz