# Изменение настроек разрешения подключений пользователя root по tcp/ip
(меняем plugin с 'unix_socket' на '')

root@www:~# mysql -uroot -p mysql

Enter password:
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 2289137
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 [mysql]> update user set plugin='' where user='root';
Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0

MariaDB [mysql]> flush privileges;
Query OK, 0 rows affected (0.00 sec)

MariaDB [mysql]> exit
Bye

root@www:~# apt-get install -t backports phpmyadmin
# выбрать ваш сервер (в примере - apache2)

+------------------------+ Configuring phpmyadmin +-------------------------+
| Please choose the web server that should be automatically configured to |
| run phpMyAdmin. |
| |
| Web server to reconfigure automatically: |
| |
| [*] apache2 |
| [ ] lighttpd |
| |
| |
| <Ok> |
| |
+---------------------------------------------------------------------------+

# Можно ответить [Yes] на вопрос о создании базы для phpmyadmin

+------------------------+ Configuring phpmyadmin +-------------------------+
| |
| The phpmyadmin package must have a database installed and configured |
| before it can be used. This can be optionally handled with |
| dbconfig-common. |
| |
| If you are an advanced database administrator and know that you want to |
| perform this configuration manually, or if your database has already |
| been installed and configured, you should refuse this option. Details |
| on what needs to be done should most likely be provided in |
| /usr/share/doc/phpmyadmin. |
| |
| Otherwise, you should probably choose this option. |
| |
| Configure database for phpmyadmin with dbconfig-common? |
| |
| <Yes> <No> |
| |
+---------------------------------------------------------------------------+

# и ввести пароль к базе

#

root@www:~# vi /etc/phpmyadmin/apache.conf
# add IP you allow to access

Require ip 127.0.0.1 10.0.0.0/24
root@www:~# systemctl restart apache2

#mcedit /etc/php/7.3/apache2/php.ini
open_basedir =/var/www:/usr/share/php

#cp -ar /usr/share/phpmyadmin/ /var/www/inc/usr/share/
#chown -R wwwuser:wwwgroup /var/www/inc/usr/share/phpmyadmin