[rock-user] Re : Re : Re : Mysql installation cannot connect, cannot start
philippe florent <[email protected]> Tue, 28 Nov 2006 08:32:52 +0000 (GMT)
| Newsgroups | gmane.linux.distributions.rock.user |
|---|---|
| Message-ID | <[email protected]> |
--===============1074768817== Content-Type: multipart/alternative; boundary="0-1675478497-1164702772=:44433" --0-1675478497-1164702772=:44433 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable thx for those wonderfull infos thx=0A=0A=0A----- Message d'origine ----=0AD= e : Stefan Fiedler <[email protected]>=0A=C0 : ROCK Users Mail= ing List <[email protected]>=0AEnvoy=E9 le : Jeudi, 23 Novembre 2006,= 14h41mn 35s=0AObjet : Re: [rock-user] Re : Re : Mysql installation cannot = connect, cannot start=0A=0A=0AAm Donnerstag, 23. November 2006 11:49 schrie= b philippe florent:=0A> I don't understand,=0A> 1st time i launch mysqld_sa= fe , it gives error, cannot find log file .err=0A> then second time, it can= not find the mysqld=0A> now it can find it but i got an error saying I cann= ot start the mysql=0A> daemon as root, i cannot find the security pages in = man...=0A=0AHello Philippe!=0A=0AHere's some things that might be helpful t= o you:=0A=0AThere's the problem that mysqld_safe always seems to exit with = return code 0, =0Aso that running '/etc/rc.d/init.d/mysql start' always see= ms to succeed, even =0Aif an error occurred. I don't know yet how to fix th= is.=0A=0ARunning mysqld_safe requires the /var/opt/mysql directory to exist= . I used the =0Afollowing permissions:=0A drwxr-xr-x 2 root root 4096 20= 06-11-23 14:04 /var/opt/mysql/=0AMaybe this directory is created by another= mysql program, or it should be part =0Aof the mysql package, I'm not sure.= =0A=0ATo run mysqld_safe as root, use the --user=3Droot option, e.g. =0Ain= /etc/rc.d/init.d/mysql change the line:=0A (/opt/mysql/bin/mysqld_sa= fe >/dev/null 2>&1 &) || error=3D$?=0Ato=0A (/opt/mysql/bin/mysqld_sa= fe --user=3Droot >/dev/null 2>&1 &) || error=3D$?=0AAgain I'm not sure whet= her this is the best option, maybe add and use =0Aa 'mysql' user?=0A=0ARunn= ing mysqld_safe with this option, I get the error =0Ain /var/opt/mysql/<hos= tname>.err:=0A 061123 14:21:19 [ERROR] Fatal error: Can't open and lock = privilege tables: =0ATable 'mysql.host' doesn't exist=0A 061123 14:21:19= mysqld ended=0AI was able to 'fix' this by running (as root) 'mysql_insta= ll_db'. =0AThen '/etc/rc.d/init.d/mysql start' should work as expected.=0A= =0AWith best regards,=0A Stefan Fiedler=0A=0A=0A________________________= _______________________=0Arock-user mailing [email protected]= =0Ahttp://www.rocklinux.net/mailman/listinfo/rock-user=0A=0A=0Ath=0A=0A=0A= =09=0A=0A=09=0A=09=09=0A___________________________________________________= ________________________ =0AYahoo! Mail r=E9invente le mail ! D=E9couvrez l= e nouveau Yahoo! Mail et son interface r=E9volutionnaire.=0Ahttp://fr.mail.= yahoo.com --0-1675478497-1164702772=:44433 Content-Type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable <html><head><style type=3D"text/css"><!-- DIV {margin:0px;} --></style></he= ad><body><div style=3D"font-family:times new roman, new york, times, serif;= font-size:12pt"><DIV style=3D"FONT-SIZE: 12pt; FONT-FAMILY: times new roman= , new york, times, serif">thx for those wonderfull infos thx<BR><BR>=0A<DIV= style=3D"FONT-SIZE: 12pt; FONT-FAMILY: times new roman, new york, times, s= erif">----- Message d'origine ----<BR>De : Stefan Fiedler <stefan.fiedle= [email protected]><BR>=C0 : ROCK Users Mailing List <rock-user@rockli= nux.org><BR>Envoy=E9 le : Jeudi, 23 Novembre 2006, 14h41mn 35s<BR>Objet&= nbsp;: Re: [rock-user] Re : Re : Mysql installation cannot connect, cannot = start<BR><BR>=0A<DIV>Am Donnerstag, 23. November 2006 11:49 schrieb philipp= e florent:<BR>> I don't understand,<BR>> 1st time i launch mysqld_saf= e , it gives error, cannot find log file .err<BR>> then second time, it = cannot find the mysqld<BR>> now it can find it but i got an error saying= I cannot start the mysql<BR>> daemon as root, i cannot find the securit= y pages in man...<BR><BR>Hello Philippe!<BR><BR>Here's some things that mig= ht be helpful to you:<BR><BR>There's the problem that mysqld_safe always se= ems to exit with return code 0, <BR>so that running '/etc/rc.d/init.d/mysql= start' always seems to succeed, even <BR>if an error occurred. I don't kno= w yet how to fix this.<BR><BR>Running mysqld_safe requires the /var/opt/mys= ql directory to exist. I used the <BR>following permissions:<BR>  = ; drwxr-xr-x 2 root root 4096 2006-11-23 14:04 /var/opt/mysql/<B= R>Maybe this directory is created by another mysql program, or it should be= part <BR>of the mysql package, I'm not sure. <BR><BR>To run mysqld_safe as root, use the --user= =3Droot option, e.g. <BR>in /etc/rc.d/init.d/mysql change the line:<BR>&nbs= p; (/opt/mysql/bin/mysqld_safe >/dev/null = 2>&1 &) || error=3D$?<BR>to<BR> &nb= sp; (/opt/mysql/bin/mysqld_safe --user=3Droot >/dev/null 2>&1 &am= p;) || error=3D$?<BR>Again I'm not sure whether this is the best option, ma= ybe add and use <BR>a 'mysql' user?<BR><BR>Running mysqld_safe with this op= tion, I get the error <BR>in /var/opt/mysql/<hostname>.err:<BR> = 061123 14:21:19 [ERROR] Fatal error: Can't open and lock = privilege tables: <BR>Table 'mysql.host' doesn't exist<BR>  = ; 061123 14:21:19 mysqld ended<BR>I was able to 'fix' this = by running (as root) 'mysql_install_db'. <BR>Then '/etc/rc.d/init.d/mysql s= tart' should work as expected.<BR><BR>With best regards,<BR> &nb= sp; Stefan Fiedler<BR><BR><BR>_______________________________________________<BR>rock= -user mailing list<BR>[email protected]<BR><A href=3D"http://www.rock= linux.net/mailman/listinfo/rock-user" target=3D_blank>http://www.rocklinux.= net/mailman/listinfo/rock-user</A></DIV></DIV><BR></DIV>th</div><br>=0A=09= =09<hr size=3D"1"> =0AD=E9couvrez une nouvelle fa=E7on d'obtenir des r=E9po= nses =E0 toutes vos questions ! =0AProfitez des connaissances, des opinions= et des exp=E9riences des internautes sur <a href=3D"http://fr.rd.yahoo.com= /evt=3D42054/*http://fr.answers.yahoo.com">Yahoo! Questions/R=E9ponses</a>.= </body></html> --0-1675478497-1164702772=:44433-- --===============1074768817== Content-Type: text/plain; charset="us-ascii" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Content-Disposition: inline _______________________________________________ rock-user mailing list [email protected] http://www.rocklinux.net/mailman/listinfo/rock-user --===============1074768817==--