Installation MSQL & PHPMYADMIN

apt install mysql-server
mysql -p

apt -y install phpmyadmin php-mbstring php-gettext




# select which one you using (this example selects apache2)

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

# answer [No] to proceed on this example

+------------------------+ 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> |
| |
+---------------------------------------------------------------------------+

# change some settings to enable login to phpMyAdmin with root

root@www:~# 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 © 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:~# nano /etc/phpmyadmin/apache.conf

# line 8: add IP you allow to access

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

Créé utilisateur admin

mysql

CREATE USER 'NOM UTILISATEUR'@'localhost' IDENTIFIED BY 'MOT DE PASSE';

FLUSH PRIVILEGES;