"Permission denied" error from Adminer with [email protected]

I'm trying to use Adminer to connect to MariaDB database, but I get "Permission denied" error when I press the Login-button. Note that this is NOT "Access denied" which I'd expect if e.g. password is wrong.

This is my first time using MariaDB, and I'm also quite new to CentOS, do I'm unsure of what is wrong here. Some debugging and settings about my system is listed below.

Connecting to MariaDB from PHP does work, e.g. with this test script:

<?php $db = mysqli_connect('127.0.0.1','root','mypassword')   or die(mysqli_error()); var_dump($db); 

Using mysql -h 127.0.0.1 -u root -p from console also works, and also netstat confirms that mysqld is listening:

$ sudo netstat -tlpn | grep mysqld tcp        0      0 127.0.0.1:3306          0.0.0.0:*               LISTEN      16428/mysqld 

MariaDB Grants:

MariaDB [(none)]> show grants; +--------------------------------------------------------------------------------------------------+ | Grants for [email protected]                                                                        | +--------------------------------------------------------------------------------------------------+ | GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' IDENTIFIED BY PASSWORD '...' WITH GRANT OPTION | | GRANT PROXY ON ''@'%' TO 'root'@'localhost' WITH GRANT OPTION                                    | +--------------------------------------------------------------------------------------------------+ 

Settings in Adminer:

System: MySQL Server: 127.0.0.1 Username: root Password: mypassword Database: (none) 

My system:

CentOS 7 Apache 2.4.6 PHP 5.4.16 MariaDB 10.1.16 Adminer 4.2.5 

Replay

Category: php Time: 2016-07-30 Views: 1

Related post

iOS development

Android development

Python development

JAVA development

Development language

PHP development

Ruby development

search

Front-end development

Database

development tools

Open Platform

Javascript development

.NET development

cloud computing

server

Copyright (C) avrocks.com, All Rights Reserved.

processed in 0.192 (s). 12 q(s)