cara reset password mysql / phpmyadmin di ubuntu atau turunan nya

“Access denied for user ‘root’@’localhost’.

So I came up with this solution from here.

Short steps are:

sudo mysql -u root 

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'test';

Note: here test is a new password for the root user. Also, remember to run the command sudo service mysql restart after altering the user.

Happy Database Everyone!

Bagikan Artikel ini