Changing phpmyadmin password on localhost
In this tutorial I will show you how to change the phpmyadmin login password on localhost using Mac.
Open phpMyAdmin and select the SQL tab and type this command:
SET PASSWORD FOR 'root'@'localhost' = PASSWORD('your_root_password');
Change to this line in config.inc.php to make phpMyAdmin prompts for your MySQL username and password.
$cfg['Servers'][$i]['auth_type'] = 'cookie';
