Configure MySQL Server password on Ubuntu 20.04

Posted on under English, Tutorials

Recently, the MySQL package on Ubuntu was changed, so the user is no longer prompted to enter the password during installation. These instructions will help you set the password on Ubuntu 18.04, 18.10, 19.04, 19.10, 20.04, and others.

Step 1. Install MySQL server (if you haven’t already)

apt install -y mysql-server php-mysql

Step 2. Setup password authentication method

mysql -u root
USE mysql;
UPDATE user SET plugin='mysql_native_password' WHERE User='root';
service mysql restart

Step 3. Set the root password

Enter current password for root (enter for none): Just press Enter
Set root password? [Y/n]: Y
New password: Enter password
Re-enter new password: Repeat password
Remove anonymous users? [Y/n]: Y
Disallow root login remotely? [Y/n]: Y
Remove test database and access to it? [Y/n]:  Y
Reload privilege tables now? [Y/n]:  Y

Step 4. Test the settings

mysql -u root -p

Try with no password and with correct password.