Resetting forgotten phpmyadmin password

Resetting forgotten phpmyadmin password

Simply change or reset your MySQL root password by doing the following:

Run the following commands in Terminal

Step 1 :Stop the MySQL server

sudo service mysql stop

Step 2 : Start mysqld

sudo mysqld --skip-grant-tables $;

Step 3:Login to MySQL as root

mysql -u root mysql

Step 4 :Change MYSECRET with your new root password

UPDATE user SET Password=PASSWORD('MYSECRET') WHERE User="root";

Step 5 :Kill mysqld

sudo pkill mysqld

Step 6 :Start mysql

sudo service mysql start

Step 7 :Login to phpmyadmin as root with your new password

web tips and tricks
web tips and tricks

Topics related Resetting forgotten phpmyadmin password

forgot phpmyadmin password wamp,
forgot phpmyadmin password xampp,
forgot phpmyadmin password ubuntu,
ubuntu reset mysql password


Leave a Reply