How To Reset phpMyAdmin In Centos

How To Reset phpMyAdmin In Centos

Description:

After install Lamp in the local Centos machine unfortunately phpMyAdmin password was forgot.How can reset the password without lose the data.

Steps:

– Login to the server with root login details.

– Stop the mysql services.

    $service mysql stop

– Run and skip the grant tables in mysqld

             $mysqld –skip-grant-tables &

– Now Login MYSQL as a root

$mysql -u root mysql

– change the password using the below command,

    UPDATE user SET Password=PASSWORD(‘XXXXXXX’) WHERE User=’root’; FLUSH PRIVILEGES; exit;

– Now kill the mysqld process using below,

           $pkill mysqld

– Start mysql

     $service mysql start

– Login phpMyAdmin using the reset password.

Tags: phpmyadmin,root,centos,phpmyadmin password,centos root password,phpmyadmin