How to remove MySQL root password [closed]

October 8, 2022 by Tarik

You need to set the password for root@localhost to be blank. There are two ways:

The MySQL SET PASSWORD command:

SET PASSWORD FOR root@localhost=PASSWORD(''); -- MySQL 5.x
SET PASSWORD FOR root@localhost=""; -- MySQL 8.x

Using the command-line mysqladmin tool:

mysqladmin -u root -pType_in_your_current_password_here password ''