How to remove MySQL root password
I have also been through this problem,
First i tried setting my password of root to blank using command :
SET PASSWORD FOR root@localhost=PASSWORD('');
But don't be happy , PHPMYADMIN uses 127.0.0.1 not localhost , i know you would say both are same but that is not the case , use the command mentioned underneath and you are done.
SET PASSWORD FOR [email protected]=PASSWORD('');
Just replace localhost with 127.0.0.1 and you are done .
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 ''