Home » Internet » 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 tricksTopics related Resetting forgotten phpmyadmin password

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

Leave a Reply


Check Also

website development

How to disable AdBlock extensions for a particular website

Example website is smarttips.in ,replace with your website and guide your users to disable the ...