Unable to secure MySQL on fresh LEMP droplet
When ssh into the droplet as root, I am able to just type
mysql and launch MySQL anonymously.
I then exited, and ran
mysql_secure_installation, and followed all the prompts to remove the anonymous user, and set a root password.
I then stopped
/etc/init.d/mysql stop and started it back up again
I then typed
mysql again, and was still able to have full access to mysql anonymously as the root OS user. I expected to be denied access.
Keeping mysql running, I ran
mysql_secure_installation again, and was NOT prompted to enter my current password.
Stopping mysql and then running
mysql_secure_installation, I WAS prompted to enter my current password, but because the service had been stopped, it was not able to do anything.
What am I doing wrong?
These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.×