Work at SourceForge, help us to make it a better place! We have an immediate need for a Support Technician in our San Francisco or Denver office.
The full error reported on login page of adminer (v3.3.4) is: Access denied for user 'root'@'host' (using password: YES)
I can log in as root in phpmyadmin and from the command line using: mysql -uroot -p
I can also log in as a normal user on this same host, but one of the main reasons I'm looking to get away from phpmyadmin is for tasks that require admin perms.
What am I missing?
It looks like that you didn't fill the server name.
I did fill in the server name. I just removed it for the post to be generic. I also tried the ip address of the server, same result.
I shut down both firewalls, on the client machine, and on the server still same result. Nothing is showing up in any of the logs in /var/log/mysql or /var/log/messages or /var/log/syslog.
I found it, it was the permissions on the root account in mysql.
By the way, I forgot to mention. This is a great script. It feels good to get away from phpmyadmin. Thanks!