mysql_secure_installation 정책에 관해

Question

제가 다른게시물 보고 https://www.digitalocean.com/community/tutorials/how-to-install-mysql-on-ubuntu-20-04 이거까지 했는데 계속 새로운 비밀번호 입력 하라고 뜨네요 ㅠㅠ 이런 경우 어떻게 해야할까요 비밀번호도 보안수준에 맞게 했는데 계속 뜨네요 ㅠㅠ

제로초(조현영) · Answer

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

Ritik Raj · Answer

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.

장산 · Answer

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