mysql_secure_installation password 질... - 인프런

I encountered a frustrating issue when running the mysql_secure_installation command, where I kept getting the following error:

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.

Despite reinstalling MySQL and setting the local password again, the error persisted, leaving me stuck in a loop.

I found a detailed and reliable guide from Vultr that helped me resolve this issue step by step. The guide explained that the root user's authentication method might be set to auth_socket by default on Ubuntu, which causes the issue. To fix this, I followed the steps outlined below:

Steps I Took to Fix the Issue:

Log into MySQL: I logged into MySQL as root with:
```
sudo mysql
```
Change the Authentication Method: The default authentication plugin (auth_socket) was the cause of the issue. I ran the following command to change the authentication method to mysql_native_password:
```
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'mynewpassword';
```
Exit MySQL: After that, I exited the MySQL prompt with:
```
exit
```
Secure the MySQL Installation: Now, I ran the mysql_secure_installation command again, and this time, it worked without any issues.

The guide from Vultr made it much easier to resolve this problem, especially with the clarification on changing the authentication method and password using the ALTER USER command instead of SET PASSWORD. This simple fix saved me a lot of time and effort, and I highly recommend referring to the Vultr documentation if you're facing similar issues.

For more detailed steps, you can check out the official guide here:
Quick MySQL Installation Guide for Ubuntu 20.04

인프런 커뮤니티 질문&답변

mysql_secure_installation password 질문이요

Steps I Took to Fix the Issue: