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

저 링크에 빨간 부분 있습니다. 그게 그 부분에 관련된 설명입니다. 그 부분을 수행하고 나면 Yes로 해도 다음으로 진행 가능합니다...

I encountered an issue while trying to run the mysql_secure_installation command after setting up MySQL on Ubuntu 24.04. The process was supposed to help secure my MySQL installation by setting up root passwords, removing test databases, and other security features, but I kept running into permission errors and misconfigurations in the process.

I followed the steps outlined in the Vultr guide for installing MySQL on Ubuntu 24.04, which was very helpful for setting up MySQL in the first place. However, I realized that I missed configuring the MySQL root authentication method, which was causing the issues with mysql_secure_installation. Once I properly set the root authentication method to mysql_native_password and restarted MySQL, everything worked fine.

If you're facing similar issues with the mysql_secure_installation process, I recommend checking your root user authentication method first and ensuring MySQL is properly configured. Here’s the detailed guide from Vultr to help you with the installation and configuration:
How to Easily Install MySQL on Ubuntu 20.04 It helped me resolve the issue by guiding me through all the necessary steps.

Yes 말고 no로 해야지 넘어가네요!