init script test db with wrong credential

[emilio brambilla]

on percona-xtradb-cluster-server-5.6 /etc/init.d/mysql init script the db status test has hardcoded username and password:

mysql -u root -pabcd -e 'select 1;' 2>&1 | grep 'ERROR 2002'

I know it is not necessary to have a working account to check for "ERROR 2002" (cannot connect), but this abcd password is very dirty and logs a warning on mysql logs: "Access denied for user 'root'@'localhost' (using password: YES)"

[Raghavendra D Prabhu (raghavendra-prabhu)]

Yes, it can be replaced with mysqladmin ping (which should work even with wrong creds).

[Nilnandan Joshi (nilnandan-joshi)]

Confirmed with PXC 5.5.41 and 5.6.22. It seems, this issue is only with deb packages.

mysqld_status () {
    mysqld_pid=$(cat $pid_file 2>/dev/null)

    if [ ! $mysqld_pid ];then
        echo "MySQL PID not found, pid_file detected/guessed: $pid_file" | $ERR_LOGGER
        if [ "$1" = "check_dead" ]; then
            return 0
        fi
        return 1
    fi

    ping_alive=1
    ps_alive=0

    soutput=$(mysql -u root -pabcd -e 'select 1;' 2>&1 | grep 'ERROR 2002')
    [ "$soutput" ] && ping_alive=0

[Shahriyar Rzayev (rzayev-sehriyar)]

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PXC-1815