Gestion des utilisateurs mariaDB

Création

MariaDB [(none)]> CREATE USER foo@10.% IDENTIFIED BY 'password';
Query OK, 0 rows affected (0,003 sec)

MariaDB [mysql]> select Host, User, Password from user;
+-----------+-------------+-------------------------------------------+
| Host      | User        | Password                                  |
+-----------+-------------+-------------------------------------------+
| localhost | mariadb.sys |                                           |
| localhost | root        | invalid                                   |
| localhost | mysql       | invalid                                   |
| 10.%      | foo         | *2470C0C02FEE4B9D15ADC618B6DD1900A2EC9E19 |
+-----------+-------------+-------------------------------------------+
6 rows in set (0,002 sec)

Suppression

MariaDB [(none)]> DROP USER foo@'10.%';
Query OK, 0 rows affected (0,003 sec)

MariaDB [mysql]> select Host, User, Password from user;
+-----------+-------------+-------------------------------------------+
| Host      | User        | Password                                  |
+-----------+-------------+-------------------------------------------+
| localhost | mariadb.sys |                                           |
| localhost | root        | invalid                                   |
| localhost | mysql       | invalid                                   |
+-----------+-------------+-------------------------------------------+
3 rows in set (0,002 sec)

Sources

* Site mariaDB

Sujets connexes

Installation de mariaDB