Re: [gentoo-user] mysql won't start
On Monday 12 June 2006 08:04, Ralph Slooten wrote: > > Is it /var/run/mysql or /var/run/mysqld? > > You should probably recreate /var/run/mysqld > > and set the permissions. > > /var/run/mysqld must have mysql:mysql permissions (drwxr-xr-x) > > > And make /etc/my.cnf a symlink to /etc/mysql/my.cnf > > CLI utilities probably look for /etc/my.cnf > > No, this is not needed. CLI programs will use whatever the mysql default > is, and mysql is compiled under gentoo with /etc/mysql/my.cnf as default. > > Greetings, > Ralph I have this as well, I think this came about with an update sometime this week. Mysql was not updated, but there must have been something in one of teh baselayouts or something? Mike -- Michael W. Holdeman Powered by Gentoo Linux www.gentoo.org | Kernel 2.6.15-ck2 | VMWare Workstation 5.5.1 vmware.com | Win4LinPro 6.1.1-03 win4lin.com | | -- gentoo-user@gentoo.org mailing list
Re: [gentoo-user] mysql won't start
Is their anything else that should not be root root in /var/run or /var/tmp ?? Probably. It depends on the programs you've installed. Next time use cp -Rp to preserve the permissions. Sasha -- gentoo-user@gentoo.org mailing list
Re: [gentoo-user] mysql won't start
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 > Is it /var/run/mysql or /var/run/mysqld? > You should probably recreate /var/run/mysqld > and set the permissions. /var/run/mysqld must have mysql:mysql permissions (drwxr-xr-x) > And make /etc/my.cnf a symlink to /etc/mysql/my.cnf > CLI utilities probably look for /etc/my.cnf No, this is not needed. CLI programs will use whatever the mysql default is, and mysql is compiled under gentoo with /etc/mysql/my.cnf as default. Greetings, Ralph -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.0 (MingW32) iD8DBQFEjVhnCt0ZF9kLPvYRArl5AJ4pLbYPQ69iX++2XjCWLDMaHDkuKACglNO2 F0ZmfCaF1C4gWRcQ1EXVBr8= =CF4Q -END PGP SIGNATURE- -- gentoo-user@gentoo.org mailing list
Re: [gentoo-user] mysql won't start
On Monday 12 June 2006 12:09, Alexander Kirillov wrote: > > So it looks as if I have really screwed up moving /var > > The /var/run/mysql directory is empty > > Check the permissions on /var/run/mysql. > It should be owned by mysql. > What's in mysql logs? They're probably in /var/log/mysql > > Sasha Thanks Sasha that was the problem I changed the owner to mysql and mysql started ok. Thanks for the hint. Is their anything else that should not be root root in /var/run or /var/tmp ?? Thanks again Paul -- This message has been sent using kmail with gentoo linux -- gentoo-user@gentoo.org mailing list
Re: [gentoo-user] mysql won't start
I moved my /var to a new disk and now amarok will nor work because it can't connect to mysql Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) If I /etc/init.d/mysql stop * Caching service dependencies ... [ ok ] * WARNING: mysql has not yet been started. If I /etc/init.d/mysql start * ... * Starting mysql (/etc/mysql/my.cnf) * MySQL NOT started (0) If I just type mysql, I get the following error:- ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) So it looks as if I have really screwed up moving /var The /var/run/mysql directory is empty On the second thought. Is it /var/run/mysql or /var/run/mysqld? You should probably recreate /var/run/mysqld and set the permissions. And make /etc/my.cnf a symlink to /etc/mysql/my.cnf CLI utilities probably look for /etc/my.cnf HTH, Sasha -- gentoo-user@gentoo.org mailing list
Re: [gentoo-user] mysql won't start
I moved my /var to a new disk and now amarok will nor work because it can't connect to mysql Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) If I /etc/init.d/mysql stop * Caching service dependencies ... [ ok ] * WARNING: mysql has not yet been started. If I /etc/init.d/mysql start * ... * Starting mysql (/etc/mysql/my.cnf) * MySQL NOT started (0) If I just type mysql, I get the following error:- ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) So it looks as if I have really screwed up moving /var The /var/run/mysql directory is empty Check the permissions on /var/run/mysql. It should be owned by mysql. What's in mysql logs? They're probably in /var/log/mysql Sasha -- gentoo-user@gentoo.org mailing list
[gentoo-user] mysql won't start
Sorry if this is duplicate but I don't think the original arrived. Hi all, I moved my /var to a new disk and now amarok will nor work because it can't connect to mysql Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) If I /etc/init.d/mysql stop * Caching service dependencies ... [ ok ] * WARNING: mysql has not yet been started. If I /etc/init.d/mysql start * ... * Starting mysql (/etc/mysql/my.cnf) * MySQL NOT started (0) If I just type mysql, I get the following error:- ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) So it looks as if I have really screwed up moving /var The /var/run/mysql directory is empty Can anybody help please. Paul -- This message has been sent using kmail with gentoo linux -- gentoo-user@gentoo.org mailing list
[gentoo-user] mysql won't start
Hi all, I moved my /var to a new disk and now amarok will nor work because it can't connect to mysql Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) If I /etc/init.d/mysql stop * Caching service dependencies ... [ ok ] * WARNING: mysql has not yet been started. If I /etc/init.d/mysql start * ... * Starting mysql (/etc/mysql/my.cnf) * MySQL NOT started (0) If I just type mysql, I get the following error:- ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) So it looks as if I have really screwed up moving /var The /var/run/mysql directory is empty Can anybody help please. Paul -- This message has been sent using kmail with gentoo linux -- gentoo-user@gentoo.org mailing list
