Ubuntu
mysql-8.0 package

  1. Bug #1980466
  2. Comment #0

Comment 0 for bug 1980466

Revision history for this message
Joseph Chris (josephcz) wrote :

When I am trying to use mysql_secure_installation after I installed MySQL server, it ends up with loop asking me the new root password.

To reproduce the bug:
apt install mysql-server
mysql_secure_installation

Version:
Ubuntu Server 20.04.4
mysql-server (8.0.29-0ubuntu0.20.04.3)

Logs:
root@server# mysql_secure_installation

Securing the MySQL server deployment.

Connecting to MySQL using a blank password.

VALIDATE PASSWORD COMPONENT can be used to test passwords
and improve security. It checks the strength of password
and allows the users to set only those passwords which are
secure enough. Would you like to setup VALIDATE PASSWORD component?

Press y|Y for Yes, any other key for No: n
Please set the password for root here.

New password:

Re-enter new password:
 ... Failed! Error: SET PASSWORD has no significance for user 'root'@'localhost' as the authentication method used doesn't store authentication data in the MySQL server. Please consider using ALTER USER instead if you want to change authentication parameters.

New password: