{"id":139,"date":"2023-11-28T18:47:19","date_gmt":"2023-11-28T17:47:19","guid":{"rendered":"https:\/\/artheodoc.fr\/?page_id=139"},"modified":"2023-11-29T18:40:34","modified_gmt":"2023-11-29T17:40:34","slug":"syntaxe-des-commandes-pour-mariadb","status":"publish","type":"page","link":"https:\/\/artheodoc.fr\/index.php\/syntaxe-des-commandes-pour-mariadb\/","title":{"rendered":"Syntaxe des commandes pour MariaDB"},"content":{"rendered":"\n<p><em>Remplacez base, utilisateur, PASSWORD, par le nom de votre base de donn\u00e9es, le nom de votre utilisateur et votre mot de passe.<\/em><\/p>\n\n\n\n<p>Pour se connecter \u00e0 MariaDB en administrateur.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\"><strong>mysql -u root -p<\/strong><\/pre>\n\n\n\n<p><em>Le mot de passe est d\u00e9fini lors de la <a href=\"https:\/\/artheodoc.fr\/index.php\/securisation-de-linstallation-de-mariadb\/\" data-type=\"page\" data-id=\"66\" target=\"_blank\" rel=\"noreferrer noopener\">proc\u00e9dure de s\u00e9curisation de MariaDB<\/a>. Si vous n\u2019avez pas effectu\u00e9 cette proc\u00e9dure et d\u00e9fini le mot de passe, laissez vide.<\/em><\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity is-style-wide\"\/>\n\n\n\n<p class=\"has-large-font-size\">Exemple pour la cr\u00e9ation de la base de donn\u00e9es pour Piwigo.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">Pour cr\u00e9e la base de donn\u00e9es base:\nMariaDB [(none)]&gt; <strong>CREATE DATABASE base CHARACTER SET UTF8;<\/strong>\nQuery OK, 1 row affected (0.00 sec)\nCr\u00e9er l\u2019utilisateur utilisateur pour localhost avec le mot de passe PASSWORD :\nMariaDB [(none)]&gt; <strong>CREATE USER 'utilisateur'@'localhost' IDENTIFIED BY 'PASSWORD';<\/strong>\nQuery OK, 0 ROWS affected (0.00 sec)\nPour attribuer tous les droits \u00e0 un utilisateur sur la base de donn\u00e9es, il doit \u00eatre cr\u00e9\u00e9 avant :\nMariaDB [(none)]&gt; <strong>GRANT ALL ON base.* TO 'utilisateur'@'localhost';<\/strong>\nQuery OK, 0 ROWS affected (0.00 sec)\nMaintenant, pour que les nouveaux droits attribu\u00e9s soient pris en compte, il est n\u00e9cessaire de lancer la requ\u00eate FLUSH :\nMariaDB [(none)]&gt; <strong>FLUSH PRIVILEGES;<\/strong>\nQuery OK, 0 ROWS affected (0.00 sec)\nPour quitter MariaDB :\n<strong>exit;<\/strong><\/pre>\n\n\n\n<p class=\"has-medium-font-size\">Exemple pour supprimer les IP enregistr\u00e9es dans le cadre d&rsquo;un soup\u00e7on d&rsquo;attaque par force brute pour Nextcloud.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">Pour se connecter en administrateur :\n<strong>mysql -u root -p<\/strong>\nOuvrir la base de donn\u00e9es Nextcloud :\n<strong>USE clouddbmv;<\/strong>\nEnsuite, pour afficher tous les tables :\n<strong>SHOW TABLES;<\/strong>\nPour afficher toutes les valeurs de la table oc_bruteforce_attempts :\n<strong>SELECT * FROM oc_bruteforce_attempts;<\/strong>\nPour supprimer une adresse IP de la table, utilisez :\n<strong>DELETE FROM oc_bruteforce_attempts WHERE IP=\"xxx.xxx.xxx.xxx\";<\/strong>\n<strong>EXIT;<\/strong>\n<\/pre>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity is-style-wide\"\/>\n\n\n\n<p class=\"has-large-font-size\">Utilisateurs<\/p>\n\n\n\n<p>Exemples pour voir les utilisateurs cr\u00e9\u00e9s&nbsp;:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\"><strong>SELECT user FROM mysql.user;<\/strong><\/pre>\n\n\n\n<pre class=\"wp-block-preformatted\"><strong>SELECT user,host FROM mysql.user;<\/strong><\/pre>\n\n\n\n<pre class=\"wp-block-preformatted\"><strong>SELECT user,host,password FROM mysql.user;<\/strong><\/pre>\n\n\n\n<p>Pour un utilisateur donn\u00e9, on peut voir ses droits de la fa\u00e7on suivante&nbsp;:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\"><strong>SHOW GRANTS FOR \"utilisateur\"@\"localhost\";<\/strong><\/pre>\n\n\n\n<p>Pour supprimer les droits d\u2019un utilisateur avec REVOKE&nbsp;:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\"><strong>REVOKE ALL ON *.* FROM 'utilisateur'@'localhost';<\/strong><\/pre>\n\n\n\n<p>Pour supprimer un utilisateur&nbsp;:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\"><strong>DROP USER 'utilisateur'@'localhost';<\/strong><\/pre>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity is-style-wide\"\/>\n\n\n\n<p class=\"has-large-font-size\">Base de donn\u00e9es<\/p>\n\n\n\n<p>Pour lister les bases de donn\u00e9es&nbsp;:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\"><strong>show databases;<\/strong><\/pre>\n\n\n\n<p>Pour supprimer une base de donn\u00e9es&nbsp;:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\"><strong>DROP DATABASE base;<\/strong><\/pre>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity is-style-wide\"\/>\n\n\n\n<p class=\"has-large-font-size\">Les droits<\/p>\n\n\n\n<p>Pour supprimer les droits d\u2019un utilisateur sur une base de donn\u00e9es avec REVOKE&nbsp;:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\"><strong>REVOKE ALL ON base.* FROM 'utilisateur'@'localhost';<\/strong><\/pre>\n\n\n\n<p>La commande GRANT permet d\u2019attribuer des droits sur la base de donn\u00e9es&nbsp;:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\"><strong>GRANT CREATE, SELECT, INSERT, UPDATE, DELETE, DROP, LOCK TABLES ON base.* TO 'utilisateur'@'localhost';<\/strong><\/pre>\n\n\n\n<p>Pour que les nouveaux droits attribu\u00e9s soient pris en compte, il est n\u00e9cessaire de lancer la requ\u00eate FLUSH comme vu pr\u00e9c\u00e9demment&nbsp;:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\"><strong>FLUSH PRIVILEGES;<\/strong><\/pre>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity is-style-wide\"\/>\n\n\n\n<p class=\"has-large-font-size\">Plus d\u2019informations<\/p>\n\n\n\n<p><a href=\"https:\/\/artheodoc.fr\/index.php\/securisation-de-linstallation-de-mariadb\/\" data-type=\"page\" data-id=\"66\" target=\"_blank\" rel=\"noreferrer noopener\">S\u00e9curisation de l&rsquo;installation de MariaDB<\/a><\/p>\n\n\n\n<p><a href=\"https:\/\/www.linuxtricks.fr\/wiki\/mysql-mariadb-memo-des-commandes-sql\" target=\"_blank\" rel=\"noreferrer noopener\">https:\/\/www.linuxtricks.fr\/wiki\/mysql-mariadb-memo-des-commandes-sql<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Remplacez base, utilisateur, PASSWORD, par le nom de votre base de donn\u00e9es, le nom de votre utilisateur et votre mot de passe. Pour se connecter \u00e0 MariaDB en administrateur. mysql -u root -p Le mot de passe est d\u00e9fini lors de la proc\u00e9dure de s\u00e9curisation de MariaDB. Si vous n\u2019avez pas effectu\u00e9 cette proc\u00e9dure et [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"class_list":["post-139","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/artheodoc.fr\/index.php\/wp-json\/wp\/v2\/pages\/139","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/artheodoc.fr\/index.php\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/artheodoc.fr\/index.php\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/artheodoc.fr\/index.php\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/artheodoc.fr\/index.php\/wp-json\/wp\/v2\/comments?post=139"}],"version-history":[{"count":6,"href":"https:\/\/artheodoc.fr\/index.php\/wp-json\/wp\/v2\/pages\/139\/revisions"}],"predecessor-version":[{"id":153,"href":"https:\/\/artheodoc.fr\/index.php\/wp-json\/wp\/v2\/pages\/139\/revisions\/153"}],"wp:attachment":[{"href":"https:\/\/artheodoc.fr\/index.php\/wp-json\/wp\/v2\/media?parent=139"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}