Can't start MySQL saith the newbie.
HI all. I just installed SuSE 9.0 via ftp. I have installed apache and php and now I would like to get mysql running. I installed mysql and mysql client via YAST but I can't seem to start it. I type mysql start at the command line and get the following error. Any ideas? Regards from Denmark. Dan *> mysql start* ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
On Monday 09 February 2004 14.35, Dan Eskildsen wrote:
HI all. I just installed SuSE 9.0 via ftp. I have installed apache and php and now I would like to get mysql running. I installed mysql and mysql client via YAST but I can't seem to start it. I type mysql start at the command line and get the following error. Any ideas? Regards from Denmark. Dan
*> mysql start* ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
try "rcmysql start" Cheers from Sweden
Anders Johansson wrote:
On Monday 09 February 2004 14.35, Dan Eskildsen wrote:
HI all. I just installed SuSE 9.0 via ftp. I have installed apache and php and now I would like to get mysql running. I installed mysql and mysql client via YAST but I can't seem to start it. I type mysql start at the command line and get the following error. Any ideas? Regards from Denmark. Dan
*> mysql start* ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
try "rcmysql start"
*Got another error:
rcmysql start*
Starting service MySQL ..failed Other ideas?
Cheers from Sweden
Hi again.
I checked /var/log/messages and there are no messages to see about mysql.
----- Original Message -----
From: "Dan Eskildsen"
Anders Johansson wrote:
On Monday 09 February 2004 14.35, Dan Eskildsen wrote:
HI all. I just installed SuSE 9.0 via ftp. I have installed apache and php and now I would like to get mysql running. I installed mysql and mysql client via YAST but I can't seem to start it. I type mysql start at the command line and get the following error. Any ideas? Regards from Denmark. Dan
*> mysql start* ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
try "rcmysql start"
*Got another error:
rcmysql start*
Starting service MySQL ..failed
Other ideas?
Cheers from Sweden
-- Check the headers for your unsubscription address For additional commands send e-mail to suse-linux-e-help@suse.com Also check the archives at http://lists.suse.com Please read the FAQs: suse-linux-e-faq@suse.com
On Monday 09 February 2004 15.08, Dan Eskildsen wrote:
Hi again. I checked /var/log/messages and there are no messages to see about mysql.
Make sure it isn't in fact running anyway. Sometimes the rc scripts report failure even though it works. Just in case...
.
On Monday 09 February 2004 15.08, Dan Eskildsen wrote:
Hi again. I checked /var/log/messages and there are no messages to see about mysql.
Make sure it isn't in fact running anyway. Sometimes the rc scripts report failure even though it works. Just in case...
I did a ps -A and I can't see mysql running.
-- Check the headers for your unsubscription address For additional commands send e-mail to suse-linux-e-help@suse.com Also check the archives at http://lists.suse.com Please read the FAQs: suse-linux-e-faq@suse.com
Start mysqld before trying to access your DB. Alex Dan Eskildsen wrote:
.
On Monday 09 February 2004 15.08, Dan Eskildsen wrote:
Hi again. I checked /var/log/messages and there are no messages to see about mysql.
Make sure it isn't in fact running anyway. Sometimes the rc scripts report failure even though it works. Just in case...
I did a ps -A and I can't see mysql running.
-- Check the headers for your unsubscription address For additional commands send e-mail to suse-linux-e-help@suse.com Also check the archives at http://lists.suse.com Please read the FAQs: suse-linux-e-faq@suse.com
On Monday 09 February 2004 13:53, Dan Eskildsen wrote:
Anders Johansson wrote:
On Monday 09 February 2004 14.35, Dan Eskildsen wrote:
HI all. I just installed SuSE 9.0 via ftp. I have installed apache and php and now I would like to get mysql running. I installed mysql and mysql client via YAST but I can't seem to start it. I type mysql start at the command line and get the following error. Any ideas? Regards from Denmark. Dan
*> mysql start* ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
try "rcmysql start"
*Got another error:
rcmysql start*
Starting service MySQL ..failed
Other ideas?
Cheers from Sweden
Is mysql installed? try rpm -qa | grep mysql mine shows mysql-shared-4.0.15-9 mysql-4.0.15-9 mysql-client-4.0.15-9 mysqlcc-0.9.2-66 qt3-mysql-3.2.1-37 if it shows you that mysql is installed then as root do /etc/init.d/mysql start I think there is a problem in SuSE 9.0 as mysql does not seem to start automatically on a reboot. Phil
Is mysql installed? try rpm -qa | grep mysql mine shows mysql-shared-4.0.15-9 mysql-4.0.15-9 mysql-client-4.0.15-9 mysqlcc-0.9.2-66 qt3-mysql-3.2.1-37
if it shows you that mysql is installed then as root do /etc/init.d/mysql start
I think there is a problem in SuSE 9.0 as mysql does not seem to start automatically on a reboot. Phil
Phil Thanx You solved a problem under 8.2 that I've been having for a while humvee --
Mon, 09 Feb 2004, by danes@image.dk:
Anders Johansson wrote:
On Monday 09 February 2004 14.35, Dan Eskildsen wrote:
HI all. I just installed SuSE 9.0 via ftp. I have installed apache and php and now I would like to get mysql running. I installed mysql and mysql client via YAST but I can't seem to start it. I type mysql start at the command line and get the following error. Any ideas? Regards from Denmark. Dan
*> mysql start* ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
try "rcmysql start"
*Got another error:
rcmysql start*
Starting service MySQL ..failed
Not sure if this is done in 9.0, but you can copy a my.cnf file from /usr/share/doc/packages/mysql/cnf/ to /etc/my.cnf In the file you explicitly set the socket path and ports [client] port = 3306 socket = /var/lib/mysql/mysql.sock [mysqld] port = 3306 socket = /var/lib/mysql/mysql.sock I think you also need to run the /usr/bin/mysql_install_db util before you can use the server. Theo -- Theo v. Werkhoven Registered Linux user# 99872 http://counter.li.org ICBM 52 13 27N , 4 29 45E. SUSE 8.2 Kernel k_athlon-2.4.20 See headers for PGP/GPG info.
participants (6)
-
Alexandre St-Pierre -
Anders Johansson -
Dan Eskildsen -
humvee -
Phil Burness -
Theo v. Werkhoven