{"id":300,"date":"2026-04-08T07:44:01","date_gmt":"2026-04-08T05:44:01","guid":{"rendered":"https:\/\/pandack.fr\/?p=300"},"modified":"2026-04-08T07:44:01","modified_gmt":"2026-04-08T05:44:01","slug":"mariadb","status":"publish","type":"post","link":"https:\/\/pandack.fr\/?p=300","title":{"rendered":"MariaDB"},"content":{"rendered":"<h2>\ud83d\udccb Commande : MariaDB<\/h2>\n<hr>\n<div class=\"callout callout--info\">\n<div class=\"callout__title\">&gt;  Voir [Installation Centreon et Serveur SQL d\u00e9port\u00e9s](..\/..\/02%20Infrastructure%20R\u00e9seau\/Superviseurs%20et%20Siem\/Installation%20Centreon%20et%20Serveur%20SQL%20d\u00e9port\u00e9s.md)<\/div>\n<div class=\"callout__content\"><\/div>\n<\/div>\n<div class=\"callout callout--tip\">\n<div class=\"callout__title\">&gt; Contents<\/div>\n<div class=\"callout__content\"><\/div>\n<\/div>\n<hr>\n<h2>Installation Serveur MySQL &#8211; MariaDB<\/h2>\n<p>Le serveur comprenant mariadb et phpmyadmin sera sur une distribution linux : Alma 9.7<\/p>\n<ul>\n<li>Hostname : sql-sev<\/li>\n<li>ip : 10.10.20.40\/24<\/li>\n<li>Passerelle : 10.10.20.1<\/li>\n<\/ul>\n<p>La version\u202f9.7 est actuellement la plus stable, et c\u2019est aussi celle qui b\u00e9n\u00e9ficie du meilleur support ainsi que de la disponibilit\u00e9 compl\u00e8te des paquets<\/p>\n<ul>\n<li>Installation de MariaDb<\/li>\n<\/ul>\n<div class=\"code-block-wrapper\">\n<div class=\"code-block-header\"><span class=\"code-language\">bash<\/span><button class=\"code-copy-btn\" type=\"button\">Copier<\/button><\/div>\n<pre><code class=\"language-bash\">sudo dnf install mariadb-server<\/code><\/pre>\n<\/div>\n<ul>\n<li>D\u00e9marrer le service mariadb<\/li>\n<\/ul>\n<div class=\"code-block-wrapper\">\n<div class=\"code-block-header\"><span class=\"code-language\">bash<\/span><button class=\"code-copy-btn\" type=\"button\">Copier<\/button><\/div>\n<pre><code class=\"language-bash\">sudo systemctl start mariadb.service\n\n#v\u00e9rifier son status \nsudo systemctl status mariadb.service<\/code><\/pre>\n<\/div>\n<ul>\n<li>Tester le fonctionne de mariadb<\/li>\n<\/ul>\n<div class=\"code-block-wrapper\">\n<div class=\"code-block-header\"><span class=\"code-language\">code<\/span><button class=\"code-copy-btn\" type=\"button\">Copier<\/button><\/div>\n<pre><code>sudo mysql --user root --execute &quot;select version()&quot;\n\n# R\u00e9sultat :\n+-----------------+\n| version()       |\n+-----------------+\n| 10.5.29-MariaDB |\n+-----------------+<\/code><\/pre>\n<\/div>\n<ul>\n<li>Lancer mariadb au lancement de la machine :<\/li>\n<\/ul>\n<div class=\"code-block-wrapper\">\n<div class=\"code-block-header\"><span class=\"code-language\">bash<\/span><button class=\"code-copy-btn\" type=\"button\">Copier<\/button><\/div>\n<pre><code class=\"language-bash\">sudo systemctl enable mariadb.service<\/code><\/pre>\n<\/div>\n<ul>\n<li>S\u00e9curisation<\/li>\n<\/ul>\n<p>Lancer le programme d&rsquo;installation pour configurer les param\u00e8tre de s\u00e9curit\u00e9 mariadb<\/p>\n<div class=\"code-block-wrapper\">\n<div class=\"code-block-header\"><span class=\"code-language\">code<\/span><button class=\"code-copy-btn\" type=\"button\">Copier<\/button><\/div>\n<pre><code>mysql_secure_installation\n\n# Switch to unix_socket authentification : N\n# Changer root password : N\n# Remove anonymous users? Y\n# Disallow root login remotely? Y\n# Remove test database and access to it? Y\n# Reload privilege tables now? Y<\/code><\/pre>\n<\/div>\n<ul>\n<li>Pour ce connect on va utilis\u00e9 la commande :<\/li>\n<\/ul>\n<div class=\"code-block-wrapper\">\n<div class=\"code-block-header\"><span class=\"code-language\">bash<\/span><button class=\"code-copy-btn\" type=\"button\">Copier<\/button><\/div>\n<pre><code class=\"language-bash\">mysql --user root<\/code><\/pre>\n<\/div>\n<ul>\n<li>Pour changer de mot de passe pour le compte root sur mariadb<\/li>\n<\/ul>\n<div class=\"code-block-wrapper\">\n<div class=\"code-block-header\"><span class=\"code-language\">bash<\/span><button class=\"code-copy-btn\" type=\"button\">Copier<\/button><\/div>\n<pre><code class=\"language-bash\">mysql --user root --password --execute &quot;select version()&quot;<\/code><\/pre>\n<\/div>\n<ul>\n<li>Si mot de passe perdu de root<\/li>\n<\/ul>\n<div class=\"code-block-wrapper\">\n<div class=\"code-block-header\"><span class=\"code-language\">code<\/span><button class=\"code-copy-btn\" type=\"button\">Copier<\/button><\/div>\n<pre><code># systemctl stop mariadb.service\n# mysqld_safe --skip-grant-tables --skip-networking  &amp;\n# mysql\nmysql&gt; UPDATE mysql.user SET Password=PASSWORD(&#039;NouveauMotDePasse&#039;) WHERE User=&#039;root&#039;;\nmysql&gt; FLUSH PRIVILEGES;\nmysql&gt; exit\n# mysqladmin shutdown\n# systemctl start mariadb.service<\/code><\/pre>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Commande : MariaDB Voir Installation Centreon et Serveur SQL d\u00e9port\u00e9s Contents Installation Serveur MySQL &#8211; MariaDB Le serveur comprenant mariadb et phpmyadmin sera sur une distribution linux : Alma 9<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[155,158],"tags":[14],"class_list":["post-300","post","type-post","status-publish","format-standard","hentry","category-linux","category-linux-systeme","tag-rolead"],"_links":{"self":[{"href":"https:\/\/pandack.fr\/index.php?rest_route=\/wp\/v2\/posts\/300","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/pandack.fr\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/pandack.fr\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/pandack.fr\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/pandack.fr\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=300"}],"version-history":[{"count":0,"href":"https:\/\/pandack.fr\/index.php?rest_route=\/wp\/v2\/posts\/300\/revisions"}],"wp:attachment":[{"href":"https:\/\/pandack.fr\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=300"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/pandack.fr\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=300"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/pandack.fr\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=300"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}