MariaDB

Après installation

# mysql_secure_installation

Pour autoriser à se connecter via adminer

t# mysql
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 18
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)]> GRANT ALL PRIVILEGES ON *.* TO root@'localhost' IDENTIFIED BY 'mon_mot_de_passe';
Query OK, 0 rows affected (0.00 sec)

Voir la liste des users

mysql> select host,user from mysql.user;
+-----------+------------------+
| host      | user             |
+-----------+------------------+
| %         | toto             |
| 127.0.0.1 | root             |
| ::1       | root             |
| debian    | root             |
| localhost | api              |
| localhost | debian-sys-maint |
| localhost | root             |
+-----------+------------------+

Voir les privilèges

mysql> SELECT * FROM information_schema.user_privileges;
+--------------------------------+---------------+-------------------------+--------------+
| GRANTEE                        | TABLE_CATALOG | PRIVILEGE_TYPE          | IS_GRANTABLE |
+--------------------------------+---------------+-------------------------+--------------+
| 'root'@'localhost'             | def           | SELECT                  | YES          |
| 'root'@'localhost'             | def           | INSERT                  | YES          |
| 'root'@'localhost'             | def           | UPDATE                  | YES          |
| 'root'@'localhost'             | def           | DELETE                  | YES          |
| 'root'@'localhost'             | def           | CREATE                  | YES          |
| 'root'@'localhost'             | def           | DROP                    | YES          |
| 'root'@'localhost'             | def           | RELOAD                  | YES          |
| 'root'@'localhost'             | def           | SHUTDOWN                | YES          |
| 'root'@'localhost'             | def           | PROCESS                 | YES          |
...

mysql> show grants for 'root'@'localhost';
+----------------------------------------------------------------------------------------------------------------------------------------+
| Grants for root@localhost                                                                                                              |
+----------------------------------------------------------------------------------------------------------------------------------------+
| GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' IDENTIFIED BY PASSWORD '*XXXXXXXXXXXXXXXXXXXXxxx' WITH GRANT OPTION |
| GRANT PROXY ON ''@'' TO 'root'@'localhost' WITH GRANT OPTION                                                                           |
+----------------------------------------------------------------------------------------------------------------------------------------+