MySQL Warning: Using unique option prefix pass instead of password is deprecated and will be removed in a future release. Please use the full name instead.

Applicable to:

Symptoms

The following warning appears upon an attempt to create a mysql backup or run mysqldump

Warning: Using unique option prefix pass instead of password is deprecated and will be removed in a future release. Please use the full name instead.

mysqldump

mysql_upgrade -h localhost -u admin -p`cat /etc/psa/.psa.shadow `Warning: Using unique option prefix pass instead of password is deprecated and will be removed in a future release. Please use the full name instead.Looking for 'mysql' as: mysqlLooking for 'mysqlcheck' as: mysqlcheck...

mysqldump

mysqldump -uadmin -p`cat /etc/psa/.psa.shadow ` psa > /tmp/psa.`date +%F_%H.%M`.sqlWarning: Using unique option prefix pass instead of password is deprecated and will be removed in a future release. Please use the full name instead.

Cause

MySQL programs read startup options from the following files, in the specified order:

/etc/my.cnf

/etc/mysql/my.cnf

SYSCONFDIR/my.cnf

$MYSQL_HOME/my.cnf

defaults-extra-file (The file specified with --defaults-extra-file=path, if any)