root@gideon:/videos# mysql -p'f'
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 1762
Server version: 10.1.26-MariaDB-0+deb9u1 Debian 9.1
Copyright (c) 2000, 2017, Oracle, MariaDB Corporation Ab and others.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
MariaDB [(none)]> quit
Bye
root@gideon:/videos# mysql -u root -p'sdfsdfsdfsdf'
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 1775
Server version: 10.1.26-MariaDB-0+deb9u1 Debian 9.1
Copyright (c) 2000, 2017, Oracle, MariaDB Corporation Ab and others.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
MariaDB [(none)]> quit
Bye
root@gideon:/videos# mysql -u root -p'aaaaaaaa'
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 1780
Server version: 10.1.26-MariaDB-0+deb9u1 Debian 9.1
Copyright (c) 2000, 2017, Oracle, MariaDB Corporation Ab and others.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
MariaDB [(none)]> quit
Bye
root@gideon:/videos# mysql -u root -p'mariadbsucks!'
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 1786
Server version: 10.1.26-MariaDB-0+deb9u1 Debian 9.1
Copyright (c) 2000, 2017, Oracle, MariaDB Corporation Ab and others.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
MariaDB [(none)]> quit
Bye
Соответственно менял пароли через апдейт mysql.user, и через mysql_secure_installation - одно и то же. А вот через phpmyadmin с этого же хоста - попасть не могу с любым паролем, в том числе тем который я установил. Пустым тоже не могу.
root@gideon:/videos# mysqld -V
mysqld Ver 10.1.26-MariaDB-0+deb9u1 for debian-linux-gnu on x86_64 (Debian 9.1)
Как побороть эту фичу ?
