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.
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: installation
apt install mysql-server
mysql_secure_
Version: 0ubuntu0. 20.04.3)
Ubuntu Server 20.04.4
mysql-server (8.0.29-
Logs: installation
root@server# mysql_secure_
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: