I just installed MySQL (Ver 14.14 Distrib 5.7.22) on Ubuntu 18.04 and I discovered something weird:
I installed MySQL and used mysql_secure_installation
to set a password for root, but as soon as I am logged in SSH with any user with sudo-rights, I can simply access MySQL without being prompted to enter a password via mysql -u root
or via mysql -u root -p
& simply clicking ENTER (when asked "Enter password:").
Is this normal?
I know from prior versions that I always had to enter a password when I wanted to access MySQL, even with sudo.