Configure MySQL Server password on Ubuntu 20.04

Configure MySQL Server password on Ubuntu 20.04

Comments 0

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.


Comments (0)

Please be civil when commenting. Think before writing, don't spam, self promote, bully, harass or harm anyone. Please read the Comment Policy before posting. Comments are moderated.

There are no comments.
Be the first to contribute!

Scroll to top