I recently had "Error: MySQL shutdown unexpectedly" which was resolved by following the answer on this thread https://stackoverflow.com/a/61859561/18680774
Now I am getting a new error
Cannot connect: invalid settings.
mysqli::real_connect(): (HY000/1045): Access denied for user 'root'@'localhost' (using password: YES)
phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in your configuration and make sure that they correspond to the information given by the administrator of the MySQL server.
I have tried several suggestions posted on heere but none works. My password and other database credentials are correct but still getting the error.
Upadete: when i change the
$cfg['Servers'][$i]['user'] = 'root'; to $cfg['Servers'][$i]['user'] = 'pma';
and remove the password, i am able to log into phpmyadmin but I can't see any of tables my tables