Re: MySQL startup confused [SOLVED]

On Tue, 2005-01-11 at 21:10, Alexander Dalloz wrote:
> That was Jason's quick guess. And having a look at the mysql init script
> you will find following comment:
> 
>         # If you've removed anonymous users, this line must be changed
> to
>         # use a user that is allowed to ping mysqld.
>         ping="/usr/bin/mysqladmin -uUNKNOWN_MYSQL_USER ping"

The update from January 5 does it in an even better way (see the
bugzilla mentioned earlier in th thread)

        # Spin for a maximum of N seconds waiting for the server to come
up.
        # Rather than assuming we know a valid username, accept an
"access
        # denied" response as meaning the server is functioning.
        if [ $ret -eq 0 ]; then
            STARTTIMEOUT=10
            while [ $STARTTIMEOUT -gt 0 ]; do
                RESPONSE=`/usr/bin/mysqladmin -uUNKNOWN_MYSQL_USER ping
2>&1` &&
 break
                echo "$RESPONSE" | grep -q "Access denied for user" &&
break
                sleep 1
                let STARTTIMEOUT=${STARTTIMEOUT}-1
            done
            if [ $STARTTIMEOUT -eq 0 ]; then
                    echo "Timeout error occurred trying to start MySQL
Daemon."
                    action $"Starting $prog: " /bin/false
            else
                    action $"Starting $prog: " /bin/true
            fi
        else
            action $"Starting $prog: " /bin/false
        fi

I.e. an "Access denied for user" is also considered as an indication
that the server is up.

Lars
-- 
Lars E. Pettersson <lars@xxxxxxxx>
http://www.sm6rpz.se/