Différences

Ci-dessous, les différences entre deux révisions de la page.

--- mariadb_user [2023/07/05 16:51] – [Suppression d'un user] pascal
+++ mariadb_user [2023/07/05 19:13] (Version actuelle) – [Configuration] pascal
@@ Ligne 24: / Ligne 24: @@
 rows in set (0,002 sec)
 </code>
-===== Suppression d'un user =====
+===== Connexion d'un user =====
+==== 127.0.0.1 ====
 <code bash>
-MariaDB [(none)]> DROP USER foo@'10.%';
+root:~# mariadb -u foo -ppassword
-Query OK, 0 rows affected (0,002 sec)
+ERROR 1045 (28000): Access denied for user 'foo'@'localhost' (using password: YES)
 </code>
+==== 10.1.40.1 ====
 <code bash>
-MariaDB [(none)]> use mysql
+root:~# mariadb -u foo -ppassword -h 10.1.40.1
-Reading table information for completion of table and column names
+Welcome to the MariaDB monitor.  Commands end with ; or \g.
-You can turn off this feature to get a quicker startup with -A
+Your MariaDB connection id is 1350
+Server version: 10.11.3-MariaDB-1 Debian 12
-Database changed
+Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
-</code>
-<code bash>
+Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
-MariaDB [mysql]> select Host, User, Password from user;
-+-----------+-------------+----------+
-| Host      | User        | Password |
-+-----------+-------------+----------+
-| localhost | mariadb.sys |          |
-| localhost | root        | invalid  |
-| localhost | mysql       | invalid  |
-+-----------+-------------+----------+
-rows in set (0,002 sec)
 </code>
 ===== Suppression d'un user =====
@@ Ligne 69: / Ligne 63: @@
 +-----------+-------------+----------+
 rows in set (0,002 sec)
+</code>
+===== Configuration =====
+En parallèle, il faut que le serveur accepte les connections venant du réseau local.
+<code bash file=/etc/mysql/mariadb.conf.d/99-local.cnf>
+[mysqld]
+# Instead of skip-networking the default is now to listen only on
+# localhost which is more compatible and is not less secure.
+bind-address            = 10.1.40.1
 </code>
 ===== Sources =====
@@ Ligne 78: / Ligne 80: @@
 ===== Sujets connexes =====
   * [[mariadb|Installation de mariaDB]]
+  * [[mariadb_grant|Gestion des autorisations]]