{"id":193,"date":"2023-04-06T09:56:02","date_gmt":"2023-04-06T07:56:02","guid":{"rendered":"https:\/\/baltazorius.fr\/?p=193"},"modified":"2023-05-18T06:48:28","modified_gmt":"2023-05-18T04:48:28","slug":"phpmyadmin-afin-de-gerer-la-base-de-donnee-mysql","status":"publish","type":"post","link":"https:\/\/baltazorius.fr\/index.php\/2023\/04\/06\/phpmyadmin-afin-de-gerer-la-base-de-donnee-mysql\/","title":{"rendered":"PHPMyAdmin afin de g\u00e9rer la base de donn\u00e9e MySQL"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\"><strong><a href=\"https:\/\/www.phpmyadmin.net\/\" target=\"_blank\" rel=\"noreferrer noopener\">phpMyAdmin<\/a><\/strong> est une interface web en PHP pour administrer \u00e0 distance les <a href=\"https:\/\/doc.ubuntu-fr.org\/sgbd\" target=\"_blank\" rel=\"noreferrer noopener\">SGBD<\/a> <a href=\"https:\/\/doc.ubuntu-fr.org\/mysql\" target=\"_blank\" rel=\"noreferrer noopener\">MySQL<\/a> et <a href=\"https:\/\/doc.ubuntu-fr.org\/mariadb\" target=\"_blank\" rel=\"noreferrer noopener\">MariaDB<\/a>.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Il permet d&rsquo;administrer les \u00e9l\u00e9ments suivants :<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>les bases de donn\u00e9es<\/li>\n\n\n\n<li>les tables et leurs champs (ajout, suppression, d\u00e9finition du type)<\/li>\n\n\n\n<li>les index, les cl\u00e9s primaires et \u00e9trang\u00e8res<\/li>\n\n\n\n<li>les utilisateurs de la base et leurs permissions<\/li>\n\n\n\n<li>importer ou exporter les donn\u00e9es dans divers formats (CSV, XML, PDF, OpenDocument, Word, Excel et LaTeX)<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"800\" height=\"483\" src=\"https:\/\/baltazorius.fr\/wp-content\/uploads\/2023\/04\/phpmyadmin.png\" alt=\"\" class=\"wp-image-194\" srcset=\"https:\/\/baltazorius.fr\/wp-content\/uploads\/2023\/04\/phpmyadmin.png 800w, https:\/\/baltazorius.fr\/wp-content\/uploads\/2023\/04\/phpmyadmin-300x181.png 300w, https:\/\/baltazorius.fr\/wp-content\/uploads\/2023\/04\/phpmyadmin-768x464.png 768w\" sizes=\"auto, (max-width: 800px) 100vw, 800px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Pour toute information compl\u00e9mentaire il faut vous r\u00e9f\u00e9rer \u00e0 <a href=\"https:\/\/docs.phpmyadmin.net\/fr\/latest\/\" target=\"_blank\" rel=\"noreferrer noopener\">la documentation officielle de phpMyAdmin (en fran\u00e7ais).<\/a><\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Pr\u00e9-requis<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Avoir <a href=\"https:\/\/doc.ubuntu-fr.org\/tutoriel\/comment_installer_un_paquet#paquet_present_dans_les_depots\" target=\"_blank\" rel=\"noreferrer noopener\">install\u00e9 les paquets<\/a> suivants :<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>le SGBD <a href=\"\/\/mysql-server\" target=\"_blank\" rel=\"noreferrer noopener\">MySQL<\/a> ou <a href=\"\/\/mariadb-server\" target=\"_blank\" rel=\"noreferrer noopener\">MariaDB<\/a><\/li>\n\n\n\n<li>le serveur web <a href=\"\/\/apache2\" target=\"_blank\" rel=\"noreferrer noopener\">apache2<\/a> (ou <a href=\"\/\/lighttpd\" target=\"_blank\" rel=\"noreferrer noopener\">lighttpd<\/a>)<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">S&rsquo;\u00eatre assur\u00e9 que le serveur web fonctionne et que les scripts PHP sont correctement interpr\u00e9t\u00e9s.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Installation via les d\u00e9p\u00f4ts<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Il est recommand\u00e9 d&rsquo;installer phpMyAdmin depuis les d\u00e9p\u00f4ts officiels afin d&rsquo;avoir une installation imm\u00e9diatement fonctionnelle et de b\u00e9n\u00e9ficier des mises \u00e0 jour de s\u00e9curit\u00e9. <a href=\"https:\/\/doc.ubuntu-fr.org\/tutoriel\/comment_installer_un_paquet#paquet_present_dans_les_depots\" target=\"_blank\" rel=\"noreferrer noopener\">Installer le paquet<\/a> <strong><a href=\"\/\/phpmyadmin\" target=\"_blank\" rel=\"noreferrer noopener\">phpmyadmin<\/a><\/strong>.<br>Soit en ligne de commande :<\/p>\n\n\n<div class=\"wp-block-wab-pastacode\">\n\t<div class=\"code-embed-wrapper\"> <pre class=\"language-bash code-embed-pre\"  data-start=\"1\" data-line-offset=\"0\"><code class=\"language-bash code-embed-code\">sudo apt install phpmyadmin<\/code><\/pre> <div class=\"code-embed-infos\"> <\/div> <\/div><\/div>\n\n\n\n<p class=\"wp-block-paragraph\">Lors de l&rsquo;installation, il vous sera pos\u00e9 quelques questions auxquelles il faut r\u00e9pondre avec soin :<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Choisir le serveur web \u00e0 configurer automatiquement (utiliser les <strong>fl\u00e8ches du clavier<\/strong> ou la touche <strong><em>tab<\/em> <\/strong>pour se d\u00e9placer et la barre d&rsquo;espace pour s\u00e9lectionner\/d\u00e9s\u00e9lectionner) :<\/li>\n<\/ul>\n\n\n\n<p class=\"has-pale-pink-background-color has-background wp-block-paragraph\"><strong>\u00ab\u00a0Attention\u00a0\u00bb<\/strong> Le surlignage rouge n&rsquo;est pas une s\u00e9lection, il faut que \u00e7a affiche une \u00e9toile * entre les crochets, en utilisant la barre d&rsquo;espace<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"744\" height=\"178\" src=\"https:\/\/baltazorius.fr\/wp-content\/uploads\/2023\/04\/screenshot_20171028_125829.png\" alt=\"\" class=\"wp-image-200\" srcset=\"https:\/\/baltazorius.fr\/wp-content\/uploads\/2023\/04\/screenshot_20171028_125829.png 744w, https:\/\/baltazorius.fr\/wp-content\/uploads\/2023\/04\/screenshot_20171028_125829-300x72.png 300w\" sizes=\"auto, (max-width: 744px) 100vw, 744px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Cr\u00e9er la base de donn\u00e9es phpmyadmin : <strong>oui<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"978\" height=\"244\" src=\"https:\/\/baltazorius.fr\/wp-content\/uploads\/2023\/04\/screenshot_20171028_112911-1.png\" alt=\"\" class=\"wp-image-201\" srcset=\"https:\/\/baltazorius.fr\/wp-content\/uploads\/2023\/04\/screenshot_20171028_112911-1.png 978w, https:\/\/baltazorius.fr\/wp-content\/uploads\/2023\/04\/screenshot_20171028_112911-1-300x75.png 300w, https:\/\/baltazorius.fr\/wp-content\/uploads\/2023\/04\/screenshot_20171028_112911-1-768x192.png 768w\" sizes=\"auto, (max-width: 978px) 100vw, 978px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">D\u00e9finir un mot de passe pour l&rsquo;utilisateur MySQL phpmyadmin :<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"974\" height=\"166\" src=\"https:\/\/baltazorius.fr\/wp-content\/uploads\/2023\/04\/screenshot_20171028_112939.png\" alt=\"\" class=\"wp-image-202\" srcset=\"https:\/\/baltazorius.fr\/wp-content\/uploads\/2023\/04\/screenshot_20171028_112939.png 974w, https:\/\/baltazorius.fr\/wp-content\/uploads\/2023\/04\/screenshot_20171028_112939-300x51.png 300w, https:\/\/baltazorius.fr\/wp-content\/uploads\/2023\/04\/screenshot_20171028_112939-768x131.png 768w\" sizes=\"auto, (max-width: 974px) 100vw, 974px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Indiquer le mot de passe de l&rsquo;utilisateur MySQL \u00ab root \u00bb tel que d\u00e9fini \u00e0 l&rsquo;installation de mysql-server :<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"952\" height=\"167\" src=\"https:\/\/baltazorius.fr\/wp-content\/uploads\/2023\/04\/screenshot_20171028_113015.png\" alt=\"\" class=\"wp-image-203\" srcset=\"https:\/\/baltazorius.fr\/wp-content\/uploads\/2023\/04\/screenshot_20171028_113015.png 952w, https:\/\/baltazorius.fr\/wp-content\/uploads\/2023\/04\/screenshot_20171028_113015-300x53.png 300w, https:\/\/baltazorius.fr\/wp-content\/uploads\/2023\/04\/screenshot_20171028_113015-768x135.png 768w\" sizes=\"auto, (max-width: 952px) 100vw, 952px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">phpMyAdmin devrait \u00eatre accessible \u00e0 l&rsquo;adresse <a href=\"http:\/\/localhost\/phpmyadmin\" target=\"_blank\" rel=\"noreferrer noopener\">http:\/\/localhost\/phpmyadmin<\/a><\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Pourvoir se connecter PHPMyAdmin<\/h2>\n\n\n\n<p class=\"has-luminous-vivid-amber-background-color has-background wp-block-paragraph\"><strong>Le mieux est de cr\u00e9er un nouvel utilisateur et de lui attribuer tous les privil\u00e8ges<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Avec <a href=\"https:\/\/doc.ubuntu-fr.org\/mysql\" target=\"_blank\" rel=\"noreferrer noopener\">MySQL<\/a> et <a href=\"https:\/\/doc.ubuntu-fr.org\/mariadb\" target=\"_blank\" rel=\"noreferrer noopener\">MariaDB<\/a>, l&rsquo;authentification de l&rsquo;utilisateur <em>root<\/em> de MySQL se fait au moyen du <em><a href=\"https:\/\/doc.ubuntu-fr.org\/mysql#authentification\" target=\"_blank\" rel=\"noreferrer noopener\">plugin auth_socket<\/a><\/em>, donc avec <a href=\"https:\/\/doc.ubuntu-fr.org\/sudo\" target=\"_blank\" rel=\"noreferrer noopener\">sudo<\/a>.<br>Cette m\u00e9thode ne permet pas de se connecter avec phpMyAdmin, mais il est <a href=\"https:\/\/doc.ubuntu-fr.org\/mysql#ajouter_ou_changer_le_mot_de_passe_de_root\" target=\"_blank\" rel=\"noreferrer noopener\">vivement d\u00e9conseill\u00e9<\/a> de modifier ce comportement.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Si vous avez besoin d&rsquo;un acc\u00e8s global \u00e0 vos bases de donn\u00e9es depuis un m\u00eame compte, la solution conseill\u00e9e est donc de cr\u00e9er un nouvel utilisateur et de lui attribuer tous les privil\u00e8ges :<\/p>\n\n\n<div class=\"wp-block-wab-pastacode\">\n\t<div class=\"code-embed-wrapper\"> <pre class=\"language-bash code-embed-pre\"  data-start=\"1\" data-line-offset=\"0\"><code class=\"language-bash code-embed-code\">sudo mysql<\/code><\/pre> <div class=\"code-embed-infos\"> <\/div> <\/div><\/div>\n\n\n\n<p class=\"wp-block-paragraph\">Taper <strong>1<\/strong> puis <strong>enter<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Puis dans la console MySQL :<\/p>\n\n\n<div class=\"wp-block-wab-pastacode\">\n\t<div class=\"code-embed-wrapper\"> <pre class=\"language-bash code-embed-pre\"  data-start=\"1\" data-line-offset=\"0\"><code class=\"language-bash code-embed-code\">CREATE USER &#039;nom_utilisateur_choisi&#039;@&#039;localhost&#039; IDENTIFIED BY &#039;mot_de_passe_solide&#039;;<br\/>GRANT ALL ON *.* TO &#039;nom_utilisateur_choisi&#039;@&#039;localhost&#039; WITH GRANT OPTION;<br\/>FLUSH PRIVILEGES;<br\/>QUIT;<\/code><\/pre> <div class=\"code-embed-infos\"> <\/div> <\/div><\/div>\n\n\n\n<p class=\"wp-block-paragraph\">En rempla\u00e7ant \u00e9videmment <em><strong>nom_utilisateur_choisi<\/strong><\/em> et <em><strong>mot_de_passe_solide<\/strong><\/em> dans cette requ\u00eate.<\/p>\n\n\n\n<p class=\"has-pale-pink-background-color has-background wp-block-paragraph\">Cette solution peut \u00eatre utile sur un serveur de d\u00e9veloppement mais elle rend plus dangereuse une <a href=\"https:\/\/fr.wikipedia.org\/wiki\/attaque par force brute\" target=\"_blank\" rel=\"noreferrer noopener\">attaque par force brute<\/a> sur la page de connexion de phpMyAdmin. En production il est indispensable de prot\u00e9ger l&rsquo;acc\u00e8s \u00e0 phpMyAdmin gr\u00e2ce \u00e0 l&rsquo;outil <a href=\"https:\/\/doc.ubuntu-fr.org\/fail2ban\" target=\"_blank\" rel=\"noreferrer noopener\">fail2ban<\/a>, ou\/et \u00e0 des mesures de restriction d&rsquo;acc\u00e8s par IP, par ex. Et veillez \u00e0 utiliser un couple identifiant \/ mot de passe diff\u00e9rent pour chacun de vos sites ou applications web.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Nous pouvons configurer SSH pour \u00e9tablir une communication chiffr\u00e9e sur le serveur web :<\/strong> <a href=\"https:\/\/baltazorius.fr\/index.php\/2023\/04\/06\/configurer-ssh-pour-etablir-une-communication-chiffree\/\">https:\/\/baltazorius.fr\/index.php\/2023\/04\/06\/configurer-ssh-pour-etablir-une-communication-chiffree\/<\/a><\/p>\n<p>Views: 768<\/p>","protected":false},"excerpt":{"rendered":"<p>phpMyAdmin est une interface web en PHP pour administrer \u00e0 distance les SGBD MySQL et MariaDB. Il permet d&rsquo;administrer les \u00e9l\u00e9ments suivants : Pour toute information compl\u00e9mentaire il faut vous r\u00e9f\u00e9rer \u00e0 la documentation officielle de phpMyAdmin (en fran\u00e7ais). Pr\u00e9-requis Avoir install\u00e9 les paquets suivants : S&rsquo;\u00eatre assur\u00e9 que le serveur web fonctionne et que &#8230; <a href=\"https:\/\/baltazorius.fr\/index.php\/2023\/04\/06\/phpmyadmin-afin-de-gerer-la-base-de-donnee-mysql\/\" class=\"more-link\">En savoir plus<span class=\"screen-reader-text\"> \u00ab\u00a0PHPMyAdmin afin de g\u00e9rer la base de donn\u00e9e MySQL\u00a0\u00bb<\/span> &raquo;<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[13],"tags":[],"class_list":["post-193","post","type-post","status-publish","format-standard","hentry","category-linux"],"_links":{"self":[{"href":"https:\/\/baltazorius.fr\/index.php\/wp-json\/wp\/v2\/posts\/193","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/baltazorius.fr\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/baltazorius.fr\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/baltazorius.fr\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/baltazorius.fr\/index.php\/wp-json\/wp\/v2\/comments?post=193"}],"version-history":[{"count":6,"href":"https:\/\/baltazorius.fr\/index.php\/wp-json\/wp\/v2\/posts\/193\/revisions"}],"predecessor-version":[{"id":552,"href":"https:\/\/baltazorius.fr\/index.php\/wp-json\/wp\/v2\/posts\/193\/revisions\/552"}],"wp:attachment":[{"href":"https:\/\/baltazorius.fr\/index.php\/wp-json\/wp\/v2\/media?parent=193"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/baltazorius.fr\/index.php\/wp-json\/wp\/v2\/categories?post=193"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/baltazorius.fr\/index.php\/wp-json\/wp\/v2\/tags?post=193"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}