mysql startup
Doug Currey
doug at curreycentral.com
Sat Nov 15 21:03:57 UTC 2003
Here is what I did to get around this.
Create a mysql user. Give it a passwd but no permissoins.
edit the /etc/rc.d/init.d/mysqld file
change the line
if !([ -n "`/usr/bin/mysqladmin ping 2> /dev/null`" ]); the
to
if !([ -n "`/usr/bin/mysqladmin -u mysqluser -puserpass ping 2>
/dev/null`" ]); then
This should alllow the mysqluser to ping
Doug
----- Original Message ----- if
From: "James Box" <fedora at f117a.org.uk>
To: <fedora-list at redhat.com>
Sent: Saturday, November 15, 2003 2:10 PM
Subject: Re: mysql startup
> Resending due to moderation issue:
>
> Ryan Rothert wrote:
>
> > After an upgrade of a RH9 box to Fedora I get this when trying to start
> > MySQL.
> >
> > # /etc/init.d/mysqld start
> > Timeout error occurred trying to start MySQL Daemon.
> > Starting MySQL: [FAILED]
> >
> > However, even though the script says it FAILED, mysql seems to be
running
> > just fine.
>
> I saw the same thing. Looking at the startup script, it seems that it
> checks that mysqld is running with a 10 second timeout. It does this
> with 'mysqladmin ping'.
>
> Unfortunately, for any secure mysql server, this will fail.
>
> # /usr/bin/mysqladmin ping
> /usr/bin/mysqladmin: connect to server at 'localhost' failed
> error: 'Access denied for user: 'root at localhost' (Using password: NO)'
>
More information about the users
mailing list