Thursday, January 5, 2017

Resetting MySQL Root Password with XAMPP on Localhost

Steps:
  1. Open your phpMyadmin dashboard
  2. go to user accounts
  3. on the user section Get the root user and click [ Edit privileges ]
  4. in the top section you will find change password button [ click on it ]
  5. make a good pass and fill 2 pass field
  6. now hit the Go button
  7. now open your xampp dir ( c:/xampp )
  8. to phpMyadmin dir [C:\xampp\phpMyAdmin]
  9. open [ config.inc.php ] file with any text editor
  10. find [ $cfg['Servers'][$i]['auth_type'] = 'config'; ]line and replace 'config' to ‘cookie’
  11. go to [ $cfg['Servers'][$i]['AllowNoPassword'] = true; ] this line change ‘true’ to ‘false’
 last : save the file .

No comments:

Post a Comment