Changed phpmyadmin password on mac using AMPPs and now Can not login into phpmyadmin

Question

I've changed password of localhost user of my AMPPS stack and now I can not log into phpmyadmin It Shows a pink message : Access Denied..., I have tried restoring all default configuration but have the same problem.

I've checked config.inc file and it's content was :

<?php

/* Servers configuration */
$i = 0;

/* Server: localhost [1] */
$i++;
$cfg['Servers'][$i]['verbose'] = '';
$cfg['Servers'][$i]['host'] = '127.0.0.1';
$cfg['Servers'][$i]['port'] = '';
$cfg['Servers'][$i]['socket'] = '';
$cfg['Servers'][$i]['connect_type'] = 'tcp';
$cfg['Servers'][$i]['extension'] = 'mysqli';
$cfg['Servers'][$i]['auth_type'] = 'config';
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = file_get_contents('/Applications/AMPPS/ampps/data/my.conf');
$cfg['Servers'][$i]['hide_db'] = '(information_schema|performance_schema)';

/* End of servers configuration */

$cfg['DefaultLang'] = 'en-utf-8';
$cfg['blowfish_secret'] = '';
$cfg['ServerDefault'] = 1;
$cfg['UploadDir'] = '';
$cfg['SaveDir'] = '';

?>

This is my.conf file part that is related to the password :

# The following options will be passed to all MySQL clients
[client]
#password   = your_password
port        = 3306
socket      = {$path}/var/mysql.sock

I have checked mysql.ini file too and there was just one field like :

# PASSWORD = (your passwrod)

I removed # from the begining of that line and saved the file and I restarted Apache and mysql. I even quited the app and then reopend it but the problem was there and nothing changed.

I've checked my codes to see if I'm able to use my codes with the new password and it was working but the only problem is I can not go to phpmyadmin anymore.

Answer 1

I had the same issue and this solution worked for me : You can Reinstall It Again, Or if you don't want to lose anything just install it on another drive or disk and copy past configuration files. Remember If you want to change phpmyadmin password go to ampps app and from it's panel go to change mysql password from there you can change mysql and phpmyadmin password without any problem. the default password of mysql and phpmyadmin is 'mysql'.

Hope solve your problem.