rajibdpi/SQLSTATE[HY000] [1698] Access denied for user 'root'@'localhost'.md

Last active October 5, 2024 17:20

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/rajibdpi/93a555d28ba08ae3814fca4b46a8bf76.js"></script>
Save rajibdpi/93a555d28ba08ae3814fca4b46a8bf76 to your computer and use it in GitHub Desktop.

phpMyAdmin Cannot log in to the MySQL server. and it showing SQLSTATE[HY000] [1698] Access denied for user 'root'@'localhost'

Raw

SQLSTATE[HY000] [1698] Access denied for user 'root'@'localhost'.md

phpMyAdmin Cannot log in to the MySQL server. and it showing SQLSTATE[HY000] [1698] Access denied for user 'root'@'localhost'

sudo mysql -u root

use mysql;
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'new_password';
or 
DROP USER root@localhost;
CREATE USER root@localhost IDENTIFIED BY 'root_password';
GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost';
FLUSH PRIVILEGES;

sudo service apache2 restart