[gentoo-user] mysql won't start

[gentoo-user] mysql won't start

[Paul Stear]

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

[Paul Stear]

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

Re: [gentoo-user] mysql won't start

[Alexander Kirillov]

> 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

Re: [gentoo-user] mysql won't start

[Alexander Kirillov]

> 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

[Paul Stear]

On Monday 12 June 2006 12:09, Alexander Kirillov wrote:
<snip>
> > 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

[Ralph Slooten]

-----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

[Alexander Kirillov]

> 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

[Michael W. Holdeman]

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