#539 Access denied for Permanent Login

[dhenoer]

Dear Admin,

If I checked on Permanent Login field, login always failed with error message "Access denied for user 'root'@'localhost' (using password: NO)"

This problem doesn't happen on 4.2.5 version.
Thanks.

Mysql: Ver 14.14 Distrib 5.7.17, for Linux (x86_64)
Webserver: Lighttpd/1.4.35 (ssl)
Browser: Firefox Mozilla 52.0 (64bit) on Ubuntu Mate 16.04.

[Jakub Vrána]

Please try to delete all Adminer cookies.

[dhenoer]

I have tried clear cookies as you mentioned. I also tried using private /incognito mode. The last tried using guest account to login in my machine. Technically, browser should using fresh configuration, empty cookies, empty caches.
At first, it works once. But after I clicked logout, and login again, still failed get error message until I uncheck Permanent Login..

[Michal Konečný]

I have the same problem. For some databases I'm able to login after deleting cookies, but for others (on the same server) the only way is open it in anonymous window. Windows 10, Chrome, MySQL 5.6.16.

[Michal Konečný]

In Edge is it OK, the problem is probably related to SameSite cookie https://github.com/vrana/adminer/commit/9d7d30891eec00a060e5b92d8f113e4aa9923808

[Jaromir Obr]

I have the same issue since 4.3.0, I'm not able to login to MySQL DB using permanent login. I deleted all cookies, but it doesn't help. Tested in Chrome/Firefox, both browsers are affected.

Used SW:

• Adminer 4.3.0, Chrome 57, Firefox 52.0, Win 10
• 5.5.5-10.0.27-MariaDB-1~trusty through PHP extension MySQLi

[Timothy White]

We are also having this issue. If we rebuild the docker container we are running it in (so new server essentially), delete all our cookies, the first "premanent login" works, all others fail for mysql and other users.
If we don't delete our cookies, we get errors about the master password changing (as you'd expect, as the /tmp/adminer.key file changes), and once we clear our cookies, the first login works, all others fail.

As long as we don't use permanent logins, we are fine.

[Qcybb]

I'm also having this issue. When enabling "Permanent login", I get the error :

Access denied for user 'root'@'localhost' (using password: NO)

[Jakub Vrána]

It was caused by the PHP function header overwritting the headers by default. It took me a day to debug.

[Jakub Vrána]

Fixed by https://github.com/vrana/adminer/commit/fb7bd027.

[Qcybb]

Thank you, that fix solved the issue for me.