Many people have problems after upgrading phpMyAdmin.
They simply can not log back into the program with error 1045 - # 1045 - Access denied for user.
How to solve?
Well, to reset the root password can even solve, but our problem is not the password. We know the password. Our problem is another one.
When authentication to log into phpMyAdmin is configured as a cookie, we may incur in this type of error.
How to solve?
Let's look in / etc / phpMyAdmin/ config.php
Find the line: / * Authentication type * /
$ cfg ['Servers'] [$ i] ['AUTH_TYPE'] = 'cookie';
And change from cookie to http.
So, when we log into phpMyAdmin, it will not search for a cookie from the webbrowser (which may have been deleted), it makes a request for username and password interactively.
Okay, now you can log into phpMyAdmin.
After logging in, work on it, do what you need, then, you can return the value for cookie in the file config.php.
It will work perfectly after having logged the 1st time.
Best regards
