После установки phpmyadmin на raspberry pi3 не пускает под root

После установки phpmyadmin на малинку возник неприятный глюк.

Не удается войти под root в консоль phpmyadmin

Ответ был найден 🙂

Установка шла по этому сценарию

sudo bash
apt-get install phpmyadmin

We need to alter the Apache configuration in order to access PhpMyAdmin. To do this, enter the following command to alter the configuration:

nano /etc/apache2/apache2.conf

The configuration file will load in Nano. Navigate to the bottom of the file (keep pressing CTRL + V to jump page by page until you’re at the bottom of the file) and add the following new line to the file:

Include /etc/phpmyadmin/apache.conf

Save the file (CTRL + X and enter Y when prompted to save) and restart Apache2. To restart Apache, enter the following command:

/etc/init.d/apache2 restart

Но выдавал ошибку авторизации

Нашел вот такой совет

# change some settings to enable login to phpMyAdmin with root


mysql -u root -p mysql


Enter password:
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 11
Server version: 10.1.23-MariaDB-9+deb9u1 Debian 9.0

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 


vi /etc/phpmyadmin/apache.conf
# line 8: add IP you allow to access
Require ip


systemctl restart apache2

Добавить комментарий