Why does this strange error occur when trying to login with phpMyAdmin?

H

HellWalk2018-05-25 09:31:21

MySQL

HellWalk, 2018-05-25 09:31:21

MariaDB is installed on a remote server.
There is a user with a database - everything is ok with him, he connects normally through phpMyAdmin.
It is necessary to add a new user - I tried to log in as root in phpMyAdmin - it does not work (but if you go to the server itself via ssh and log in via the console - everything is OK). Thought it was some sort of protection. I created a new user with the database through the console, I try to log in - again an error (via the console - logs in).
Moreover, the error is strange - I connect to one IP and another IP is indicated in the error:

Has anyone encountered such an error?

Reply

Answer the question

In order to leave comments, you need to log in

4 answer(s)

I

iljaGolubev, 2018-05-25
@iljaGolubev

https://mariadb.com/kb/en/library/configuring-mari...
By default, root access is only allowed locally.

V

vlarkanov, 2018-05-25
@vlarkanov

How did you create the user? With a wildcard ('newgangs'@'%') or with a specific ip ('newgangs'%'some_ip')? After creation did FLUSH PRIVILEGES?

R

Ruslan Fedoseev, 2018-05-25
@martin74ua

192.168.1.62 is the computer where phpmyadmin is located?
mysql server is running on another server? is the user on the remote server allowed to access the server's ip with phpmyadmin ?