Bug #81404 misleading error message of alter user

• Submitted: 12 May 2016 18:49
• Modified: 13 May 2016 8:51
• Reporter: Louis Cardali
• Status: Verified
• Category: MySQL Server: Security: Privileges
• Severity: S3 (Non-critical)
• Version: 5.7.12
• OS: Ubuntu
• CPU Architecture: Any

[12 May 2016 18:49] Louis Cardali

Description:
Fresh install forces a password change from the installation created password. Tells to use ALTER USER, which fails and repeats the error to use ALTER USER.

How to repeat:
Did a fresh install of MySQL 5.7 on Ubuntu 15.10

Started the MySQL CLI and used the credentials provided in the install.

# mysql -u root -p
mysql> create database iamtesting;
ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.
mysql> alter user root identified by 'new-passwd';
ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.

Work around is to use set password.
mysql>set password = 'new-passwd';
Query OK, 0 rows affected (0.00 sec)

[13 May 2016 8:51] MySQL Verification Team

Hello Louis Cardali,

Thank you for the report.

Thanks,
Umesh