{"id":322,"date":"2026-03-03T20:31:00","date_gmt":"2026-03-03T19:31:00","guid":{"rendered":"https:\/\/eryann.fr\/?p=322"},"modified":"2026-05-04T10:58:54","modified_gmt":"2026-05-04T08:58:54","slug":"fiche-mysql-mariadb-bases-utilisateurs-droits-et-sauvegardes","status":"publish","type":"post","link":"https:\/\/eryann.fr\/index.php\/linux\/fiche-mysql-mariadb-bases-utilisateurs-droits-et-sauvegardes\/","title":{"rendered":"Fiche mysql \/ mariadb : bases, utilisateurs, droits et sauvegardes"},"content":{"rendered":"\n<p><audio autoplay=\"\"><\/audio><\/p>\n\n\n\n<p><strong>Cat\u00e9gorie :<\/strong> bases de donn\u00e9es<br><strong>\u00c9tiquettes :<\/strong> mysql, mariadb<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">1. Introduction<\/h2>\n\n\n\n<p>Dans un environnement BTS CIEL ou SIO, tu vas tr\u00e8s souvent d\u00e9ployer des applications qui reposent sur une base de donn\u00e9es (WordPress, GLPI, outils internes, etc.).<br>MariaDB et MySQL sont des SGBD (Syst\u00e8mes de Gestion de Base de Donn\u00e9es) largement utilis\u00e9s sous Linux.<\/p>\n\n\n\n<p>Dans cette fiche, tu vas apprendre \u00e0 :<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>cr\u00e9er une base de donn\u00e9es<\/li>\n\n\n\n<li>cr\u00e9er un utilisateur d\u00e9di\u00e9<\/li>\n\n\n\n<li>g\u00e9rer les droits (principe du moindre privil\u00e8ge)<\/li>\n\n\n\n<li>s\u00e9curiser l\u2019acc\u00e8s root<\/li>\n\n\n\n<li>comprendre les mots de passe (hachage, chiffrement)<\/li>\n\n\n\n<li>sauvegarder et automatiser les sauvegardes<\/li>\n<\/ul>\n\n\n\n<p>Tu vas construire une configuration propre et s\u00e9curis\u00e9e, comme en production.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">2. Sommaire<\/h2>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Installation de MariaDB<\/li>\n\n\n\n<li>Synth\u00e8se rapide<\/li>\n\n\n\n<li>Fichiers importants<\/li>\n\n\n\n<li>Configuration compl\u00e8te<\/li>\n\n\n\n<li>Gestion des bases et utilisateurs<\/li>\n\n\n\n<li>S\u00e9curit\u00e9 des mots de passe<\/li>\n\n\n\n<li>Sauvegardes et automatisation<\/li>\n\n\n\n<li>Commandes utiles et d\u00e9pannage<\/li>\n\n\n\n<li>Logs et analyse<\/li>\n\n\n\n<li>Bonnes pratiques<\/li>\n\n\n\n<li>Pour aller plus loin<\/li>\n\n\n\n<li>Liens utiles<\/li>\n\n\n\n<li>TP pratiques<\/li>\n<\/ol>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">3. Synth\u00e8se Markdown pour ta fiche bristol<\/h2>\n\n\n\n<pre class=\"wp-block-code\"><code># MariaDB - Fiche rapide<br><br>## Installation<br>apt install mariadb-server<br><br>## S\u00e9curisation<br>mysql_secure_installation<br><br>## Connexion<br>mysql -u root -p<br><br>## Cr\u00e9er une base<br>CREATE DATABASE db_app;<br><br>## Cr\u00e9er utilisateur<br>CREATE USER 'appuser'@'localhost' IDENTIFIED BY 'MotDePasseFort!';<br><br>## Donner droits<br>GRANT SELECT, INSERT, UPDATE, DELETE ON db_app.* TO 'appuser'@'localhost';<br><br>## Appliquer<br>FLUSH PRIVILEGES;<br><br>## Sauvegarde<br>mysqldump -u root -p db_app &gt; backup.sql<br><br>## Restauration<br>mysql -u root -p db_app &lt; backup.sql<br><br>## Automatisation<br>crontab -e<br>0 2 * * * mysqldump -u root -p'MDP' db_app &gt; \/backup\/db.sql<\/code><\/pre>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">4. Fichiers importants<\/h2>\n\n\n\n<p>Voici les principaux fichiers utilis\u00e9s :<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>\/etc\/mysql\/<br>\u251c\u2500\u2500 my.cnf<br>\u251c\u2500\u2500 mariadb.conf.d\/<br>\u2502   \u251c\u2500\u2500 50-server.cnf<br>\u2502   \u2514\u2500\u2500 60-galera.cnf<br>\/var\/lib\/mysql\/           # donn\u00e9es des bases<br>\/var\/log\/mysql\/error.log  # logs<br>\/etc\/cron.d\/              # t\u00e2ches planifi\u00e9es<\/code><\/pre>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">5. Configuration compl\u00e8te<\/h2>\n\n\n\n<pre class=\"wp-block-code\"><code># Installation<br>sudo apt update<br>sudo apt install mariadb-server<br><br># D\u00e9marrage et activation<br>sudo systemctl enable mariadb<br>sudo systemctl start mariadb<br><br># S\u00e9curisation initiale<br>sudo mysql_secure_installation<br><br># Connexion<br>mysql -u root -p<br><br># Cr\u00e9ation base<br>CREATE DATABASE db_app CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;<br><br># Cr\u00e9ation utilisateur<br>CREATE USER 'appuser'@'localhost' IDENTIFIED BY 'MotDePasseFort!';<br><br># Attribution droits minimum<br>GRANT SELECT, INSERT, UPDATE, DELETE ON db_app.* TO 'appuser'@'localhost';<br><br># Application<br>FLUSH PRIVILEGES;<br><br># Sauvegarde<br>mysqldump -u root -p db_app &gt; \/backup\/db_app.sql<br><br># Cron (\u00e9dition)<br>crontab -e<br><br># Exemple t\u00e2che quotidienne<br>0 2 * * * mysqldump -u root -p'MDP' db_app &gt; \/backup\/db_app_$(date +\\%F).sql<\/code><\/pre>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">6. Gestion des bases et utilisateurs<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">Cr\u00e9er une base<\/h3>\n\n\n\n<pre class=\"wp-block-code\"><code>CREATE DATABASE db_app;<\/code><\/pre>\n\n\n\n<p>Pourquoi ?<br>Tu isoles les donn\u00e9es d\u2019une application.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h3 class=\"wp-block-heading\">Cr\u00e9er un utilisateur<\/h3>\n\n\n\n<pre class=\"wp-block-code\"><code>CREATE USER 'appuser'@'localhost' IDENTIFIED BY 'MotDePasseFort!';<\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\">\n<li><code>localhost<\/code> \u2192 acc\u00e8s uniquement local (s\u00e9curis\u00e9)<\/li>\n\n\n\n<li><code>'%'<\/code> \u2192 acc\u00e8s distant (\u00e0 \u00e9viter sans firewall)<\/li>\n<\/ul>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h3 class=\"wp-block-heading\">Donner des droits<\/h3>\n\n\n\n<pre class=\"wp-block-code\"><code>GRANT SELECT, INSERT, UPDATE, DELETE ON db_app.* TO 'appuser'@'localhost';<\/code><\/pre>\n\n\n\n<p>Tu appliques ici le principe du moindre privil\u00e8ge :<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>SELECT \u2192 lecture<\/li>\n\n\n\n<li>INSERT \u2192 ajout<\/li>\n\n\n\n<li>UPDATE \u2192 modification<\/li>\n\n\n\n<li>DELETE \u2192 suppression<\/li>\n<\/ul>\n\n\n\n<p>\u00c9vite absolument :<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>GRANT ALL PRIVILEGES ON *.* TO 'user';<\/code><\/pre>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h3 class=\"wp-block-heading\">Modifier un utilisateur<\/h3>\n\n\n\n<pre class=\"wp-block-code\"><code>ALTER USER 'appuser'@'localhost' IDENTIFIED BY 'NouveauMDP!';<\/code><\/pre>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h3 class=\"wp-block-heading\">Supprimer un utilisateur<\/h3>\n\n\n\n<pre class=\"wp-block-code\"><code>DROP USER 'appuser'@'localhost';<\/code><\/pre>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">7. S\u00e9curit\u00e9 des mots de passe<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">Important : MySQL ne chiffre pas, il <strong>hash<\/strong><\/h3>\n\n\n\n<p>Quand tu fais :<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>CREATE USER 'user' IDENTIFIED BY 'password';<\/code><\/pre>\n\n\n\n<p>Le mot de passe est :<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>hach\u00e9 automatiquement<\/strong> (plugin <code>mysql_native_password<\/code> ou <code>caching_sha2_password<\/code>)<\/li>\n\n\n\n<li>stock\u00e9 dans la table <code>mysql.user<\/code><\/li>\n<\/ul>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h3 class=\"wp-block-heading\">V\u00e9rifier le type d\u2019authentification<\/h3>\n\n\n\n<pre class=\"wp-block-code\"><code>SELECT user, host, plugin FROM mysql.user;<\/code><\/pre>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h3 class=\"wp-block-heading\">Diff\u00e9rence cl\u00e9<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Chiffrement \u2192 r\u00e9versible<\/li>\n\n\n\n<li>Hachage \u2192 NON r\u00e9versible (s\u00e9curit\u00e9)<\/li>\n<\/ul>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h3 class=\"wp-block-heading\">Forcer un mot de passe fort<\/h3>\n\n\n\n<p>Dans <code>\/etc\/mysql\/mariadb.conf.d\/50-server.cnf<\/code> :<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>&#91;mysqld]<br>plugin-load-add=simple_password_check<\/code><\/pre>\n\n\n\n<p>Ou installer :<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>sudo apt install libpam-pwquality<\/code><\/pre>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h3 class=\"wp-block-heading\">Bon mot de passe<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>12+ caract\u00e8res<\/li>\n\n\n\n<li>majuscule + minuscule<\/li>\n\n\n\n<li>chiffres + symboles<\/li>\n\n\n\n<li>pas de dictionnaire<\/li>\n<\/ul>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">8. Sauvegardes et automatisation<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">Sauvegarde manuelle<\/h3>\n\n\n\n<pre class=\"wp-block-code\"><code>mysqldump -u root -p db_app &gt; backup.sql<\/code><\/pre>\n\n\n\n<p>Options :<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><code>-u<\/code> \u2192 utilisateur<\/li>\n\n\n\n<li><code>-p<\/code> \u2192 mot de passe<\/li>\n\n\n\n<li><code>--all-databases<\/code> \u2192 toutes les bases<\/li>\n<\/ul>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h3 class=\"wp-block-heading\">Sauvegarde compl\u00e8te<\/h3>\n\n\n\n<pre class=\"wp-block-code\"><code>mysqldump -u root -p --all-databases &gt; full_backup.sql<\/code><\/pre>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h3 class=\"wp-block-heading\">Automatisation avec cron<\/h3>\n\n\n\n<pre class=\"wp-block-code\"><code>crontab -e<\/code><\/pre>\n\n\n\n<p>Exemple :<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>0 2 * * * mysqldump -u root -p'MDP' db_app &gt; \/backup\/db_app.sql<\/code><\/pre>\n\n\n\n<p>Explication :<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><code>0 2 * * *<\/code> \u2192 tous les jours \u00e0 2h<\/li>\n\n\n\n<li>redirection <code>><\/code> \u2192 fichier<\/li>\n<\/ul>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h3 class=\"wp-block-heading\">S\u00e9curisation des sauvegardes<\/h3>\n\n\n\n<pre class=\"wp-block-code\"><code>chmod 600 \/backup\/*<\/code><\/pre>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">9. Commandes utiles et d\u00e9pannage<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">V\u00e9rifier service<\/h3>\n\n\n\n<pre class=\"wp-block-code\"><code>systemctl status mariadb<\/code><\/pre>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h3 class=\"wp-block-heading\">Se connecter sans mot de passe root (Unix socket)<\/h3>\n\n\n\n<pre class=\"wp-block-code\"><code>sudo mysql<\/code><\/pre>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h3 class=\"wp-block-heading\">Lister bases<\/h3>\n\n\n\n<pre class=\"wp-block-code\"><code>SHOW DATABASES;<\/code><\/pre>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h3 class=\"wp-block-heading\">Voir les droits<\/h3>\n\n\n\n<pre class=\"wp-block-code\"><code>SHOW GRANTS FOR 'appuser'@'localhost';<\/code><\/pre>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h3 class=\"wp-block-heading\">Port utilis\u00e9<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>3306 (par d\u00e9faut)<\/li>\n<\/ul>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h3 class=\"wp-block-heading\">Firewall UFW<\/h3>\n\n\n\n<h4 class=\"wp-block-heading\">Acc\u00e8s local uniquement<\/h4>\n\n\n\n<pre class=\"wp-block-code\"><code>sudo ufw deny 3306<\/code><\/pre>\n\n\n\n<h4 class=\"wp-block-heading\">Acc\u00e8s depuis serveur web<\/h4>\n\n\n\n<pre class=\"wp-block-code\"><code>sudo ufw allow from 192.168.1.10 to any port 3306<\/code><\/pre>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">10. Logs et analyse<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">Fichier principal<\/h3>\n\n\n\n<pre class=\"wp-block-code\"><code>\/var\/log\/mysql\/error.log<\/code><\/pre>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h3 class=\"wp-block-heading\">Activer logs de requ\u00eates<\/h3>\n\n\n\n<p>Dans <code>\/etc\/mysql\/mariadb.conf.d\/50-server.cnf<\/code> :<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>general_log = 1<br>general_log_file = \/var\/log\/mysql\/general.log<\/code><\/pre>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h3 class=\"wp-block-heading\">Ce que tu peux voir<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>connexions utilisateurs<\/li>\n\n\n\n<li>requ\u00eates SQL<\/li>\n\n\n\n<li>erreurs<\/li>\n\n\n\n<li>tentatives d\u2019acc\u00e8s<\/li>\n<\/ul>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h3 class=\"wp-block-heading\">Exemple d\u2019analyse<\/h3>\n\n\n\n<pre class=\"wp-block-code\"><code>tail -f \/var\/log\/mysql\/error.log<\/code><\/pre>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">11. Bonnes pratiques<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>toujours cr\u00e9er un utilisateur par application<\/li>\n\n\n\n<li>ne jamais utiliser root en production<\/li>\n\n\n\n<li>limiter les droits<\/li>\n\n\n\n<li>sauvegarder r\u00e9guli\u00e8rement<\/li>\n\n\n\n<li>s\u00e9curiser avec firewall<\/li>\n\n\n\n<li>activer les logs<\/li>\n\n\n\n<li>stocker les mots de passe dans un gestionnaire (ex : vault)<\/li>\n<\/ul>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">12. Pour aller plus loin<\/h2>\n\n\n\n<p>Tu peux approfondir avec :<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>r\u00e9plication MariaDB<\/li>\n\n\n\n<li>clustering (Galera)<\/li>\n\n\n\n<li>chiffrement TLS MySQL<\/li>\n\n\n\n<li>audit logs avanc\u00e9s<\/li>\n<\/ul>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">13. Liens vers des ressources<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">Documentation officielle<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/mariadb.com\/kb\/en\/mysql_secure_installation\/\">https:\/\/mariadb.com\/kb\/en\/mysql_secure_installation\/<\/a><br>\u2192 S\u00e9curisation initiale<\/li>\n\n\n\n<li><a>https:\/\/dev.mysql.com\/doc\/refman\/8.0\/en\/user-account-management.html<\/a><br>\u2192 Gestion utilisateurs<\/li>\n\n\n\n<li><a>https:\/\/manpages.debian.org\/mysqldump<\/a><br>\u2192 Sauvegardes<\/li>\n<\/ul>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h3 class=\"wp-block-heading\">OpenClassrooms<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><a>https:\/\/openclassrooms.com\/fr\/courses\/6175841-administrez-une-base-de-donnees-avec-mysql<\/a><br>\u2192 Cours complet MySQL<\/li>\n\n\n\n<li><a>https:\/\/openclassrooms.com\/fr\/courses\/235344-apprenez-a-programmer-en-sql<\/a><br>\u2192 SQL d\u00e9butant<\/li>\n<\/ul>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">14. Propositions de TP<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">TP 1 : Installation<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>installer MariaDB<\/li>\n\n\n\n<li>s\u00e9curiser root<\/li>\n\n\n\n<li>v\u00e9rifier port 3306<\/li>\n<\/ul>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h3 class=\"wp-block-heading\">TP 2 : Gestion utilisateurs<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>cr\u00e9er 2 utilisateurs :\n<ul class=\"wp-block-list\">\n<li>admin<\/li>\n\n\n\n<li>applicatif<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>tester les droits<\/li>\n<\/ul>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h3 class=\"wp-block-heading\">TP 3 : S\u00e9curit\u00e9<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>bloquer acc\u00e8s externe avec UFW<\/li>\n\n\n\n<li>tester connexion distante<\/li>\n<\/ul>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h3 class=\"wp-block-heading\">TP 4 : Sauvegarde<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>cr\u00e9er script backup.sh<\/li>\n\n\n\n<li>automatiser avec cron<\/li>\n\n\n\n<li>restaurer une base<\/li>\n<\/ul>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h3 class=\"wp-block-heading\">TP 5 : Audit<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>activer logs<\/li>\n\n\n\n<li>analyser connexions<\/li>\n\n\n\n<li>d\u00e9tecter tentative d\u2019acc\u00e8s non autoris\u00e9e<\/li>\n<\/ul>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p>Cette fiche te donne une base solide pour travailler en conditions r\u00e9elles sur MariaDB\/MySQL avec une approche s\u00e9curit\u00e9 d\u00e8s le d\u00e9part.<audio autoplay=\"\"><\/audio><\/p>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Cat\u00e9gorie : bases de donn\u00e9es\u00c9tiquettes : mysql, mariadb 1. Introduction Dans un environnement BTS CIEL ou SIO, tu vas tr\u00e8s souvent d\u00e9ployer des applications qui reposent sur une base de donn\u00e9es (WordPress, GLPI, outils internes, etc.).MariaDB et MySQL sont des SGBD (Syst\u00e8mes de Gestion de Base de Donn\u00e9es) largement utilis\u00e9s sous Linux. Dans cette fiche, [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","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-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":"","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-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":"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":""},"mobile":{"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":""}},"footnotes":""},"categories":[12,5],"tags":[],"class_list":["post-322","post","type-post","status-publish","format-standard","hentry","category-linux","category-systeme"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.6 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Fiche mysql \/ mariadb : bases, utilisateurs, droits et sauvegardes - Eryann Breizh SecOps<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/eryann.fr\/index.php\/linux\/fiche-mysql-mariadb-bases-utilisateurs-droits-et-sauvegardes\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fiche mysql \/ mariadb : bases, utilisateurs, droits et sauvegardes - Eryann Breizh SecOps\" \/>\n<meta property=\"og:description\" content=\"Cat\u00e9gorie : bases de donn\u00e9es\u00c9tiquettes : mysql, mariadb 1. Introduction Dans un environnement BTS CIEL ou SIO, tu vas tr\u00e8s souvent d\u00e9ployer des applications qui reposent sur une base de donn\u00e9es (WordPress, GLPI, outils internes, etc.).MariaDB et MySQL sont des SGBD (Syst\u00e8mes de Gestion de Base de Donn\u00e9es) largement utilis\u00e9s sous Linux. Dans cette fiche, [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/eryann.fr\/index.php\/linux\/fiche-mysql-mariadb-bases-utilisateurs-droits-et-sauvegardes\/\" \/>\n<meta property=\"og:site_name\" content=\"Eryann Breizh SecOps\" \/>\n<meta property=\"article:published_time\" content=\"2026-03-03T19:31:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2026-05-04T08:58:54+00:00\" \/>\n<meta name=\"author\" content=\"wpadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u00c9crit par\" \/>\n\t<meta name=\"twitter:data1\" content=\"wpadmin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Dur\u00e9e de lecture estim\u00e9e\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/eryann.fr\\\/index.php\\\/linux\\\/fiche-mysql-mariadb-bases-utilisateurs-droits-et-sauvegardes\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/eryann.fr\\\/index.php\\\/linux\\\/fiche-mysql-mariadb-bases-utilisateurs-droits-et-sauvegardes\\\/\"},\"author\":{\"name\":\"wpadmin\",\"@id\":\"https:\\\/\\\/eryann.fr\\\/#\\\/schema\\\/person\\\/d2ee98d2385cd045ed4fe1c07ca320b5\"},\"headline\":\"Fiche mysql \\\/ mariadb : bases, utilisateurs, droits et sauvegardes\",\"datePublished\":\"2026-03-03T19:31:00+00:00\",\"dateModified\":\"2026-05-04T08:58:54+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/eryann.fr\\\/index.php\\\/linux\\\/fiche-mysql-mariadb-bases-utilisateurs-droits-et-sauvegardes\\\/\"},\"wordCount\":619,\"publisher\":{\"@id\":\"https:\\\/\\\/eryann.fr\\\/#organization\"},\"articleSection\":[\"Linux\",\"Syst\u00e8me\"],\"inLanguage\":\"fr-FR\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/eryann.fr\\\/index.php\\\/linux\\\/fiche-mysql-mariadb-bases-utilisateurs-droits-et-sauvegardes\\\/\",\"url\":\"https:\\\/\\\/eryann.fr\\\/index.php\\\/linux\\\/fiche-mysql-mariadb-bases-utilisateurs-droits-et-sauvegardes\\\/\",\"name\":\"Fiche mysql \\\/ mariadb : bases, utilisateurs, droits et sauvegardes - Eryann Breizh SecOps\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/eryann.fr\\\/#website\"},\"datePublished\":\"2026-03-03T19:31:00+00:00\",\"dateModified\":\"2026-05-04T08:58:54+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/eryann.fr\\\/index.php\\\/linux\\\/fiche-mysql-mariadb-bases-utilisateurs-droits-et-sauvegardes\\\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/eryann.fr\\\/index.php\\\/linux\\\/fiche-mysql-mariadb-bases-utilisateurs-droits-et-sauvegardes\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/eryann.fr\\\/index.php\\\/linux\\\/fiche-mysql-mariadb-bases-utilisateurs-droits-et-sauvegardes\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\\\/\\\/eryann.fr\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Fiche mysql \\\/ mariadb : bases, utilisateurs, droits et sauvegardes\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/eryann.fr\\\/#website\",\"url\":\"https:\\\/\\\/eryann.fr\\\/\",\"name\":\"Eryann Breizh SecOps\",\"description\":\"Fiches techniques &amp; labs en syst\u00e8mes et r\u00e9seaux poor les \u00e9tudiants en BTS CEIL ET SIO\",\"publisher\":{\"@id\":\"https:\\\/\\\/eryann.fr\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/eryann.fr\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"fr-FR\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/eryann.fr\\\/#organization\",\"name\":\"Breizh Sec Ops\",\"url\":\"https:\\\/\\\/eryann.fr\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\\\/\\\/eryann.fr\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/eryann.fr\\\/wp-content\\\/uploads\\\/2026\\\/05\\\/cropped-088112b9-fd28-4b18-b02d-4d9dded3e900-e1777846396685.png\",\"contentUrl\":\"https:\\\/\\\/eryann.fr\\\/wp-content\\\/uploads\\\/2026\\\/05\\\/cropped-088112b9-fd28-4b18-b02d-4d9dded3e900-e1777846396685.png\",\"width\":1246,\"height\":229,\"caption\":\"Breizh Sec Ops\"},\"image\":{\"@id\":\"https:\\\/\\\/eryann.fr\\\/#\\\/schema\\\/logo\\\/image\\\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/eryann.fr\\\/#\\\/schema\\\/person\\\/d2ee98d2385cd045ed4fe1c07ca320b5\",\"name\":\"wpadmin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/d71b4031c3d015de3ca68c137413277e548b331b07db0acf781b9379b798eb3e?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/d71b4031c3d015de3ca68c137413277e548b331b07db0acf781b9379b798eb3e?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/d71b4031c3d015de3ca68c137413277e548b331b07db0acf781b9379b798eb3e?s=96&d=mm&r=g\",\"caption\":\"wpadmin\"},\"sameAs\":[\"https:\\\/\\\/eryann.fr\"],\"url\":\"https:\\\/\\\/eryann.fr\\\/index.php\\\/author\\\/wpadmin\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Fiche mysql \/ mariadb : bases, utilisateurs, droits et sauvegardes - Eryann Breizh SecOps","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/eryann.fr\/index.php\/linux\/fiche-mysql-mariadb-bases-utilisateurs-droits-et-sauvegardes\/","og_locale":"fr_FR","og_type":"article","og_title":"Fiche mysql \/ mariadb : bases, utilisateurs, droits et sauvegardes - Eryann Breizh SecOps","og_description":"Cat\u00e9gorie : bases de donn\u00e9es\u00c9tiquettes : mysql, mariadb 1. Introduction Dans un environnement BTS CIEL ou SIO, tu vas tr\u00e8s souvent d\u00e9ployer des applications qui reposent sur une base de donn\u00e9es (WordPress, GLPI, outils internes, etc.).MariaDB et MySQL sont des SGBD (Syst\u00e8mes de Gestion de Base de Donn\u00e9es) largement utilis\u00e9s sous Linux. Dans cette fiche, [&hellip;]","og_url":"https:\/\/eryann.fr\/index.php\/linux\/fiche-mysql-mariadb-bases-utilisateurs-droits-et-sauvegardes\/","og_site_name":"Eryann Breizh SecOps","article_published_time":"2026-03-03T19:31:00+00:00","article_modified_time":"2026-05-04T08:58:54+00:00","author":"wpadmin","twitter_card":"summary_large_image","twitter_misc":{"\u00c9crit par":"wpadmin","Dur\u00e9e de lecture estim\u00e9e":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/eryann.fr\/index.php\/linux\/fiche-mysql-mariadb-bases-utilisateurs-droits-et-sauvegardes\/#article","isPartOf":{"@id":"https:\/\/eryann.fr\/index.php\/linux\/fiche-mysql-mariadb-bases-utilisateurs-droits-et-sauvegardes\/"},"author":{"name":"wpadmin","@id":"https:\/\/eryann.fr\/#\/schema\/person\/d2ee98d2385cd045ed4fe1c07ca320b5"},"headline":"Fiche mysql \/ mariadb : bases, utilisateurs, droits et sauvegardes","datePublished":"2026-03-03T19:31:00+00:00","dateModified":"2026-05-04T08:58:54+00:00","mainEntityOfPage":{"@id":"https:\/\/eryann.fr\/index.php\/linux\/fiche-mysql-mariadb-bases-utilisateurs-droits-et-sauvegardes\/"},"wordCount":619,"publisher":{"@id":"https:\/\/eryann.fr\/#organization"},"articleSection":["Linux","Syst\u00e8me"],"inLanguage":"fr-FR"},{"@type":"WebPage","@id":"https:\/\/eryann.fr\/index.php\/linux\/fiche-mysql-mariadb-bases-utilisateurs-droits-et-sauvegardes\/","url":"https:\/\/eryann.fr\/index.php\/linux\/fiche-mysql-mariadb-bases-utilisateurs-droits-et-sauvegardes\/","name":"Fiche mysql \/ mariadb : bases, utilisateurs, droits et sauvegardes - Eryann Breizh SecOps","isPartOf":{"@id":"https:\/\/eryann.fr\/#website"},"datePublished":"2026-03-03T19:31:00+00:00","dateModified":"2026-05-04T08:58:54+00:00","breadcrumb":{"@id":"https:\/\/eryann.fr\/index.php\/linux\/fiche-mysql-mariadb-bases-utilisateurs-droits-et-sauvegardes\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/eryann.fr\/index.php\/linux\/fiche-mysql-mariadb-bases-utilisateurs-droits-et-sauvegardes\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/eryann.fr\/index.php\/linux\/fiche-mysql-mariadb-bases-utilisateurs-droits-et-sauvegardes\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/eryann.fr\/"},{"@type":"ListItem","position":2,"name":"Fiche mysql \/ mariadb : bases, utilisateurs, droits et sauvegardes"}]},{"@type":"WebSite","@id":"https:\/\/eryann.fr\/#website","url":"https:\/\/eryann.fr\/","name":"Eryann Breizh SecOps","description":"Fiches techniques &amp; labs en syst\u00e8mes et r\u00e9seaux poor les \u00e9tudiants en BTS CEIL ET SIO","publisher":{"@id":"https:\/\/eryann.fr\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/eryann.fr\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"fr-FR"},{"@type":"Organization","@id":"https:\/\/eryann.fr\/#organization","name":"Breizh Sec Ops","url":"https:\/\/eryann.fr\/","logo":{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/eryann.fr\/#\/schema\/logo\/image\/","url":"https:\/\/eryann.fr\/wp-content\/uploads\/2026\/05\/cropped-088112b9-fd28-4b18-b02d-4d9dded3e900-e1777846396685.png","contentUrl":"https:\/\/eryann.fr\/wp-content\/uploads\/2026\/05\/cropped-088112b9-fd28-4b18-b02d-4d9dded3e900-e1777846396685.png","width":1246,"height":229,"caption":"Breizh Sec Ops"},"image":{"@id":"https:\/\/eryann.fr\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/eryann.fr\/#\/schema\/person\/d2ee98d2385cd045ed4fe1c07ca320b5","name":"wpadmin","image":{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/secure.gravatar.com\/avatar\/d71b4031c3d015de3ca68c137413277e548b331b07db0acf781b9379b798eb3e?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/d71b4031c3d015de3ca68c137413277e548b331b07db0acf781b9379b798eb3e?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/d71b4031c3d015de3ca68c137413277e548b331b07db0acf781b9379b798eb3e?s=96&d=mm&r=g","caption":"wpadmin"},"sameAs":["https:\/\/eryann.fr"],"url":"https:\/\/eryann.fr\/index.php\/author\/wpadmin\/"}]}},"_links":{"self":[{"href":"https:\/\/eryann.fr\/index.php\/wp-json\/wp\/v2\/posts\/322","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/eryann.fr\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/eryann.fr\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/eryann.fr\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/eryann.fr\/index.php\/wp-json\/wp\/v2\/comments?post=322"}],"version-history":[{"count":5,"href":"https:\/\/eryann.fr\/index.php\/wp-json\/wp\/v2\/posts\/322\/revisions"}],"predecessor-version":[{"id":331,"href":"https:\/\/eryann.fr\/index.php\/wp-json\/wp\/v2\/posts\/322\/revisions\/331"}],"wp:attachment":[{"href":"https:\/\/eryann.fr\/index.php\/wp-json\/wp\/v2\/media?parent=322"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/eryann.fr\/index.php\/wp-json\/wp\/v2\/categories?post=322"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/eryann.fr\/index.php\/wp-json\/wp\/v2\/tags?post=322"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}