Resetting or Changing PHPMyAdmin Password On Linux - Kvcodes

Congrats, You are Subscribed to Receive Updates.

Resetting or Changing PHPMyAdmin Password On Linux

Resetting or Changing PHPMyAdmin Password On Linux. Sometimes you might have the problem of resetting your phpmyadmin password. Everytime it makes you to feel big to work.  And some tutorials are not nice to read and follow. because they may suggested the final step mainly. Let me elaborate you in detail.


Just goto your Terminal. Just do the following steps.

Stop the MySQL server to get `mysqld` access to change your admin password.

sudo service mysql stop

Start mysqld to access the mysql table directly without mysql Server.

sudo mysqld --skip-grant-tables &

Login to MySQL as root without providing password. So, if you forget the Root password, you can reset with it.

mysql -u root mysql

Change KVCODES with your new root password

UPDATE user SET Password=PASSWORD('KVCODES') WHERE User='root'; FLUSH PRIVILEGES; exit;  // Change your password instead of KVCODES

Kill mysqld after changing the password

sudo pkill mysqld

Start mysql  and phpmyadmin

sudo service mysql start

Login to phpmyadmin as root with your new password.


About Varadharaj V

The founder of Kvcodes, Varadharaj V is an ERP Analyst and a Web developer specializing in WordPress(WP), WP Theme development, WP Plugin development, Frontaccounting(FA), Sales, Purchases, Inventory, Ledgers, Payroll & HRM, CRM, FA Core Customization, OpenCart Theme Development, PHP, HTML, CSS, jQuery, Bootstrap development and content SEO.

Comment Below

Your email address will not be published. Required fields are marked *


Current ye@r *



Subscribe E-mail Updates

Congrats, You are Subscribed to Receive Updates.


Category Posts