{"id":1067,"date":"2026-07-14T12:20:06","date_gmt":"2026-07-14T10:20:06","guid":{"rendered":"https:\/\/communaute-omr.fr\/?p=1067"},"modified":"2026-07-31T16:51:22","modified_gmt":"2026-07-31T14:51:22","slug":"mysql-les-bases","status":"publish","type":"post","link":"https:\/\/communaute-omr.fr\/?p=1067","title":{"rendered":"Mysql Les bases"},"content":{"rendered":"\n<h1 id=\"but-de-larticle\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"But_de_larticle\"><\/span>But de l\u2019article<span class=\"ez-toc-section-end\"><\/span><\/h1>\n\n\n\n<p class=\"wp-block-paragraph\">Nous allons voir dans cet article les bases pour se d\u00e9placer dans les m\u00e9andres d\u2019une base de donn\u00e9es Mysql.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Pour cet article nous travaillerons sur une base de donn\u00e9es h\u00e9bergeant un site wordpress.<\/p>\n\n\n\n<h1 id=\"se-connecter-a-mysql\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Se_connecter_a_MySql\"><\/span>Se connecter \u00e0 MySql<span class=\"ez-toc-section-end\"><\/span><\/h1>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Quelques_regles_de_securite\"><\/span>Quelques r\u00e8gles de s\u00e9curit\u00e9<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">R\u00e9gles de base pour la connection :<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Les utilisateurs doivent avoir un mot de passe avec :\n<ul class=\"wp-block-list\">\n<li>Majuscule<\/li>\n\n\n\n<li>Minuscule<\/li>\n\n\n\n<li>Caract\u00e8re sp\u00e9ciaux<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>On ne tape jamais en clair un Mot de passe dans la console<\/li>\n\n\n\n<li>je conseil de cr\u00e9er un alias pour les connections mysql avec un mot de passe afin d&rsquo;avoir un history vierge de tout mot de passe<\/li>\n<\/ul>\n\n\n\n<!--more-->\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"En_local\"><\/span>En local<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono\" style=\"font-size:.75rem;font-family:Code-Pro-JetBrains-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;line-height:1rem;--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><span style=\"display:block;padding:16px 0 0 16px;margin-bottom:-1px;width:100%;text-align:left;background-color:#24292e\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"54\" height=\"14\" viewBox=\"0 0 54 14\"><g fill=\"none\" fill-rule=\"evenodd\" transform=\"translate(1 1)\"><circle cx=\"6\" cy=\"6\" r=\"6\" fill=\"#FF5F56\" stroke=\"#E0443E\" stroke-width=\".5\"><\/circle><circle cx=\"26\" cy=\"6\" r=\"6\" fill=\"#FFBD2E\" stroke=\"#DEA123\" stroke-width=\".5\"><\/circle><circle cx=\"46\" cy=\"6\" r=\"6\" fill=\"#27C93F\" stroke=\"#1AAB29\" stroke-width=\".5\"><\/circle><\/g><\/svg><\/span><span role=\"button\" tabindex=\"0\" style=\"color:#e1e4e8;display:none\" aria-label=\"Copy\" class=\"code-block-pro-copy-button\"><pre class=\"code-block-pro-copy-button-pre\" aria-hidden=\"true\"><textarea class=\"code-block-pro-copy-button-textarea\" tabindex=\"-1\" aria-hidden=\"true\" readonly> vi .bashrc\n# .bashrc\n\n# Source global definitions\nif &#91; -f \/etc\/bashrc &#93;; then\n        . \/etc\/bashrc\nfi\n\n# User specific environment\nif ! [&#91; \"$PATH\" =~ \"$HOME\/.local\/bin:$HOME\/bin:\" &#93;]\nthen\n    PATH=\"$HOME\/.local\/bin:$HOME\/bin:$PATH\"\nfi\nexport PATH\n\n# Uncomment the following line if you don't like systemctl's auto-paging feature:\n# export SYSTEMD_PAGER=\n\n# User specific aliases and functions\nalias dbconect='mysql -u &lt;User> -p &lt;Password>'\nalias rm='rm -i'\nalias cp='cp -i'\nalias mv='mv -i'\n~\n<\/textarea><\/pre><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" style=\"width:24px;height:24px\" fill=\"none\" viewBox=\"0 0 24 24\" stroke=\"currentColor\" stroke-width=\"2\"><path class=\"with-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2m-6 9l2 2 4-4\"><\/path><path class=\"without-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2\"><\/path><\/svg><\/span><pre class=\"shiki github-dark\" style=\"background-color: #24292e\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #B392F0\">vi<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #9ECBFF\">.bashrc<\/span><\/span>\n<span class=\"line\"><span style=\"color: #6A737D\"># .bashrc<\/span><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><span style=\"color: #6A737D\"># Source global definitions<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F97583\">if<\/span><span style=\"color: #E1E4E8\"> &#91; <\/span><span style=\"color: #F97583\">-f<\/span><span style=\"color: #E1E4E8\"> \/etc\/bashrc &#93;; <\/span><span style=\"color: #F97583\">then<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">        <\/span><span style=\"color: #79B8FF\">.<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #9ECBFF\">\/etc\/bashrc<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F97583\">fi<\/span><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><span style=\"color: #6A737D\"># User specific environment<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F97583\">if<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #F97583\">!<\/span><span style=\"color: #E1E4E8\"> [&#91; <\/span><span style=\"color: #9ECBFF\">&quot;<\/span><span style=\"color: #E1E4E8\">$PATH<\/span><span style=\"color: #9ECBFF\">&quot;<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #F97583\">=~<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #9ECBFF\">&quot;<\/span><span style=\"color: #E1E4E8\">$HOME<\/span><span style=\"color: #9ECBFF\">\/.local\/bin:<\/span><span style=\"color: #E1E4E8\">$HOME<\/span><span style=\"color: #9ECBFF\">\/bin:&quot;<\/span><span style=\"color: #E1E4E8\"> &#93;]<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F97583\">then<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">    PATH<\/span><span style=\"color: #F97583\">=<\/span><span style=\"color: #9ECBFF\">&quot;<\/span><span style=\"color: #E1E4E8\">$HOME<\/span><span style=\"color: #9ECBFF\">\/.local\/bin:<\/span><span style=\"color: #E1E4E8\">$HOME<\/span><span style=\"color: #9ECBFF\">\/bin:<\/span><span style=\"color: #E1E4E8\">$PATH<\/span><span style=\"color: #9ECBFF\">&quot;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F97583\">fi<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F97583\">export<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #9ECBFF\">PATH<\/span><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><span style=\"color: #6A737D\"># Uncomment the following line if you don&#39;t like systemctl&#39;s auto-paging feature:<\/span><\/span>\n<span class=\"line\"><span style=\"color: #6A737D\"># export SYSTEMD_PAGER=<\/span><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><span style=\"color: #6A737D\"># User specific aliases and functions<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F97583\">alias<\/span><span style=\"color: #E1E4E8\"> dbconect<\/span><span style=\"color: #F97583\">=<\/span><span style=\"color: #9ECBFF\">&#39;mysql -u &lt;User&gt; -p &lt;Password&gt;&#39;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F97583\">alias<\/span><span style=\"color: #E1E4E8\"> rm<\/span><span style=\"color: #F97583\">=<\/span><span style=\"color: #9ECBFF\">&#39;rm -i&#39;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F97583\">alias<\/span><span style=\"color: #E1E4E8\"> cp<\/span><span style=\"color: #F97583\">=<\/span><span style=\"color: #9ECBFF\">&#39;cp -i&#39;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F97583\">alias<\/span><span style=\"color: #E1E4E8\"> mv<\/span><span style=\"color: #F97583\">=<\/span><span style=\"color: #9ECBFF\">&#39;mv -i&#39;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F97583\">~<\/span><\/span>\n<span class=\"line\"><\/span><\/code><\/pre><\/div>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"A_distance\"><\/span>A distance<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono\" style=\"font-size:.75rem;font-family:Code-Pro-JetBrains-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;line-height:1rem;--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><span style=\"display:block;padding:16px 0 0 16px;margin-bottom:-1px;width:100%;text-align:left;background-color:#24292e\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"54\" height=\"14\" viewBox=\"0 0 54 14\"><g fill=\"none\" fill-rule=\"evenodd\" transform=\"translate(1 1)\"><circle cx=\"6\" cy=\"6\" r=\"6\" fill=\"#FF5F56\" stroke=\"#E0443E\" stroke-width=\".5\"><\/circle><circle cx=\"26\" cy=\"6\" r=\"6\" fill=\"#FFBD2E\" stroke=\"#DEA123\" stroke-width=\".5\"><\/circle><circle cx=\"46\" cy=\"6\" r=\"6\" fill=\"#27C93F\" stroke=\"#1AAB29\" stroke-width=\".5\"><\/circle><\/g><\/svg><\/span><span role=\"button\" tabindex=\"0\" style=\"color:#e1e4e8;display:none\" aria-label=\"Copy\" class=\"code-block-pro-copy-button\"><pre class=\"code-block-pro-copy-button-pre\" aria-hidden=\"true\"><textarea class=\"code-block-pro-copy-button-textarea\" tabindex=\"-1\" aria-hidden=\"true\" readonly> vi .bashrc\n# .bashrc\n\n# Source global definitions\nif &#91; -f \/etc\/bashrc &#93;; then\n        . \/etc\/bashrc\nfi\n\n# User specific environment\nif ! [&#91; \"$PATH\" =~ \"$HOME\/.local\/bin:$HOME\/bin:\" &#93;]\nthen\n    PATH=\"$HOME\/.local\/bin:$HOME\/bin:$PATH\"\nfi\nexport PATH\n\n# Uncomment the following line if you don't like systemctl's auto-paging feature:\n# export SYSTEMD_PAGER=\n\n# User specific aliases and functions\nalias dbconect='mysql -h &lt;hostname> -u &lt;User> -p &lt;Password>'\nalias rm='rm -i'\nalias cp='cp -i'\nalias mv='mv -i'<\/textarea><\/pre><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" style=\"width:24px;height:24px\" fill=\"none\" viewBox=\"0 0 24 24\" stroke=\"currentColor\" stroke-width=\"2\"><path class=\"with-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2m-6 9l2 2 4-4\"><\/path><path class=\"without-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2\"><\/path><\/svg><\/span><pre class=\"shiki github-dark\" style=\"background-color: #24292e\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #B392F0\">vi<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #9ECBFF\">.bashrc<\/span><\/span>\n<span class=\"line\"><span style=\"color: #6A737D\"># .bashrc<\/span><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><span style=\"color: #6A737D\"># Source global definitions<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F97583\">if<\/span><span style=\"color: #E1E4E8\"> &#91; <\/span><span style=\"color: #F97583\">-f<\/span><span style=\"color: #E1E4E8\"> \/etc\/bashrc &#93;; <\/span><span style=\"color: #F97583\">then<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">        <\/span><span style=\"color: #79B8FF\">.<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #9ECBFF\">\/etc\/bashrc<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F97583\">fi<\/span><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><span style=\"color: #6A737D\"># User specific environment<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F97583\">if<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #F97583\">!<\/span><span style=\"color: #E1E4E8\"> [&#91; <\/span><span style=\"color: #9ECBFF\">&quot;<\/span><span style=\"color: #E1E4E8\">$PATH<\/span><span style=\"color: #9ECBFF\">&quot;<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #F97583\">=~<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #9ECBFF\">&quot;<\/span><span style=\"color: #E1E4E8\">$HOME<\/span><span style=\"color: #9ECBFF\">\/.local\/bin:<\/span><span style=\"color: #E1E4E8\">$HOME<\/span><span style=\"color: #9ECBFF\">\/bin:&quot;<\/span><span style=\"color: #E1E4E8\"> &#93;]<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F97583\">then<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">    PATH<\/span><span style=\"color: #F97583\">=<\/span><span style=\"color: #9ECBFF\">&quot;<\/span><span style=\"color: #E1E4E8\">$HOME<\/span><span style=\"color: #9ECBFF\">\/.local\/bin:<\/span><span style=\"color: #E1E4E8\">$HOME<\/span><span style=\"color: #9ECBFF\">\/bin:<\/span><span style=\"color: #E1E4E8\">$PATH<\/span><span style=\"color: #9ECBFF\">&quot;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F97583\">fi<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F97583\">export<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #9ECBFF\">PATH<\/span><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><span style=\"color: #6A737D\"># Uncomment the following line if you don&#39;t like systemctl&#39;s auto-paging feature:<\/span><\/span>\n<span class=\"line\"><span style=\"color: #6A737D\"># export SYSTEMD_PAGER=<\/span><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><span style=\"color: #6A737D\"># User specific aliases and functions<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F97583\">alias<\/span><span style=\"color: #E1E4E8\"> dbconect<\/span><span style=\"color: #F97583\">=<\/span><span style=\"color: #9ECBFF\">&#39;mysql -h &lt;hostname&gt; -u &lt;User&gt; -p &lt;Password&gt;&#39;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F97583\">alias<\/span><span style=\"color: #E1E4E8\"> rm<\/span><span style=\"color: #F97583\">=<\/span><span style=\"color: #9ECBFF\">&#39;rm -i&#39;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F97583\">alias<\/span><span style=\"color: #E1E4E8\"> cp<\/span><span style=\"color: #F97583\">=<\/span><span style=\"color: #9ECBFF\">&#39;cp -i&#39;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F97583\">alias<\/span><span style=\"color: #E1E4E8\"> mv<\/span><span style=\"color: #F97583\">=<\/span><span style=\"color: #9ECBFF\">&#39;mv -i&#39;<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<p class=\"wp-block-paragraph\">En tapant dbconnect dans la console, l&rsquo;authentification \u00e0 mysql sera automatique et transparente dans l&rsquo;historique<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Connection_manuelle\"><\/span>Connection manuelle<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<h3 id=\"en-local\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"En_local-2\"><\/span>En local<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro omr-terminal\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono\" style=\"font-size:.75rem;font-family:Code-Pro-JetBrains-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;line-height:1rem;--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><span style=\"display:block;padding:16px 0 0 16px;margin-bottom:-1px;width:100%;text-align:left;background-color:#24292e\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"54\" height=\"14\" viewBox=\"0 0 54 14\"><g fill=\"none\" fill-rule=\"evenodd\" transform=\"translate(1 1)\"><circle cx=\"6\" cy=\"6\" r=\"6\" fill=\"#FF5F56\" stroke=\"#E0443E\" stroke-width=\".5\"><\/circle><circle cx=\"26\" cy=\"6\" r=\"6\" fill=\"#FFBD2E\" stroke=\"#DEA123\" stroke-width=\".5\"><\/circle><circle cx=\"46\" cy=\"6\" r=\"6\" fill=\"#27C93F\" stroke=\"#1AAB29\" stroke-width=\".5\"><\/circle><\/g><\/svg><\/span><span role=\"button\" tabindex=\"0\" style=\"color:#e1e4e8;display:none\" aria-label=\"Copy\" class=\"code-block-pro-copy-button\"><pre class=\"code-block-pro-copy-button-pre\" aria-hidden=\"true\"><textarea class=\"code-block-pro-copy-button-textarea\" tabindex=\"-1\" aria-hidden=\"true\" readonly>mysql -u &lt;Utilisateur> -p\nEnter password:\nWelcome to the MariaDB monitor.  Commands end with ; or g.\nYour MariaDB connection id is 96981\nServer version: 10.5.29-MariaDB MariaDB Server\nCopyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.\nType 'help;' or 'h' for help. Type 'c' to clear the current input statement.\nMariaDB &#91;(none)&#93;><\/textarea><\/pre><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" style=\"width:24px;height:24px\" fill=\"none\" viewBox=\"0 0 24 24\" stroke=\"currentColor\" stroke-width=\"2\"><path class=\"with-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2m-6 9l2 2 4-4\"><\/path><path class=\"without-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2\"><\/path><\/svg><\/span><pre class=\"shiki github-dark\" style=\"background-color: #24292e\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #B392F0\">mysql<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #79B8FF\">-u<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #F97583\">&lt;<\/span><span style=\"color: #9ECBFF\">Utilisateu<\/span><span style=\"color: #E1E4E8\">r<\/span><span style=\"color: #F97583\">&gt;<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #79B8FF\">-p<\/span><\/span>\n<span class=\"line\"><span style=\"color: #B392F0\">Enter<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #9ECBFF\">password:<\/span><\/span>\n<span class=\"line\"><span style=\"color: #B392F0\">Welcome<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #9ECBFF\">to<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #9ECBFF\">the<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #9ECBFF\">MariaDB<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #9ECBFF\">monitor.<\/span><span style=\"color: #E1E4E8\">  <\/span><span style=\"color: #9ECBFF\">Commands<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #9ECBFF\">end<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #9ECBFF\">with<\/span><span style=\"color: #E1E4E8\"> ; <\/span><span style=\"color: #B392F0\">or<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #9ECBFF\">g.<\/span><\/span>\n<span class=\"line\"><span style=\"color: #B392F0\">Your<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #9ECBFF\">MariaDB<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #9ECBFF\">connection<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #9ECBFF\">id<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #9ECBFF\">is<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #79B8FF\">96981<\/span><\/span>\n<span class=\"line\"><span style=\"color: #B392F0\">Server<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #9ECBFF\">version:<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #79B8FF\">10.5<\/span><span style=\"color: #9ECBFF\">.29-MariaDB<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #9ECBFF\">MariaDB<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #9ECBFF\">Server<\/span><\/span>\n<span class=\"line\"><span style=\"color: #B392F0\">Copyright<\/span><span style=\"color: #E1E4E8\"> (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.<\/span><\/span>\n<span class=\"line\"><span style=\"color: #B392F0\">Type<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #9ECBFF\">&#39;help;&#39;<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #9ECBFF\">or<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #9ECBFF\">&#39;h&#39;<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #9ECBFF\">for<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #9ECBFF\">help.<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #9ECBFF\">Type<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #9ECBFF\">&#39;c&#39;<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #9ECBFF\">to<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #9ECBFF\">clear<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #9ECBFF\">the<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #9ECBFF\">current<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #9ECBFF\">input<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #9ECBFF\">statement.<\/span><\/span>\n<span class=\"line\"><span style=\"color: #B392F0\">MariaDB<\/span><span style=\"color: #E1E4E8\"> &#91;(none)&#93;<\/span><span style=\"color: #F97583\">&gt;<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<h3 id=\"a-distance\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"A_distance-2\"><\/span>A distance<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro omr-terminal\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono\" style=\"font-size:.75rem;font-family:Code-Pro-JetBrains-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;line-height:1rem;--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><span style=\"display:block;padding:16px 0 0 16px;margin-bottom:-1px;width:100%;text-align:left;background-color:#24292e\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"54\" height=\"14\" viewBox=\"0 0 54 14\"><g fill=\"none\" fill-rule=\"evenodd\" transform=\"translate(1 1)\"><circle cx=\"6\" cy=\"6\" r=\"6\" fill=\"#FF5F56\" stroke=\"#E0443E\" stroke-width=\".5\"><\/circle><circle cx=\"26\" cy=\"6\" r=\"6\" fill=\"#FFBD2E\" stroke=\"#DEA123\" stroke-width=\".5\"><\/circle><circle cx=\"46\" cy=\"6\" r=\"6\" fill=\"#27C93F\" stroke=\"#1AAB29\" stroke-width=\".5\"><\/circle><\/g><\/svg><\/span><span role=\"button\" tabindex=\"0\" style=\"color:#e1e4e8;display:none\" aria-label=\"Copy\" class=\"code-block-pro-copy-button\"><pre class=\"code-block-pro-copy-button-pre\" aria-hidden=\"true\"><textarea class=\"code-block-pro-copy-button-textarea\" tabindex=\"-1\" aria-hidden=\"true\" readonly>mysql -h &lt;Serveur distant> -u &lt;Utilisateur> -p\nEnter password:\nWelcome to the MariaDB monitor.  Commands end with ; or g.\nYour MariaDB connection id is 96981\nServer version: 10.5.29-MariaDB MariaDB Server\nCopyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.\nType 'help;' or 'h' for help. Type 'c' to clear the current input statement.\nMariaDB &#91;(none)&#93;><\/textarea><\/pre><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" style=\"width:24px;height:24px\" fill=\"none\" viewBox=\"0 0 24 24\" stroke=\"currentColor\" stroke-width=\"2\"><path class=\"with-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2m-6 9l2 2 4-4\"><\/path><path class=\"without-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2\"><\/path><\/svg><\/span><pre class=\"shiki github-dark\" style=\"background-color: #24292e\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #B392F0\">mysql<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #79B8FF\">-h<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #F97583\">&lt;<\/span><span style=\"color: #9ECBFF\">Serveur<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #9ECBFF\">distan<\/span><span style=\"color: #E1E4E8\">t<\/span><span style=\"color: #F97583\">&gt;<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #79B8FF\">-u<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #F97583\">&lt;<\/span><span style=\"color: #9ECBFF\">Utilisateu<\/span><span style=\"color: #E1E4E8\">r<\/span><span style=\"color: #F97583\">&gt;<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #79B8FF\">-p<\/span><\/span>\n<span class=\"line\"><span style=\"color: #B392F0\">Enter<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #9ECBFF\">password:<\/span><\/span>\n<span class=\"line\"><span style=\"color: #B392F0\">Welcome<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #9ECBFF\">to<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #9ECBFF\">the<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #9ECBFF\">MariaDB<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #9ECBFF\">monitor.<\/span><span style=\"color: #E1E4E8\">  <\/span><span style=\"color: #9ECBFF\">Commands<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #9ECBFF\">end<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #9ECBFF\">with<\/span><span style=\"color: #E1E4E8\"> ; <\/span><span style=\"color: #B392F0\">or<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #9ECBFF\">g.<\/span><\/span>\n<span class=\"line\"><span style=\"color: #B392F0\">Your<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #9ECBFF\">MariaDB<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #9ECBFF\">connection<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #9ECBFF\">id<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #9ECBFF\">is<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #79B8FF\">96981<\/span><\/span>\n<span class=\"line\"><span style=\"color: #B392F0\">Server<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #9ECBFF\">version:<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #79B8FF\">10.5<\/span><span style=\"color: #9ECBFF\">.29-MariaDB<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #9ECBFF\">MariaDB<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #9ECBFF\">Server<\/span><\/span>\n<span class=\"line\"><span style=\"color: #B392F0\">Copyright<\/span><span style=\"color: #E1E4E8\"> (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.<\/span><\/span>\n<span class=\"line\"><span style=\"color: #B392F0\">Type<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #9ECBFF\">&#39;help;&#39;<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #9ECBFF\">or<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #9ECBFF\">&#39;h&#39;<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #9ECBFF\">for<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #9ECBFF\">help.<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #9ECBFF\">Type<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #9ECBFF\">&#39;c&#39;<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #9ECBFF\">to<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #9ECBFF\">clear<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #9ECBFF\">the<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #9ECBFF\">current<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #9ECBFF\">input<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #9ECBFF\">statement.<\/span><\/span>\n<span class=\"line\"><span style=\"color: #B392F0\">MariaDB<\/span><span style=\"color: #E1E4E8\"> &#91;(none)&#93;<\/span><span style=\"color: #F97583\">&gt;<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<h1 id=\"environnement\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Environnement\"><\/span>Environnement<span class=\"ez-toc-section-end\"><\/span><\/h1>\n\n\n\n<h2 id=\"lister-les-variables\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Lister_les_variables\"><\/span>Lister les variables<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro omr-terminal\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono\" style=\"font-size:.75rem;font-family:Code-Pro-JetBrains-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;line-height:1rem;--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><span style=\"display:block;padding:16px 0 0 16px;margin-bottom:-1px;width:100%;text-align:left;background-color:#24292e\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"54\" height=\"14\" viewBox=\"0 0 54 14\"><g fill=\"none\" fill-rule=\"evenodd\" transform=\"translate(1 1)\"><circle cx=\"6\" cy=\"6\" r=\"6\" fill=\"#FF5F56\" stroke=\"#E0443E\" stroke-width=\".5\"><\/circle><circle cx=\"26\" cy=\"6\" r=\"6\" fill=\"#FFBD2E\" stroke=\"#DEA123\" stroke-width=\".5\"><\/circle><circle cx=\"46\" cy=\"6\" r=\"6\" fill=\"#27C93F\" stroke=\"#1AAB29\" stroke-width=\".5\"><\/circle><\/g><\/svg><\/span><span role=\"button\" tabindex=\"0\" style=\"color:#e1e4e8;display:none\" aria-label=\"Copy\" class=\"code-block-pro-copy-button\"><pre class=\"code-block-pro-copy-button-pre\" aria-hidden=\"true\"><textarea class=\"code-block-pro-copy-button-textarea\" tabindex=\"-1\" aria-hidden=\"true\" readonly>MariaDB &#91;(none)&#93;> SHOW GLOBAL VARIABLES;\n+----------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+\n| Variable_name                                            | Value                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          |\n+----------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+\n| allow_suspicious_udfs                                    | OFF                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            |\n| alter_algorithm                                          | DEFAULT                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        |\n| analyze_max_length                                       | 4294967295\n\n...\n\n|\n| wsrep_trx_fragment_size                                  | 0                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              |\n| wsrep_trx_fragment_unit                                  | bytes                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          |\n+----------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+\n655 rows in set (0,001 sec)<\/textarea><\/pre><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" style=\"width:24px;height:24px\" fill=\"none\" viewBox=\"0 0 24 24\" stroke=\"currentColor\" stroke-width=\"2\"><path class=\"with-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2m-6 9l2 2 4-4\"><\/path><path class=\"without-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2\"><\/path><\/svg><\/span><pre class=\"shiki github-dark\" style=\"background-color: #24292e\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #E1E4E8\">MariaDB &#91;(none)&#93;<\/span><span style=\"color: #F97583\">&gt;<\/span><span style=\"color: #E1E4E8\"> SHOW <\/span><span style=\"color: #F97583\">GLOBAL<\/span><span style=\"color: #E1E4E8\"> VARIABLES;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F97583\">+<\/span><span style=\"color: #6A737D\">----------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">| Variable_name                                            | <\/span><span style=\"color: #F97583\">Value<\/span><span style=\"color: #E1E4E8\">                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          |<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F97583\">+<\/span><span style=\"color: #6A737D\">----------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">| allow_suspicious_udfs                                    | <\/span><span style=\"color: #F97583\">OFF<\/span><span style=\"color: #E1E4E8\">                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            |<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">| alter_algorithm                                          | <\/span><span style=\"color: #F97583\">DEFAULT<\/span><span style=\"color: #E1E4E8\">                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        |<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">| analyze_max_length                                       | <\/span><span style=\"color: #79B8FF\">4294967295<\/span><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">...<\/span><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">|<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">| wsrep_trx_fragment_size                                  | <\/span><span style=\"color: #79B8FF\">0<\/span><span style=\"color: #E1E4E8\">                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              |<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">| wsrep_trx_fragment_unit                                  | bytes                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          |<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F97583\">+<\/span><span style=\"color: #6A737D\">----------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+<\/span><\/span>\n<span class=\"line\"><span style=\"color: #79B8FF\">655<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #F97583\">rows<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #F97583\">in<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #F97583\">set<\/span><span style=\"color: #E1E4E8\"> (<\/span><span style=\"color: #79B8FF\">0<\/span><span style=\"color: #E1E4E8\">,<\/span><span style=\"color: #79B8FF\">001<\/span><span style=\"color: #E1E4E8\"> sec)<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<h3 id=\"affichage-ameliore\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Affichage_ameliore\"><\/span>Affichage am\u00e9lior\u00e9<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Le G en fin de ligne permet de transposer chaque ligne de la table en ligne par champs.<\/p>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro omr-terminal\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono\" style=\"font-size:.75rem;font-family:Code-Pro-JetBrains-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;line-height:1rem;--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><span style=\"display:block;padding:16px 0 0 16px;margin-bottom:-1px;width:100%;text-align:left;background-color:#24292e\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"54\" height=\"14\" viewBox=\"0 0 54 14\"><g fill=\"none\" fill-rule=\"evenodd\" transform=\"translate(1 1)\"><circle cx=\"6\" cy=\"6\" r=\"6\" fill=\"#FF5F56\" stroke=\"#E0443E\" stroke-width=\".5\"><\/circle><circle cx=\"26\" cy=\"6\" r=\"6\" fill=\"#FFBD2E\" stroke=\"#DEA123\" stroke-width=\".5\"><\/circle><circle cx=\"46\" cy=\"6\" r=\"6\" fill=\"#27C93F\" stroke=\"#1AAB29\" stroke-width=\".5\"><\/circle><\/g><\/svg><\/span><span role=\"button\" tabindex=\"0\" style=\"color:#e1e4e8;display:none\" aria-label=\"Copy\" class=\"code-block-pro-copy-button\"><pre class=\"code-block-pro-copy-button-pre\" aria-hidden=\"true\"><textarea class=\"code-block-pro-copy-button-textarea\" tabindex=\"-1\" aria-hidden=\"true\" readonly>MariaDB &#91;(none)&#93;> SHOW GLOBAL VARIABLESG;\n*************************** 1. row ***************************\nVariable_name: allow_suspicious_udfs\nValue: OFF\n*************************** 2. row ***************************\nVariable_name: alter_algorithm\nValue: DEFAULT\n*************************** 3. row ***************************\nVariable_name: analyze_max_length\nValue: 4294967295\n*************************** 4. row ***************************\nVariable_name: analyze_sample_percentage\nValue: 100.000000\n*************************** 5. row ***************************\nVariable_name: aria_block_size\nValue: 8192\n\n...\n\n*************************** 654. row ***************************\nVariable_name: wsrep_trx_fragment_size\nValue: 0\n*************************** 655. row ***************************\nVariable_name: wsrep_trx_fragment_unit\nValue: bytes\n655 rows in set (0,001 sec)<\/textarea><\/pre><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" style=\"width:24px;height:24px\" fill=\"none\" viewBox=\"0 0 24 24\" stroke=\"currentColor\" stroke-width=\"2\"><path class=\"with-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2m-6 9l2 2 4-4\"><\/path><path class=\"without-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2\"><\/path><\/svg><\/span><pre class=\"shiki github-dark\" style=\"background-color: #24292e\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #E1E4E8\">MariaDB &#91;(none)&#93;<\/span><span style=\"color: #F97583\">&gt;<\/span><span style=\"color: #E1E4E8\"> SHOW <\/span><span style=\"color: #F97583\">GLOBAL<\/span><span style=\"color: #E1E4E8\"> VARIABLESG;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F97583\">***************************<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #79B8FF\">1<\/span><span style=\"color: #E1E4E8\">. <\/span><span style=\"color: #F97583\">row<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #F97583\">***************************<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">Variable_name: allow_suspicious_udfs<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F97583\">Value<\/span><span style=\"color: #E1E4E8\">: <\/span><span style=\"color: #F97583\">OFF<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F97583\">***************************<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #79B8FF\">2<\/span><span style=\"color: #E1E4E8\">. <\/span><span style=\"color: #F97583\">row<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #F97583\">***************************<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">Variable_name: alter_algorithm<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F97583\">Value<\/span><span style=\"color: #E1E4E8\">: <\/span><span style=\"color: #F97583\">DEFAULT<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F97583\">***************************<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #79B8FF\">3<\/span><span style=\"color: #E1E4E8\">. <\/span><span style=\"color: #F97583\">row<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #F97583\">***************************<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">Variable_name: analyze_max_length<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F97583\">Value<\/span><span style=\"color: #E1E4E8\">: <\/span><span style=\"color: #79B8FF\">4294967295<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F97583\">***************************<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #79B8FF\">4<\/span><span style=\"color: #E1E4E8\">. <\/span><span style=\"color: #F97583\">row<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #F97583\">***************************<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">Variable_name: analyze_sample_percentage<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F97583\">Value<\/span><span style=\"color: #E1E4E8\">: <\/span><span style=\"color: #79B8FF\">100<\/span><span style=\"color: #E1E4E8\">.<\/span><span style=\"color: #79B8FF\">000000<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F97583\">***************************<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #79B8FF\">5<\/span><span style=\"color: #E1E4E8\">. <\/span><span style=\"color: #F97583\">row<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #F97583\">***************************<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">Variable_name: aria_block_size<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F97583\">Value<\/span><span style=\"color: #E1E4E8\">: <\/span><span style=\"color: #79B8FF\">8192<\/span><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">...<\/span><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><span style=\"color: #F97583\">***************************<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #79B8FF\">654<\/span><span style=\"color: #E1E4E8\">. <\/span><span style=\"color: #F97583\">row<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #F97583\">***************************<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">Variable_name: wsrep_trx_fragment_size<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F97583\">Value<\/span><span style=\"color: #E1E4E8\">: <\/span><span style=\"color: #79B8FF\">0<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F97583\">***************************<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #79B8FF\">655<\/span><span style=\"color: #E1E4E8\">. <\/span><span style=\"color: #F97583\">row<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #F97583\">***************************<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">Variable_name: wsrep_trx_fragment_unit<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F97583\">Value<\/span><span style=\"color: #E1E4E8\">: bytes<\/span><\/span>\n<span class=\"line\"><span style=\"color: #79B8FF\">655<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #F97583\">rows<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #F97583\">in<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #F97583\">set<\/span><span style=\"color: #E1E4E8\"> (<\/span><span style=\"color: #79B8FF\">0<\/span><span style=\"color: #E1E4E8\">,<\/span><span style=\"color: #79B8FF\">001<\/span><span style=\"color: #E1E4E8\"> sec)<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<h3 id=\"rechercher-la-valeur-affectee-a-une-variable\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Rechercher_la_valeur_affectee_a_une_variable\"><\/span>Rechercher la valeur affect\u00e9e \u00e0 une variable<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro omr-terminal\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono\" style=\"font-size:.75rem;font-family:Code-Pro-JetBrains-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;line-height:1rem;--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><span style=\"display:block;padding:16px 0 0 16px;margin-bottom:-1px;width:100%;text-align:left;background-color:#24292e\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"54\" height=\"14\" viewBox=\"0 0 54 14\"><g fill=\"none\" fill-rule=\"evenodd\" transform=\"translate(1 1)\"><circle cx=\"6\" cy=\"6\" r=\"6\" fill=\"#FF5F56\" stroke=\"#E0443E\" stroke-width=\".5\"><\/circle><circle cx=\"26\" cy=\"6\" r=\"6\" fill=\"#FFBD2E\" stroke=\"#DEA123\" stroke-width=\".5\"><\/circle><circle cx=\"46\" cy=\"6\" r=\"6\" fill=\"#27C93F\" stroke=\"#1AAB29\" stroke-width=\".5\"><\/circle><\/g><\/svg><\/span><span role=\"button\" tabindex=\"0\" style=\"color:#e1e4e8;display:none\" aria-label=\"Copy\" class=\"code-block-pro-copy-button\"><pre class=\"code-block-pro-copy-button-pre\" aria-hidden=\"true\"><textarea class=\"code-block-pro-copy-button-textarea\" tabindex=\"-1\" aria-hidden=\"true\" readonly>SHOW GLOBAL VARIABLES LIKE 'Nom Variable';<\/textarea><\/pre><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" style=\"width:24px;height:24px\" fill=\"none\" viewBox=\"0 0 24 24\" stroke=\"currentColor\" stroke-width=\"2\"><path class=\"with-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2m-6 9l2 2 4-4\"><\/path><path class=\"without-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2\"><\/path><\/svg><\/span><pre class=\"shiki github-dark\" style=\"background-color: #24292e\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #E1E4E8\">SHOW <\/span><span style=\"color: #F97583\">GLOBAL<\/span><span style=\"color: #E1E4E8\"> VARIABLES <\/span><span style=\"color: #F97583\">LIKE<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #9ECBFF\">&#39;Nom Variable&#39;<\/span><span style=\"color: #E1E4E8\">;<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<p class=\"wp-block-paragraph\">Par exemple&nbsp;:<\/p>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro omr-terminal\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono\" style=\"font-size:.75rem;font-family:Code-Pro-JetBrains-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;line-height:1rem;--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><span style=\"display:block;padding:16px 0 0 16px;margin-bottom:-1px;width:100%;text-align:left;background-color:#24292e\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"54\" height=\"14\" viewBox=\"0 0 54 14\"><g fill=\"none\" fill-rule=\"evenodd\" transform=\"translate(1 1)\"><circle cx=\"6\" cy=\"6\" r=\"6\" fill=\"#FF5F56\" stroke=\"#E0443E\" stroke-width=\".5\"><\/circle><circle cx=\"26\" cy=\"6\" r=\"6\" fill=\"#FFBD2E\" stroke=\"#DEA123\" stroke-width=\".5\"><\/circle><circle cx=\"46\" cy=\"6\" r=\"6\" fill=\"#27C93F\" stroke=\"#1AAB29\" stroke-width=\".5\"><\/circle><\/g><\/svg><\/span><span role=\"button\" tabindex=\"0\" style=\"color:#e1e4e8;display:none\" aria-label=\"Copy\" class=\"code-block-pro-copy-button\"><pre class=\"code-block-pro-copy-button-pre\" aria-hidden=\"true\"><textarea class=\"code-block-pro-copy-button-textarea\" tabindex=\"-1\" aria-hidden=\"true\" readonly>SHOW GLOBAL VARIABLES LIKE 'max_binlog_size';\n+-----------------+------------+\n| Variable_name   | Value      |\n+-----------------+------------+\n| max_binlog_size | 1073741824 |\n+-----------------+------------+\n1 row in set (0,001 sec)<\/textarea><\/pre><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" style=\"width:24px;height:24px\" fill=\"none\" viewBox=\"0 0 24 24\" stroke=\"currentColor\" stroke-width=\"2\"><path class=\"with-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2m-6 9l2 2 4-4\"><\/path><path class=\"without-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2\"><\/path><\/svg><\/span><pre class=\"shiki github-dark\" style=\"background-color: #24292e\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #E1E4E8\">SHOW <\/span><span style=\"color: #F97583\">GLOBAL<\/span><span style=\"color: #E1E4E8\"> VARIABLES <\/span><span style=\"color: #F97583\">LIKE<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #9ECBFF\">&#39;max_binlog_size&#39;<\/span><span style=\"color: #E1E4E8\">;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F97583\">+<\/span><span style=\"color: #6A737D\">-----------------+------------+<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">| Variable_name   | <\/span><span style=\"color: #F97583\">Value<\/span><span style=\"color: #E1E4E8\">      |<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F97583\">+<\/span><span style=\"color: #6A737D\">-----------------+------------+<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">| max_binlog_size | <\/span><span style=\"color: #79B8FF\">1073741824<\/span><span style=\"color: #E1E4E8\"> |<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F97583\">+<\/span><span style=\"color: #6A737D\">-----------------+------------+<\/span><\/span>\n<span class=\"line\"><span style=\"color: #79B8FF\">1<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #F97583\">row<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #F97583\">in<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #F97583\">set<\/span><span style=\"color: #E1E4E8\"> (<\/span><span style=\"color: #79B8FF\">0<\/span><span style=\"color: #E1E4E8\">,<\/span><span style=\"color: #79B8FF\">001<\/span><span style=\"color: #E1E4E8\"> sec)<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<h1 id=\"les-databases\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Les_databases\"><\/span>Les databases<span class=\"ez-toc-section-end\"><\/span><\/h1>\n\n\n\n<h2 id=\"lister-les-databases\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Lister_les_databases\"><\/span>Lister les databases<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro omr-terminal\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono\" style=\"font-size:.75rem;font-family:Code-Pro-JetBrains-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;line-height:1rem;--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><span style=\"display:block;padding:16px 0 0 16px;margin-bottom:-1px;width:100%;text-align:left;background-color:#24292e\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"54\" height=\"14\" viewBox=\"0 0 54 14\"><g fill=\"none\" fill-rule=\"evenodd\" transform=\"translate(1 1)\"><circle cx=\"6\" cy=\"6\" r=\"6\" fill=\"#FF5F56\" stroke=\"#E0443E\" stroke-width=\".5\"><\/circle><circle cx=\"26\" cy=\"6\" r=\"6\" fill=\"#FFBD2E\" stroke=\"#DEA123\" stroke-width=\".5\"><\/circle><circle cx=\"46\" cy=\"6\" r=\"6\" fill=\"#27C93F\" stroke=\"#1AAB29\" stroke-width=\".5\"><\/circle><\/g><\/svg><\/span><span role=\"button\" tabindex=\"0\" style=\"color:#e1e4e8;display:none\" aria-label=\"Copy\" class=\"code-block-pro-copy-button\"><pre class=\"code-block-pro-copy-button-pre\" aria-hidden=\"true\"><textarea class=\"code-block-pro-copy-button-textarea\" tabindex=\"-1\" aria-hidden=\"true\" readonly>Show databases\u00a0;\n+--------------------+\n| Database           |\n+--------------------+\n| information_schema |\n| mysql              |\n| performance_schema |\n| wordpress          |\n| wordpress_old      |\n+--------------------+\n5 rows in set (0,001 sec)<\/textarea><\/pre><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" style=\"width:24px;height:24px\" fill=\"none\" viewBox=\"0 0 24 24\" stroke=\"currentColor\" stroke-width=\"2\"><path class=\"with-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2m-6 9l2 2 4-4\"><\/path><path class=\"without-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2\"><\/path><\/svg><\/span><pre class=\"shiki github-dark\" style=\"background-color: #24292e\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #E1E4E8\">Show databases\u00a0;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F97583\">+<\/span><span style=\"color: #6A737D\">--------------------+<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">| <\/span><span style=\"color: #F97583\">Database<\/span><span style=\"color: #E1E4E8\">           |<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F97583\">+<\/span><span style=\"color: #6A737D\">--------------------+<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">| information_schema |<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">| mysql              |<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">| performance_schema |<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">| wordpress          |<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">| wordpress_old      |<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F97583\">+<\/span><span style=\"color: #6A737D\">--------------------+<\/span><\/span>\n<span class=\"line\"><span style=\"color: #79B8FF\">5<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #F97583\">rows<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #F97583\">in<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #F97583\">set<\/span><span style=\"color: #E1E4E8\"> (<\/span><span style=\"color: #79B8FF\">0<\/span><span style=\"color: #E1E4E8\">,<\/span><span style=\"color: #79B8FF\">001<\/span><span style=\"color: #E1E4E8\"> sec)<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<h2 id=\"se-connecter-a-une-databases\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Se_connecter_a_une_databases\"><\/span>Se connecter \u00e0 une databases<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro omr-terminal\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono\" style=\"font-size:.75rem;font-family:Code-Pro-JetBrains-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;line-height:1rem;--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><span style=\"display:block;padding:16px 0 0 16px;margin-bottom:-1px;width:100%;text-align:left;background-color:#24292e\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"54\" height=\"14\" viewBox=\"0 0 54 14\"><g fill=\"none\" fill-rule=\"evenodd\" transform=\"translate(1 1)\"><circle cx=\"6\" cy=\"6\" r=\"6\" fill=\"#FF5F56\" stroke=\"#E0443E\" stroke-width=\".5\"><\/circle><circle cx=\"26\" cy=\"6\" r=\"6\" fill=\"#FFBD2E\" stroke=\"#DEA123\" stroke-width=\".5\"><\/circle><circle cx=\"46\" cy=\"6\" r=\"6\" fill=\"#27C93F\" stroke=\"#1AAB29\" stroke-width=\".5\"><\/circle><\/g><\/svg><\/span><span role=\"button\" tabindex=\"0\" style=\"color:#e1e4e8;display:none\" aria-label=\"Copy\" class=\"code-block-pro-copy-button\"><pre class=\"code-block-pro-copy-button-pre\" aria-hidden=\"true\"><textarea class=\"code-block-pro-copy-button-textarea\" tabindex=\"-1\" aria-hidden=\"true\" readonly>Use &lt;nom database>\u00a0;<\/textarea><\/pre><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" style=\"width:24px;height:24px\" fill=\"none\" viewBox=\"0 0 24 24\" stroke=\"currentColor\" stroke-width=\"2\"><path class=\"with-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2m-6 9l2 2 4-4\"><\/path><path class=\"without-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2\"><\/path><\/svg><\/span><pre class=\"shiki github-dark\" style=\"background-color: #24292e\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #F97583\">Use<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #F97583\">&lt;<\/span><span style=\"color: #E1E4E8\">nom <\/span><span style=\"color: #F97583\">database&gt;<\/span><span style=\"color: #E1E4E8\">\u00a0;<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<p class=\"wp-block-paragraph\">Par exemple&nbsp;:<\/p>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro omr-terminal\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono\" style=\"font-size:.75rem;font-family:Code-Pro-JetBrains-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;line-height:1rem;--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><span style=\"display:block;padding:16px 0 0 16px;margin-bottom:-1px;width:100%;text-align:left;background-color:#24292e\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"54\" height=\"14\" viewBox=\"0 0 54 14\"><g fill=\"none\" fill-rule=\"evenodd\" transform=\"translate(1 1)\"><circle cx=\"6\" cy=\"6\" r=\"6\" fill=\"#FF5F56\" stroke=\"#E0443E\" stroke-width=\".5\"><\/circle><circle cx=\"26\" cy=\"6\" r=\"6\" fill=\"#FFBD2E\" stroke=\"#DEA123\" stroke-width=\".5\"><\/circle><circle cx=\"46\" cy=\"6\" r=\"6\" fill=\"#27C93F\" stroke=\"#1AAB29\" stroke-width=\".5\"><\/circle><\/g><\/svg><\/span><span role=\"button\" tabindex=\"0\" style=\"color:#e1e4e8;display:none\" aria-label=\"Copy\" class=\"code-block-pro-copy-button\"><pre class=\"code-block-pro-copy-button-pre\" aria-hidden=\"true\"><textarea class=\"code-block-pro-copy-button-textarea\" tabindex=\"-1\" aria-hidden=\"true\" readonly>use mysql;\nReading table information for completion of table and column names\nYou can turn off this feature to get a quicker startup with -A\nDatabase changed\nMariaDB &#91;mysql&#93;><\/textarea><\/pre><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" style=\"width:24px;height:24px\" fill=\"none\" viewBox=\"0 0 24 24\" stroke=\"currentColor\" stroke-width=\"2\"><path class=\"with-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2m-6 9l2 2 4-4\"><\/path><path class=\"without-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2\"><\/path><\/svg><\/span><pre class=\"shiki github-dark\" style=\"background-color: #24292e\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #F97583\">use<\/span><span style=\"color: #E1E4E8\"> mysql;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">Reading <\/span><span style=\"color: #F97583\">table<\/span><span style=\"color: #E1E4E8\"> information <\/span><span style=\"color: #F97583\">for<\/span><span style=\"color: #E1E4E8\"> completion of <\/span><span style=\"color: #F97583\">table<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #F97583\">and<\/span><span style=\"color: #E1E4E8\"> column names<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">You can turn <\/span><span style=\"color: #F97583\">off<\/span><span style=\"color: #E1E4E8\"> this feature <\/span><span style=\"color: #F97583\">to<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #F97583\">get<\/span><span style=\"color: #E1E4E8\"> a quicker startup <\/span><span style=\"color: #F97583\">with<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #F97583\">-<\/span><span style=\"color: #E1E4E8\">A<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F97583\">Database<\/span><span style=\"color: #E1E4E8\"> changed<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">MariaDB &#91;mysql&#93;<\/span><span style=\"color: #F97583\">&gt;<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<h1 id=\"les-tables\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Les_tables\"><\/span>Les tables<span class=\"ez-toc-section-end\"><\/span><\/h1>\n\n\n\n<h2 id=\"lister-les-tables\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Lister_les_tables\"><\/span>Lister les tables<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro omr-terminal\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono\" style=\"font-size:.75rem;font-family:Code-Pro-JetBrains-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;line-height:1rem;--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><span style=\"display:block;padding:16px 0 0 16px;margin-bottom:-1px;width:100%;text-align:left;background-color:#24292e\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"54\" height=\"14\" viewBox=\"0 0 54 14\"><g fill=\"none\" fill-rule=\"evenodd\" transform=\"translate(1 1)\"><circle cx=\"6\" cy=\"6\" r=\"6\" fill=\"#FF5F56\" stroke=\"#E0443E\" stroke-width=\".5\"><\/circle><circle cx=\"26\" cy=\"6\" r=\"6\" fill=\"#FFBD2E\" stroke=\"#DEA123\" stroke-width=\".5\"><\/circle><circle cx=\"46\" cy=\"6\" r=\"6\" fill=\"#27C93F\" stroke=\"#1AAB29\" stroke-width=\".5\"><\/circle><\/g><\/svg><\/span><span role=\"button\" tabindex=\"0\" style=\"color:#e1e4e8;display:none\" aria-label=\"Copy\" class=\"code-block-pro-copy-button\"><pre class=\"code-block-pro-copy-button-pre\" aria-hidden=\"true\"><textarea class=\"code-block-pro-copy-button-textarea\" tabindex=\"-1\" aria-hidden=\"true\" readonly>MariaDB &#91;mysql&#93;> show tables;\n+---------------------------+\n| Tables_in_mysql           |\n+---------------------------+\n| column_stats              |\n| columns_priv              |\n| db                        |\n| event                     |\n| func                      |\n| general_log               |\n| global_priv               |\n| gtid_slave_pos            |\n| help_category             |\n| help_keyword              |\n| help_relation             |\n| help_topic                |\n| index_stats               |\n| innodb_index_stats        |\n| innodb_table_stats        |\n| plugin                    |\n| proc                      |\n| procs_priv                |\n| proxies_priv              |\n| roles_mapping             |\n| servers                   |\n| slow_log                  |\n| table_stats               |\n| tables_priv               |\n| time_zone                 |\n| time_zone_leap_second     |\n| time_zone_name            |\n| time_zone_transition      |\n| time_zone_transition_type |\n| transaction_registry      |\n| user                      |\n+---------------------------+\n31 rows in set (0,000 sec)<\/textarea><\/pre><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" style=\"width:24px;height:24px\" fill=\"none\" viewBox=\"0 0 24 24\" stroke=\"currentColor\" stroke-width=\"2\"><path class=\"with-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2m-6 9l2 2 4-4\"><\/path><path class=\"without-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2\"><\/path><\/svg><\/span><pre class=\"shiki github-dark\" style=\"background-color: #24292e\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #E1E4E8\">MariaDB &#91;mysql&#93;<\/span><span style=\"color: #F97583\">&gt;<\/span><span style=\"color: #E1E4E8\"> show tables;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F97583\">+<\/span><span style=\"color: #6A737D\">---------------------------+<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">| Tables_in_mysql           |<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F97583\">+<\/span><span style=\"color: #6A737D\">---------------------------+<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">| column_stats              |<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">| columns_priv              |<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">| db                        |<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">| <\/span><span style=\"color: #F97583\">event<\/span><span style=\"color: #E1E4E8\">                     |<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">| func                      |<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">| general_log               |<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">| global_priv               |<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">| gtid_slave_pos            |<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">| help_category             |<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">| help_keyword              |<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">| help_relation             |<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">| help_topic                |<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">| index_stats               |<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">| innodb_index_stats        |<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">| innodb_table_stats        |<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">| plugin                    |<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">| <\/span><span style=\"color: #F97583\">proc<\/span><span style=\"color: #E1E4E8\">                      |<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">| procs_priv                |<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">| proxies_priv              |<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">| roles_mapping             |<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">| servers                   |<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">| slow_log                  |<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">| table_stats               |<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">| tables_priv               |<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">| time_zone                 |<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">| time_zone_leap_second     |<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">| time_zone_name            |<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">| time_zone_transition      |<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">| time_zone_transition_type |<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">| transaction_registry      |<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">| user                      |<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F97583\">+<\/span><span style=\"color: #6A737D\">---------------------------+<\/span><\/span>\n<span class=\"line\"><span style=\"color: #79B8FF\">31<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #F97583\">rows<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #F97583\">in<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #F97583\">set<\/span><span style=\"color: #E1E4E8\"> (<\/span><span style=\"color: #79B8FF\">0<\/span><span style=\"color: #E1E4E8\">,<\/span><span style=\"color: #79B8FF\">000<\/span><span style=\"color: #E1E4E8\"> sec)<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<h2 id=\"information-sur-la-table\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Information_sur_une_table\"><\/span>Information sur une table<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro omr-terminal\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono\" style=\"font-size:.75rem;font-family:Code-Pro-JetBrains-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;line-height:1rem;--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><span style=\"display:block;padding:16px 0 0 16px;margin-bottom:-1px;width:100%;text-align:left;background-color:#24292e\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"54\" height=\"14\" viewBox=\"0 0 54 14\"><g fill=\"none\" fill-rule=\"evenodd\" transform=\"translate(1 1)\"><circle cx=\"6\" cy=\"6\" r=\"6\" fill=\"#FF5F56\" stroke=\"#E0443E\" stroke-width=\".5\"><\/circle><circle cx=\"26\" cy=\"6\" r=\"6\" fill=\"#FFBD2E\" stroke=\"#DEA123\" stroke-width=\".5\"><\/circle><circle cx=\"46\" cy=\"6\" r=\"6\" fill=\"#27C93F\" stroke=\"#1AAB29\" stroke-width=\".5\"><\/circle><\/g><\/svg><\/span><span role=\"button\" tabindex=\"0\" style=\"color:#e1e4e8;display:none\" aria-label=\"Copy\" class=\"code-block-pro-copy-button\"><pre class=\"code-block-pro-copy-button-pre\" aria-hidden=\"true\"><textarea class=\"code-block-pro-copy-button-textarea\" tabindex=\"-1\" aria-hidden=\"true\" readonly>MariaDB &#91;mysql&#93;> desc user;\n+------------------------+---------------------+------+-----+----------+-------+\n| Field                  | Type                | Null | Key | Default  | Extra |\n+------------------------+---------------------+------+-----+----------+-------+\n| Host                   | char(60)            | NO   |     |          |       |\n| User                   | char(80)            | NO   |     |          |       |\n| Password               | longtext            | YES  |     | NULL     |       |\n| Select_priv            | varchar(1)          | YES  |     | NULL     |       |\n| Insert_priv            | varchar(1)          | YES  |     | NULL     |       |\n| Update_priv            | varchar(1)          | YES  |     | NULL     |       |\n| Delete_priv            | varchar(1)          | YES  |     | NULL     |       |\n| Create_priv            | varchar(1)          | YES  |     | NULL     |       |\n| Drop_priv              | varchar(1)          | YES  |     | NULL     |       |\n| Reload_priv            | varchar(1)          | YES  |     | NULL     |       |\n| Shutdown_priv          | varchar(1)          | YES  |     | NULL     |       |\n| Process_priv           | varchar(1)          | YES  |     | NULL     |       |\n| File_priv              | varchar(1)          | YES  |     | NULL     |       |\n| Grant_priv             | varchar(1)          | YES  |     | NULL     |       |\n| References_priv        | varchar(1)          | YES  |     | NULL     |       |\n| Index_priv             | varchar(1)          | YES  |     | NULL     |       |\n| Alter_priv             | varchar(1)          | YES  |     | NULL     |       |\n| Show_db_priv           | varchar(1)          | YES  |     | NULL     |       |\n| Super_priv             | varchar(1)          | YES  |     | NULL     |       |\n| Create_tmp_table_priv  | varchar(1)          | YES  |     | NULL     |       |\n| Lock_tables_priv       | varchar(1)          | YES  |     | NULL     |       |\n| Execute_priv           | varchar(1)          | YES  |     | NULL     |       |\n| Repl_slave_priv        | varchar(1)          | YES  |     | NULL     |       |\n| Repl_client_priv       | varchar(1)          | YES  |     | NULL     |       |\n| Create_view_priv       | varchar(1)          | YES  |     | NULL     |       |\n| Show_view_priv         | varchar(1)          | YES  |     | NULL     |       |\n| Create_routine_priv    | varchar(1)          | YES  |     | NULL     |       |\n| Alter_routine_priv     | varchar(1)          | YES  |     | NULL     |       |\n| Create_user_priv       | varchar(1)          | YES  |     | NULL     |       |\n| Event_priv             | varchar(1)          | YES  |     | NULL     |       |\n| Trigger_priv           | varchar(1)          | YES  |     | NULL     |       |\n| Create_tablespace_priv | varchar(1)          | YES  |     | NULL     |       |\n| Delete_history_priv    | varchar(1)          | YES  |     | NULL     |       |\n| ssl_type               | varchar(9)          | YES  |     | NULL     |       |\n| ssl_cipher             | longtext            | NO   |     |          |       |\n| x509_issuer            | longtext            | NO   |     |          |       |\n| x509_subject           | longtext            | NO   |     |          |       |\n| max_questions          | bigint(20) unsigned | NO   |     | 0        |       |\n| max_updates            | bigint(20) unsigned | NO   |     | 0        |       |\n| max_connections        | bigint(20) unsigned | NO   |     | 0        |       |\n| max_user_connections   | bigint(21)          | NO   |     | 0        |       |\n| plugin                 | longtext            | NO   |     |          |       |\n| authentication_string  | longtext            | NO   |     |          |       |\n| password_expired       | varchar(1)          | NO   |     |          |       |\n| is_role                | varchar(1)          | YES  |     | NULL     |       |\n| default_role           | longtext            | NO   |     |          |       |\n| max_statement_time     | decimal(12,6)       | NO   |     | 0.000000 |       |\n+------------------------+---------------------+------+-----+----------+-------+\n47 rows in set (0,002 sec)<\/textarea><\/pre><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" style=\"width:24px;height:24px\" fill=\"none\" viewBox=\"0 0 24 24\" stroke=\"currentColor\" stroke-width=\"2\"><path class=\"with-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2m-6 9l2 2 4-4\"><\/path><path class=\"without-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2\"><\/path><\/svg><\/span><pre class=\"shiki github-dark\" style=\"background-color: #24292e\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #E1E4E8\">MariaDB &#91;mysql&#93;<\/span><span style=\"color: #F97583\">&gt;<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #F97583\">desc<\/span><span style=\"color: #E1E4E8\"> user;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F97583\">+<\/span><span style=\"color: #6A737D\">------------------------+---------------------+------+-----+----------+-------+<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">| Field                  | <\/span><span style=\"color: #F97583\">Type<\/span><span style=\"color: #E1E4E8\">                | <\/span><span style=\"color: #F97583\">Null<\/span><span style=\"color: #E1E4E8\"> | <\/span><span style=\"color: #F97583\">Key<\/span><span style=\"color: #E1E4E8\"> | <\/span><span style=\"color: #F97583\">Default<\/span><span style=\"color: #E1E4E8\">  | Extra |<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F97583\">+<\/span><span style=\"color: #6A737D\">------------------------+---------------------+------+-----+----------+-------+<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">| Host                   | <\/span><span style=\"color: #F97583\">char<\/span><span style=\"color: #E1E4E8\">(<\/span><span style=\"color: #79B8FF\">60<\/span><span style=\"color: #E1E4E8\">)            | <\/span><span style=\"color: #F97583\">NO<\/span><span style=\"color: #E1E4E8\">   |     |          |       |<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">| User                   | <\/span><span style=\"color: #F97583\">char<\/span><span style=\"color: #E1E4E8\">(<\/span><span style=\"color: #79B8FF\">80<\/span><span style=\"color: #E1E4E8\">)            | <\/span><span style=\"color: #F97583\">NO<\/span><span style=\"color: #E1E4E8\">   |     |          |       |<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">| <\/span><span style=\"color: #F97583\">Password<\/span><span style=\"color: #E1E4E8\">               | longtext            | YES  |     | <\/span><span style=\"color: #F97583\">NULL<\/span><span style=\"color: #E1E4E8\">     |       |<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">| Select_priv            | <\/span><span style=\"color: #F97583\">varchar<\/span><span style=\"color: #E1E4E8\">(<\/span><span style=\"color: #79B8FF\">1<\/span><span style=\"color: #E1E4E8\">)          | YES  |     | <\/span><span style=\"color: #F97583\">NULL<\/span><span style=\"color: #E1E4E8\">     |       |<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">| Insert_priv            | <\/span><span style=\"color: #F97583\">varchar<\/span><span style=\"color: #E1E4E8\">(<\/span><span style=\"color: #79B8FF\">1<\/span><span style=\"color: #E1E4E8\">)          | YES  |     | <\/span><span style=\"color: #F97583\">NULL<\/span><span style=\"color: #E1E4E8\">     |       |<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">| Update_priv            | <\/span><span style=\"color: #F97583\">varchar<\/span><span style=\"color: #E1E4E8\">(<\/span><span style=\"color: #79B8FF\">1<\/span><span style=\"color: #E1E4E8\">)          | YES  |     | <\/span><span style=\"color: #F97583\">NULL<\/span><span style=\"color: #E1E4E8\">     |       |<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">| Delete_priv            | <\/span><span style=\"color: #F97583\">varchar<\/span><span style=\"color: #E1E4E8\">(<\/span><span style=\"color: #79B8FF\">1<\/span><span style=\"color: #E1E4E8\">)          | YES  |     | <\/span><span style=\"color: #F97583\">NULL<\/span><span style=\"color: #E1E4E8\">     |       |<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">| Create_priv            | <\/span><span style=\"color: #F97583\">varchar<\/span><span style=\"color: #E1E4E8\">(<\/span><span style=\"color: #79B8FF\">1<\/span><span style=\"color: #E1E4E8\">)          | YES  |     | <\/span><span style=\"color: #F97583\">NULL<\/span><span style=\"color: #E1E4E8\">     |       |<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">| Drop_priv              | <\/span><span style=\"color: #F97583\">varchar<\/span><span style=\"color: #E1E4E8\">(<\/span><span style=\"color: #79B8FF\">1<\/span><span style=\"color: #E1E4E8\">)          | YES  |     | <\/span><span style=\"color: #F97583\">NULL<\/span><span style=\"color: #E1E4E8\">     |       |<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">| Reload_priv            | <\/span><span style=\"color: #F97583\">varchar<\/span><span style=\"color: #E1E4E8\">(<\/span><span style=\"color: #79B8FF\">1<\/span><span style=\"color: #E1E4E8\">)          | YES  |     | <\/span><span style=\"color: #F97583\">NULL<\/span><span style=\"color: #E1E4E8\">     |       |<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">| Shutdown_priv          | <\/span><span style=\"color: #F97583\">varchar<\/span><span style=\"color: #E1E4E8\">(<\/span><span style=\"color: #79B8FF\">1<\/span><span style=\"color: #E1E4E8\">)          | YES  |     | <\/span><span style=\"color: #F97583\">NULL<\/span><span style=\"color: #E1E4E8\">     |       |<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">| Process_priv           | <\/span><span style=\"color: #F97583\">varchar<\/span><span style=\"color: #E1E4E8\">(<\/span><span style=\"color: #79B8FF\">1<\/span><span style=\"color: #E1E4E8\">)          | YES  |     | <\/span><span style=\"color: #F97583\">NULL<\/span><span style=\"color: #E1E4E8\">     |       |<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">| File_priv              | <\/span><span style=\"color: #F97583\">varchar<\/span><span style=\"color: #E1E4E8\">(<\/span><span style=\"color: #79B8FF\">1<\/span><span style=\"color: #E1E4E8\">)          | YES  |     | <\/span><span style=\"color: #F97583\">NULL<\/span><span style=\"color: #E1E4E8\">     |       |<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">| Grant_priv             | <\/span><span style=\"color: #F97583\">varchar<\/span><span style=\"color: #E1E4E8\">(<\/span><span style=\"color: #79B8FF\">1<\/span><span style=\"color: #E1E4E8\">)          | YES  |     | <\/span><span style=\"color: #F97583\">NULL<\/span><span style=\"color: #E1E4E8\">     |       |<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">| References_priv        | <\/span><span style=\"color: #F97583\">varchar<\/span><span style=\"color: #E1E4E8\">(<\/span><span style=\"color: #79B8FF\">1<\/span><span style=\"color: #E1E4E8\">)          | YES  |     | <\/span><span style=\"color: #F97583\">NULL<\/span><span style=\"color: #E1E4E8\">     |       |<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">| Index_priv             | <\/span><span style=\"color: #F97583\">varchar<\/span><span style=\"color: #E1E4E8\">(<\/span><span style=\"color: #79B8FF\">1<\/span><span style=\"color: #E1E4E8\">)          | YES  |     | <\/span><span style=\"color: #F97583\">NULL<\/span><span style=\"color: #E1E4E8\">     |       |<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">| Alter_priv             | <\/span><span style=\"color: #F97583\">varchar<\/span><span style=\"color: #E1E4E8\">(<\/span><span style=\"color: #79B8FF\">1<\/span><span style=\"color: #E1E4E8\">)          | YES  |     | <\/span><span style=\"color: #F97583\">NULL<\/span><span style=\"color: #E1E4E8\">     |       |<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">| Show_db_priv           | <\/span><span style=\"color: #F97583\">varchar<\/span><span style=\"color: #E1E4E8\">(<\/span><span style=\"color: #79B8FF\">1<\/span><span style=\"color: #E1E4E8\">)          | YES  |     | <\/span><span style=\"color: #F97583\">NULL<\/span><span style=\"color: #E1E4E8\">     |       |<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">| Super_priv             | <\/span><span style=\"color: #F97583\">varchar<\/span><span style=\"color: #E1E4E8\">(<\/span><span style=\"color: #79B8FF\">1<\/span><span style=\"color: #E1E4E8\">)          | YES  |     | <\/span><span style=\"color: #F97583\">NULL<\/span><span style=\"color: #E1E4E8\">     |       |<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">| Create_tmp_table_priv  | <\/span><span style=\"color: #F97583\">varchar<\/span><span style=\"color: #E1E4E8\">(<\/span><span style=\"color: #79B8FF\">1<\/span><span style=\"color: #E1E4E8\">)          | YES  |     | <\/span><span style=\"color: #F97583\">NULL<\/span><span style=\"color: #E1E4E8\">     |       |<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">| Lock_tables_priv       | <\/span><span style=\"color: #F97583\">varchar<\/span><span style=\"color: #E1E4E8\">(<\/span><span style=\"color: #79B8FF\">1<\/span><span style=\"color: #E1E4E8\">)          | YES  |     | <\/span><span style=\"color: #F97583\">NULL<\/span><span style=\"color: #E1E4E8\">     |       |<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">| Execute_priv           | <\/span><span style=\"color: #F97583\">varchar<\/span><span style=\"color: #E1E4E8\">(<\/span><span style=\"color: #79B8FF\">1<\/span><span style=\"color: #E1E4E8\">)          | YES  |     | <\/span><span style=\"color: #F97583\">NULL<\/span><span style=\"color: #E1E4E8\">     |       |<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">| Repl_slave_priv        | <\/span><span style=\"color: #F97583\">varchar<\/span><span style=\"color: #E1E4E8\">(<\/span><span style=\"color: #79B8FF\">1<\/span><span style=\"color: #E1E4E8\">)          | YES  |     | <\/span><span style=\"color: #F97583\">NULL<\/span><span style=\"color: #E1E4E8\">     |       |<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">| Repl_client_priv       | <\/span><span style=\"color: #F97583\">varchar<\/span><span style=\"color: #E1E4E8\">(<\/span><span style=\"color: #79B8FF\">1<\/span><span style=\"color: #E1E4E8\">)          | YES  |     | <\/span><span style=\"color: #F97583\">NULL<\/span><span style=\"color: #E1E4E8\">     |       |<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">| Create_view_priv       | <\/span><span style=\"color: #F97583\">varchar<\/span><span style=\"color: #E1E4E8\">(<\/span><span style=\"color: #79B8FF\">1<\/span><span style=\"color: #E1E4E8\">)          | YES  |     | <\/span><span style=\"color: #F97583\">NULL<\/span><span style=\"color: #E1E4E8\">     |       |<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">| Show_view_priv         | <\/span><span style=\"color: #F97583\">varchar<\/span><span style=\"color: #E1E4E8\">(<\/span><span style=\"color: #79B8FF\">1<\/span><span style=\"color: #E1E4E8\">)          | YES  |     | <\/span><span style=\"color: #F97583\">NULL<\/span><span style=\"color: #E1E4E8\">     |       |<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">| Create_routine_priv    | <\/span><span style=\"color: #F97583\">varchar<\/span><span style=\"color: #E1E4E8\">(<\/span><span style=\"color: #79B8FF\">1<\/span><span style=\"color: #E1E4E8\">)          | YES  |     | <\/span><span style=\"color: #F97583\">NULL<\/span><span style=\"color: #E1E4E8\">     |       |<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">| Alter_routine_priv     | <\/span><span style=\"color: #F97583\">varchar<\/span><span style=\"color: #E1E4E8\">(<\/span><span style=\"color: #79B8FF\">1<\/span><span style=\"color: #E1E4E8\">)          | YES  |     | <\/span><span style=\"color: #F97583\">NULL<\/span><span style=\"color: #E1E4E8\">     |       |<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">| Create_user_priv       | <\/span><span style=\"color: #F97583\">varchar<\/span><span style=\"color: #E1E4E8\">(<\/span><span style=\"color: #79B8FF\">1<\/span><span style=\"color: #E1E4E8\">)          | YES  |     | <\/span><span style=\"color: #F97583\">NULL<\/span><span style=\"color: #E1E4E8\">     |       |<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">| Event_priv             | <\/span><span style=\"color: #F97583\">varchar<\/span><span style=\"color: #E1E4E8\">(<\/span><span style=\"color: #79B8FF\">1<\/span><span style=\"color: #E1E4E8\">)          | YES  |     | <\/span><span style=\"color: #F97583\">NULL<\/span><span style=\"color: #E1E4E8\">     |       |<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">| Trigger_priv           | <\/span><span style=\"color: #F97583\">varchar<\/span><span style=\"color: #E1E4E8\">(<\/span><span style=\"color: #79B8FF\">1<\/span><span style=\"color: #E1E4E8\">)          | YES  |     | <\/span><span style=\"color: #F97583\">NULL<\/span><span style=\"color: #E1E4E8\">     |       |<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">| Create_tablespace_priv | <\/span><span style=\"color: #F97583\">varchar<\/span><span style=\"color: #E1E4E8\">(<\/span><span style=\"color: #79B8FF\">1<\/span><span style=\"color: #E1E4E8\">)          | YES  |     | <\/span><span style=\"color: #F97583\">NULL<\/span><span style=\"color: #E1E4E8\">     |       |<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">| Delete_history_priv    | <\/span><span style=\"color: #F97583\">varchar<\/span><span style=\"color: #E1E4E8\">(<\/span><span style=\"color: #79B8FF\">1<\/span><span style=\"color: #E1E4E8\">)          | YES  |     | <\/span><span style=\"color: #F97583\">NULL<\/span><span style=\"color: #E1E4E8\">     |       |<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">| ssl_type               | <\/span><span style=\"color: #F97583\">varchar<\/span><span style=\"color: #E1E4E8\">(<\/span><span style=\"color: #79B8FF\">9<\/span><span style=\"color: #E1E4E8\">)          | YES  |     | <\/span><span style=\"color: #F97583\">NULL<\/span><span style=\"color: #E1E4E8\">     |       |<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">| ssl_cipher             | longtext            | <\/span><span style=\"color: #F97583\">NO<\/span><span style=\"color: #E1E4E8\">   |     |          |       |<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">| x509_issuer            | longtext            | <\/span><span style=\"color: #F97583\">NO<\/span><span style=\"color: #E1E4E8\">   |     |          |       |<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">| x509_subject           | longtext            | <\/span><span style=\"color: #F97583\">NO<\/span><span style=\"color: #E1E4E8\">   |     |          |       |<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">| max_questions          | <\/span><span style=\"color: #F97583\">bigint<\/span><span style=\"color: #E1E4E8\">(<\/span><span style=\"color: #79B8FF\">20<\/span><span style=\"color: #E1E4E8\">) unsigned | <\/span><span style=\"color: #F97583\">NO<\/span><span style=\"color: #E1E4E8\">   |     | <\/span><span style=\"color: #79B8FF\">0<\/span><span style=\"color: #E1E4E8\">        |       |<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">| max_updates            | <\/span><span style=\"color: #F97583\">bigint<\/span><span style=\"color: #E1E4E8\">(<\/span><span style=\"color: #79B8FF\">20<\/span><span style=\"color: #E1E4E8\">) unsigned | <\/span><span style=\"color: #F97583\">NO<\/span><span style=\"color: #E1E4E8\">   |     | <\/span><span style=\"color: #79B8FF\">0<\/span><span style=\"color: #E1E4E8\">        |       |<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">| max_connections        | <\/span><span style=\"color: #F97583\">bigint<\/span><span style=\"color: #E1E4E8\">(<\/span><span style=\"color: #79B8FF\">20<\/span><span style=\"color: #E1E4E8\">) unsigned | <\/span><span style=\"color: #F97583\">NO<\/span><span style=\"color: #E1E4E8\">   |     | <\/span><span style=\"color: #79B8FF\">0<\/span><span style=\"color: #E1E4E8\">        |       |<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">| max_user_connections   | <\/span><span style=\"color: #F97583\">bigint<\/span><span style=\"color: #E1E4E8\">(<\/span><span style=\"color: #79B8FF\">21<\/span><span style=\"color: #E1E4E8\">)          | <\/span><span style=\"color: #F97583\">NO<\/span><span style=\"color: #E1E4E8\">   |     | <\/span><span style=\"color: #79B8FF\">0<\/span><span style=\"color: #E1E4E8\">        |       |<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">| plugin                 | longtext            | <\/span><span style=\"color: #F97583\">NO<\/span><span style=\"color: #E1E4E8\">   |     |          |       |<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">| authentication_string  | longtext            | <\/span><span style=\"color: #F97583\">NO<\/span><span style=\"color: #E1E4E8\">   |     |          |       |<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">| password_expired       | <\/span><span style=\"color: #F97583\">varchar<\/span><span style=\"color: #E1E4E8\">(<\/span><span style=\"color: #79B8FF\">1<\/span><span style=\"color: #E1E4E8\">)          | <\/span><span style=\"color: #F97583\">NO<\/span><span style=\"color: #E1E4E8\">   |     |          |       |<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">| is_role                | <\/span><span style=\"color: #F97583\">varchar<\/span><span style=\"color: #E1E4E8\">(<\/span><span style=\"color: #79B8FF\">1<\/span><span style=\"color: #E1E4E8\">)          | YES  |     | <\/span><span style=\"color: #F97583\">NULL<\/span><span style=\"color: #E1E4E8\">     |       |<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">| default_role           | longtext            | <\/span><span style=\"color: #F97583\">NO<\/span><span style=\"color: #E1E4E8\">   |     |          |       |<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">| max_statement_time     | <\/span><span style=\"color: #F97583\">decimal<\/span><span style=\"color: #E1E4E8\">(<\/span><span style=\"color: #79B8FF\">12<\/span><span style=\"color: #E1E4E8\">,<\/span><span style=\"color: #79B8FF\">6<\/span><span style=\"color: #E1E4E8\">)       | <\/span><span style=\"color: #F97583\">NO<\/span><span style=\"color: #E1E4E8\">   |     | <\/span><span style=\"color: #79B8FF\">0<\/span><span style=\"color: #E1E4E8\">.<\/span><span style=\"color: #79B8FF\">000000<\/span><span style=\"color: #E1E4E8\"> |       |<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F97583\">+<\/span><span style=\"color: #6A737D\">------------------------+---------------------+------+-----+----------+-------+<\/span><\/span>\n<span class=\"line\"><span style=\"color: #79B8FF\">47<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #F97583\">rows<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #F97583\">in<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #F97583\">set<\/span><span style=\"color: #E1E4E8\"> (<\/span><span style=\"color: #79B8FF\">0<\/span><span style=\"color: #E1E4E8\">,<\/span><span style=\"color: #79B8FF\">002<\/span><span style=\"color: #E1E4E8\"> sec)<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<h1 id=\"gestion-des-utilisateurs\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Gestion_des_Utilisateurs\"><\/span>Gestion des Utilisateurs<span class=\"ez-toc-section-end\"><\/span><\/h1>\n\n\n\n<h2 id=\"lister-utilisateurs\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Lister_utilisateurs\"><\/span>Lister utilisateurs<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<h3 id=\"les-informations-importantes\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Les_informations_importantes\"><\/span>Les informations importantes<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro omr-terminal\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono\" style=\"font-size:.75rem;font-family:Code-Pro-JetBrains-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;line-height:1rem;--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><span style=\"display:block;padding:16px 0 0 16px;margin-bottom:-1px;width:100%;text-align:left;background-color:#24292e\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"54\" height=\"14\" viewBox=\"0 0 54 14\"><g fill=\"none\" fill-rule=\"evenodd\" transform=\"translate(1 1)\"><circle cx=\"6\" cy=\"6\" r=\"6\" fill=\"#FF5F56\" stroke=\"#E0443E\" stroke-width=\".5\"><\/circle><circle cx=\"26\" cy=\"6\" r=\"6\" fill=\"#FFBD2E\" stroke=\"#DEA123\" stroke-width=\".5\"><\/circle><circle cx=\"46\" cy=\"6\" r=\"6\" fill=\"#27C93F\" stroke=\"#1AAB29\" stroke-width=\".5\"><\/circle><\/g><\/svg><\/span><span role=\"button\" tabindex=\"0\" style=\"color:#e1e4e8;display:none\" aria-label=\"Copy\" class=\"code-block-pro-copy-button\"><pre class=\"code-block-pro-copy-button-pre\" aria-hidden=\"true\"><textarea class=\"code-block-pro-copy-button-textarea\" tabindex=\"-1\" aria-hidden=\"true\" readonly>select User,Host,Password,password_expired from user;\n+---------------+-----------+-------------------------------------------+------------------+\n| User          | Host      | Password                                  | password_expired |\n+---------------+-----------+-------------------------------------------+------------------+\n| mariadb.sys   | localhost |                                           | Y                |\n| root          | localhost | invalid                                   | N                |\n| mysql         | localhost | invalid                                   | N                |\n| wordpressuser | localhost | XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX | N                |\n| calou         | %         | XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX | N                |\n| admin         | %         | XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX | N                |\n+---------------+-----------+-------------------------------------------+------------------+\n6 rows in set (0,004 sec)<\/textarea><\/pre><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" style=\"width:24px;height:24px\" fill=\"none\" viewBox=\"0 0 24 24\" stroke=\"currentColor\" stroke-width=\"2\"><path class=\"with-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2m-6 9l2 2 4-4\"><\/path><path class=\"without-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2\"><\/path><\/svg><\/span><pre class=\"shiki github-dark\" style=\"background-color: #24292e\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #F97583\">select<\/span><span style=\"color: #E1E4E8\"> User,Host,<\/span><span style=\"color: #F97583\">Password<\/span><span style=\"color: #E1E4E8\">,password_expired <\/span><span style=\"color: #F97583\">from<\/span><span style=\"color: #E1E4E8\"> user;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F97583\">+<\/span><span style=\"color: #6A737D\">---------------+-----------+-------------------------------------------+------------------+<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">| User          | Host      | <\/span><span style=\"color: #F97583\">Password<\/span><span style=\"color: #E1E4E8\">                                  | password_expired |<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F97583\">+<\/span><span style=\"color: #6A737D\">---------------+-----------+-------------------------------------------+------------------+<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">| <\/span><span style=\"color: #79B8FF\">mariadb<\/span><span style=\"color: #E1E4E8\">.<\/span><span style=\"color: #79B8FF\">sys<\/span><span style=\"color: #E1E4E8\">   | localhost |                                           | Y                |<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">| <\/span><span style=\"color: #F97583\">root<\/span><span style=\"color: #E1E4E8\">          | localhost | invalid                                   | N                |<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">| mysql         | localhost | invalid                                   | N                |<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">| wordpressuser | localhost | XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX | N                |<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">| calou         | %         | XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX | N                |<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">| <\/span><span style=\"color: #F97583\">admin<\/span><span style=\"color: #E1E4E8\">         | %         | XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX | N                |<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F97583\">+<\/span><span style=\"color: #6A737D\">---------------+-----------+-------------------------------------------+------------------+<\/span><\/span>\n<span class=\"line\"><span style=\"color: #79B8FF\">6<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #F97583\">rows<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #F97583\">in<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #F97583\">set<\/span><span style=\"color: #E1E4E8\"> (<\/span><span style=\"color: #79B8FF\">0<\/span><span style=\"color: #E1E4E8\">,<\/span><span style=\"color: #79B8FF\">004<\/span><span style=\"color: #E1E4E8\"> sec)<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<h3 id=\"les-droits\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Les_droits\"><\/span>Les droits<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Pour lister des droits de l\u2019utilisateur admin&nbsp;:<\/p>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro omr-terminal\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono\" style=\"font-size:.75rem;font-family:Code-Pro-JetBrains-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;line-height:1rem;--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><span style=\"display:block;padding:16px 0 0 16px;margin-bottom:-1px;width:100%;text-align:left;background-color:#24292e\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"54\" height=\"14\" viewBox=\"0 0 54 14\"><g fill=\"none\" fill-rule=\"evenodd\" transform=\"translate(1 1)\"><circle cx=\"6\" cy=\"6\" r=\"6\" fill=\"#FF5F56\" stroke=\"#E0443E\" stroke-width=\".5\"><\/circle><circle cx=\"26\" cy=\"6\" r=\"6\" fill=\"#FFBD2E\" stroke=\"#DEA123\" stroke-width=\".5\"><\/circle><circle cx=\"46\" cy=\"6\" r=\"6\" fill=\"#27C93F\" stroke=\"#1AAB29\" stroke-width=\".5\"><\/circle><\/g><\/svg><\/span><span role=\"button\" tabindex=\"0\" style=\"color:#e1e4e8;display:none\" aria-label=\"Copy\" class=\"code-block-pro-copy-button\"><pre class=\"code-block-pro-copy-button-pre\" aria-hidden=\"true\"><textarea class=\"code-block-pro-copy-button-textarea\" tabindex=\"-1\" aria-hidden=\"true\" readonly>SHOW GRANTS FOR 'admin'@'%';\n+---------------------------------------------------------------------------------------------------------------------------------+\n| Grants for admin@%                                                                                                              |\n+---------------------------------------------------------------------------------------------------------------------------------+\n| GRANT ALL PRIVILEGES ON *.* TO `admin`@`%` IDENTIFIED BY PASSWORD 'XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX' WITH GRANT OPTION |\n+---------------------------------------------------------------------------------------------------------------------------------+<\/textarea><\/pre><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" style=\"width:24px;height:24px\" fill=\"none\" viewBox=\"0 0 24 24\" stroke=\"currentColor\" stroke-width=\"2\"><path class=\"with-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2m-6 9l2 2 4-4\"><\/path><path class=\"without-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2\"><\/path><\/svg><\/span><pre class=\"shiki github-dark\" style=\"background-color: #24292e\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #E1E4E8\">SHOW GRANTS <\/span><span style=\"color: #F97583\">FOR<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #9ECBFF\">&#39;admin&#39;<\/span><span style=\"color: #E1E4E8\">@<\/span><span style=\"color: #9ECBFF\">&#39;%&#39;<\/span><span style=\"color: #E1E4E8\">;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F97583\">+<\/span><span style=\"color: #6A737D\">---------------------------------------------------------------------------------------------------------------------------------+<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">| Grants <\/span><span style=\"color: #F97583\">for<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #F97583\">admin<\/span><span style=\"color: #E1E4E8\">@%                                                                                                              |<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F97583\">+<\/span><span style=\"color: #6A737D\">---------------------------------------------------------------------------------------------------------------------------------+<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">| <\/span><span style=\"color: #F97583\">GRANT<\/span><span style=\"color: #E1E4E8\"> ALL PRIVILEGES <\/span><span style=\"color: #F97583\">ON<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #F97583\">*<\/span><span style=\"color: #E1E4E8\">.<\/span><span style=\"color: #F97583\">*<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #F97583\">TO<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #9ECBFF\">`admin`<\/span><span style=\"color: #E1E4E8\">@<\/span><span style=\"color: #9ECBFF\">`%`<\/span><span style=\"color: #E1E4E8\"> IDENTIFIED <\/span><span style=\"color: #F97583\">BY<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #F97583\">PASSWORD<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #9ECBFF\">&#39;XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX&#39;<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #F97583\">WITH<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #F97583\">GRANT<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #F97583\">OPTION<\/span><span style=\"color: #E1E4E8\"> |<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F97583\">+<\/span><span style=\"color: #6A737D\">---------------------------------------------------------------------------------------------------------------------------------+<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<p class=\"wp-block-paragraph\">Et mon utilisateur :<\/p>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro omr-terminal\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono\" style=\"font-size:.75rem;font-family:Code-Pro-JetBrains-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;line-height:1rem;--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><span style=\"display:block;padding:16px 0 0 16px;margin-bottom:-1px;width:100%;text-align:left;background-color:#24292e\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"54\" height=\"14\" viewBox=\"0 0 54 14\"><g fill=\"none\" fill-rule=\"evenodd\" transform=\"translate(1 1)\"><circle cx=\"6\" cy=\"6\" r=\"6\" fill=\"#FF5F56\" stroke=\"#E0443E\" stroke-width=\".5\"><\/circle><circle cx=\"26\" cy=\"6\" r=\"6\" fill=\"#FFBD2E\" stroke=\"#DEA123\" stroke-width=\".5\"><\/circle><circle cx=\"46\" cy=\"6\" r=\"6\" fill=\"#27C93F\" stroke=\"#1AAB29\" stroke-width=\".5\"><\/circle><\/g><\/svg><\/span><span role=\"button\" tabindex=\"0\" style=\"color:#e1e4e8;display:none\" aria-label=\"Copy\" class=\"code-block-pro-copy-button\"><pre class=\"code-block-pro-copy-button-pre\" aria-hidden=\"true\"><textarea class=\"code-block-pro-copy-button-textarea\" tabindex=\"-1\" aria-hidden=\"true\" readonly>SHOW GRANTS FOR 'wordpressuser'@'localhost';\n+----------------------------------------------------------------------------------------------------------------------+\n| Grants for wordpressuser@localhost                                                                                   |\n+----------------------------------------------------------------------------------------------------------------------+\n| GRANT USAGE ON *.* TO `wordpressuser`@`localhost` IDENTIFIED BY PASSWORD 'XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX'  |\n| GRANT ALL PRIVILEGES ON `wordpress`.* TO `wordpressuser`@`localhost`                                                 |\n+----------------------------------------------------------------------------------------------------------------------+\n2 rows in set (0,000 sec)<\/textarea><\/pre><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" style=\"width:24px;height:24px\" fill=\"none\" viewBox=\"0 0 24 24\" stroke=\"currentColor\" stroke-width=\"2\"><path class=\"with-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2m-6 9l2 2 4-4\"><\/path><path class=\"without-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2\"><\/path><\/svg><\/span><pre class=\"shiki github-dark\" style=\"background-color: #24292e\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #E1E4E8\">SHOW GRANTS <\/span><span style=\"color: #F97583\">FOR<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #9ECBFF\">&#39;wordpressuser&#39;<\/span><span style=\"color: #E1E4E8\">@<\/span><span style=\"color: #9ECBFF\">&#39;localhost&#39;<\/span><span style=\"color: #E1E4E8\">;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F97583\">+<\/span><span style=\"color: #6A737D\">----------------------------------------------------------------------------------------------------------------------+<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">| Grants <\/span><span style=\"color: #F97583\">for<\/span><span style=\"color: #E1E4E8\"> wordpressuser@localhost                                                                                   |<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F97583\">+<\/span><span style=\"color: #6A737D\">----------------------------------------------------------------------------------------------------------------------+<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">| <\/span><span style=\"color: #F97583\">GRANT<\/span><span style=\"color: #E1E4E8\"> USAGE <\/span><span style=\"color: #F97583\">ON<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #F97583\">*<\/span><span style=\"color: #E1E4E8\">.<\/span><span style=\"color: #F97583\">*<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #F97583\">TO<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #9ECBFF\">`wordpressuser`<\/span><span style=\"color: #E1E4E8\">@<\/span><span style=\"color: #9ECBFF\">`localhost`<\/span><span style=\"color: #E1E4E8\"> IDENTIFIED <\/span><span style=\"color: #F97583\">BY<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #F97583\">PASSWORD<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #9ECBFF\">&#39;XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX&#39;<\/span><span style=\"color: #E1E4E8\">  |<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">| <\/span><span style=\"color: #F97583\">GRANT<\/span><span style=\"color: #E1E4E8\"> ALL PRIVILEGES <\/span><span style=\"color: #F97583\">ON<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #9ECBFF\">`wordpress`<\/span><span style=\"color: #E1E4E8\">.<\/span><span style=\"color: #F97583\">*<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #F97583\">TO<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #9ECBFF\">`wordpressuser`<\/span><span style=\"color: #E1E4E8\">@<\/span><span style=\"color: #9ECBFF\">`localhost`<\/span><span style=\"color: #E1E4E8\">                                                 |<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F97583\">+<\/span><span style=\"color: #6A737D\">----------------------------------------------------------------------------------------------------------------------+<\/span><\/span>\n<span class=\"line\"><span style=\"color: #79B8FF\">2<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #F97583\">rows<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #F97583\">in<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #F97583\">set<\/span><span style=\"color: #E1E4E8\"> (<\/span><span style=\"color: #79B8FF\">0<\/span><span style=\"color: #E1E4E8\">,<\/span><span style=\"color: #79B8FF\">000<\/span><span style=\"color: #E1E4E8\"> sec)<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<h3 id=\"comprehension-du-retour-des-2-commandes\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Comprehension_du_retour_des_2_commandes\"><\/span>Compr\u00e9hension du retour des 2 commandes<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Mon utilisateur admin \u00e0 tous les droits sur toutes les databases<\/li>\n\n\n\n<li>Mon utilisateur wordpressuser \u00e0 tous les droits uniquement sur la database wordpress <\/li>\n<\/ul>\n\n\n\n<h2 id=\"gestion-des-utilisateurs-2\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Gestion_des_utilisateurs\"><\/span>Gestion des utilisateurs<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<h3 id=\"creation\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Creation\"><\/span>Cr\u00e9ation<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro omr-terminal\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono\" style=\"font-size:.75rem;font-family:Code-Pro-JetBrains-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;line-height:1rem;--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><span style=\"display:block;padding:16px 0 0 16px;margin-bottom:-1px;width:100%;text-align:left;background-color:#24292e\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"54\" height=\"14\" viewBox=\"0 0 54 14\"><g fill=\"none\" fill-rule=\"evenodd\" transform=\"translate(1 1)\"><circle cx=\"6\" cy=\"6\" r=\"6\" fill=\"#FF5F56\" stroke=\"#E0443E\" stroke-width=\".5\"><\/circle><circle cx=\"26\" cy=\"6\" r=\"6\" fill=\"#FFBD2E\" stroke=\"#DEA123\" stroke-width=\".5\"><\/circle><circle cx=\"46\" cy=\"6\" r=\"6\" fill=\"#27C93F\" stroke=\"#1AAB29\" stroke-width=\".5\"><\/circle><\/g><\/svg><\/span><span role=\"button\" tabindex=\"0\" style=\"color:#e1e4e8;display:none\" aria-label=\"Copy\" class=\"code-block-pro-copy-button\"><pre class=\"code-block-pro-copy-button-pre\" aria-hidden=\"true\"><textarea class=\"code-block-pro-copy-button-textarea\" tabindex=\"-1\" aria-hidden=\"true\" readonly>CREATE USER \u2018&lt;Utilisateur>\u2019@\u2019Host\u2019 IDENTIFIED BY \u2018&lt;Mot de passe>\u2019;<\/textarea><\/pre><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" style=\"width:24px;height:24px\" fill=\"none\" viewBox=\"0 0 24 24\" stroke=\"currentColor\" stroke-width=\"2\"><path class=\"with-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2m-6 9l2 2 4-4\"><\/path><path class=\"without-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2\"><\/path><\/svg><\/span><pre class=\"shiki github-dark\" style=\"background-color: #24292e\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #F97583\">CREATE<\/span><span style=\"color: #E1E4E8\"> USER \u2018<\/span><span style=\"color: #F97583\">&lt;<\/span><span style=\"color: #E1E4E8\">Utilisateur<\/span><span style=\"color: #F97583\">&gt;<\/span><span style=\"color: #E1E4E8\">\u2019@\u2019Host\u2019 IDENTIFIED <\/span><span style=\"color: #F97583\">BY<\/span><span style=\"color: #E1E4E8\"> \u2018<\/span><span style=\"color: #F97583\">&lt;<\/span><span style=\"color: #E1E4E8\">Mot de passe<\/span><span style=\"color: #F97583\">&gt;<\/span><span style=\"color: #E1E4E8\">\u2019;<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<h3 id=\"affectation-de-droits\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Affectation_de_droits\"><\/span>Affectation de droits<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Droits admins<\/li>\n<\/ul>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono\" style=\"font-size:.75rem;font-family:Code-Pro-JetBrains-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;line-height:1rem;--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><span style=\"display:block;padding:16px 0 0 16px;margin-bottom:-1px;width:100%;text-align:left;background-color:#24292e\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"54\" height=\"14\" viewBox=\"0 0 54 14\"><g fill=\"none\" fill-rule=\"evenodd\" transform=\"translate(1 1)\"><circle cx=\"6\" cy=\"6\" r=\"6\" fill=\"#FF5F56\" stroke=\"#E0443E\" stroke-width=\".5\"><\/circle><circle cx=\"26\" cy=\"6\" r=\"6\" fill=\"#FFBD2E\" stroke=\"#DEA123\" stroke-width=\".5\"><\/circle><circle cx=\"46\" cy=\"6\" r=\"6\" fill=\"#27C93F\" stroke=\"#1AAB29\" stroke-width=\".5\"><\/circle><\/g><\/svg><\/span><span role=\"button\" tabindex=\"0\" style=\"color:#e1e4e8;display:none\" aria-label=\"Copy\" class=\"code-block-pro-copy-button\"><pre class=\"code-block-pro-copy-button-pre\" aria-hidden=\"true\"><textarea class=\"code-block-pro-copy-button-textarea\" tabindex=\"-1\" aria-hidden=\"true\" readonly>GRANT ALL PRIVILEGES ON *.* to \u2018&lt;Utilisateur>\u2019@\u2019Host\u2019 WITH GRANT OPTION;<\/textarea><\/pre><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" style=\"width:24px;height:24px\" fill=\"none\" viewBox=\"0 0 24 24\" stroke=\"currentColor\" stroke-width=\"2\"><path class=\"with-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2m-6 9l2 2 4-4\"><\/path><path class=\"without-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2\"><\/path><\/svg><\/span><pre class=\"shiki github-dark\" style=\"background-color: #24292e\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #F97583\">GRANT<\/span><span style=\"color: #E1E4E8\"> ALL PRIVILEGES <\/span><span style=\"color: #F97583\">ON<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #F97583\">*<\/span><span style=\"color: #E1E4E8\">.<\/span><span style=\"color: #F97583\">*<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #F97583\">to<\/span><span style=\"color: #E1E4E8\"> \u2018<\/span><span style=\"color: #F97583\">&lt;<\/span><span style=\"color: #E1E4E8\">Utilisateur<\/span><span style=\"color: #F97583\">&gt;<\/span><span style=\"color: #E1E4E8\">\u2019@\u2019Host\u2019 <\/span><span style=\"color: #F97583\">WITH<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #F97583\">GRANT<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #F97583\">OPTION<\/span><span style=\"color: #E1E4E8\">;<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Droits restreints \u00e0 une database<\/li>\n<\/ul>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono\" style=\"font-size:.75rem;font-family:Code-Pro-JetBrains-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;line-height:1rem;--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><span style=\"display:block;padding:16px 0 0 16px;margin-bottom:-1px;width:100%;text-align:left;background-color:#24292e\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"54\" height=\"14\" viewBox=\"0 0 54 14\"><g fill=\"none\" fill-rule=\"evenodd\" transform=\"translate(1 1)\"><circle cx=\"6\" cy=\"6\" r=\"6\" fill=\"#FF5F56\" stroke=\"#E0443E\" stroke-width=\".5\"><\/circle><circle cx=\"26\" cy=\"6\" r=\"6\" fill=\"#FFBD2E\" stroke=\"#DEA123\" stroke-width=\".5\"><\/circle><circle cx=\"46\" cy=\"6\" r=\"6\" fill=\"#27C93F\" stroke=\"#1AAB29\" stroke-width=\".5\"><\/circle><\/g><\/svg><\/span><span role=\"button\" tabindex=\"0\" style=\"color:#e1e4e8;display:none\" aria-label=\"Copy\" class=\"code-block-pro-copy-button\"><pre class=\"code-block-pro-copy-button-pre\" aria-hidden=\"true\"><textarea class=\"code-block-pro-copy-button-textarea\" tabindex=\"-1\" aria-hidden=\"true\" readonly>GRANT ALL PRIVILEGES ON &lt;Database>.* TO \u2018&lt;Utilisateur>\u2019@\u2019Host\u2019;<\/textarea><\/pre><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" style=\"width:24px;height:24px\" fill=\"none\" viewBox=\"0 0 24 24\" stroke=\"currentColor\" stroke-width=\"2\"><path class=\"with-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2m-6 9l2 2 4-4\"><\/path><path class=\"without-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2\"><\/path><\/svg><\/span><pre class=\"shiki github-dark\" style=\"background-color: #24292e\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #F97583\">GRANT<\/span><span style=\"color: #E1E4E8\"> ALL PRIVILEGES <\/span><span style=\"color: #F97583\">ON<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #F97583\">&lt;Database&gt;<\/span><span style=\"color: #E1E4E8\">.<\/span><span style=\"color: #F97583\">*<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #F97583\">TO<\/span><span style=\"color: #E1E4E8\"> \u2018<\/span><span style=\"color: #F97583\">&lt;<\/span><span style=\"color: #E1E4E8\">Utilisateur<\/span><span style=\"color: #F97583\">&gt;<\/span><span style=\"color: #E1E4E8\">\u2019@\u2019Host\u2019;<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<h3 id=\"changer-de-mot-de-passe\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Changer_de_mot_de_passe\"><\/span>Changer de mot de passe<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro omr-terminal\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono\" style=\"font-size:.75rem;font-family:Code-Pro-JetBrains-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;line-height:1rem;--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><span style=\"display:block;padding:16px 0 0 16px;margin-bottom:-1px;width:100%;text-align:left;background-color:#24292e\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"54\" height=\"14\" viewBox=\"0 0 54 14\"><g fill=\"none\" fill-rule=\"evenodd\" transform=\"translate(1 1)\"><circle cx=\"6\" cy=\"6\" r=\"6\" fill=\"#FF5F56\" stroke=\"#E0443E\" stroke-width=\".5\"><\/circle><circle cx=\"26\" cy=\"6\" r=\"6\" fill=\"#FFBD2E\" stroke=\"#DEA123\" stroke-width=\".5\"><\/circle><circle cx=\"46\" cy=\"6\" r=\"6\" fill=\"#27C93F\" stroke=\"#1AAB29\" stroke-width=\".5\"><\/circle><\/g><\/svg><\/span><span role=\"button\" tabindex=\"0\" style=\"color:#e1e4e8;display:none\" aria-label=\"Copy\" class=\"code-block-pro-copy-button\"><pre class=\"code-block-pro-copy-button-pre\" aria-hidden=\"true\"><textarea class=\"code-block-pro-copy-button-textarea\" tabindex=\"-1\" aria-hidden=\"true\" readonly>ALTER USER \u2018&lt;Utilisateur>\u2019@\u2019Host\u2019IDENTIFIED BY \u2018&lt;Nouveau mot de passe>\u2019<\/textarea><\/pre><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" style=\"width:24px;height:24px\" fill=\"none\" viewBox=\"0 0 24 24\" stroke=\"currentColor\" stroke-width=\"2\"><path class=\"with-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2m-6 9l2 2 4-4\"><\/path><path class=\"without-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2\"><\/path><\/svg><\/span><pre class=\"shiki github-dark\" style=\"background-color: #24292e\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #F97583\">ALTER<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #F97583\">USER<\/span><span style=\"color: #E1E4E8\"> \u2018<\/span><span style=\"color: #F97583\">&lt;<\/span><span style=\"color: #E1E4E8\">Utilisateur<\/span><span style=\"color: #F97583\">&gt;<\/span><span style=\"color: #E1E4E8\">\u2019@\u2019Host\u2019IDENTIFIED <\/span><span style=\"color: #F97583\">BY<\/span><span style=\"color: #E1E4E8\"> \u2018<\/span><span style=\"color: #F97583\">&lt;<\/span><span style=\"color: #E1E4E8\">Nouveau mot de passe<\/span><span style=\"color: #F97583\">&gt;<\/span><span style=\"color: #E1E4E8\">\u2019<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<h3 id=\"application-des-modifications\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Application_des_modifications\"><\/span>Application des modifications<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro omr-terminal\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono\" style=\"font-size:.75rem;font-family:Code-Pro-JetBrains-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;line-height:1rem;--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><span style=\"display:block;padding:16px 0 0 16px;margin-bottom:-1px;width:100%;text-align:left;background-color:#24292e\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"54\" height=\"14\" viewBox=\"0 0 54 14\"><g fill=\"none\" fill-rule=\"evenodd\" transform=\"translate(1 1)\"><circle cx=\"6\" cy=\"6\" r=\"6\" fill=\"#FF5F56\" stroke=\"#E0443E\" stroke-width=\".5\"><\/circle><circle cx=\"26\" cy=\"6\" r=\"6\" fill=\"#FFBD2E\" stroke=\"#DEA123\" stroke-width=\".5\"><\/circle><circle cx=\"46\" cy=\"6\" r=\"6\" fill=\"#27C93F\" stroke=\"#1AAB29\" stroke-width=\".5\"><\/circle><\/g><\/svg><\/span><span role=\"button\" tabindex=\"0\" style=\"color:#e1e4e8;display:none\" aria-label=\"Copy\" class=\"code-block-pro-copy-button\"><pre class=\"code-block-pro-copy-button-pre\" aria-hidden=\"true\"><textarea class=\"code-block-pro-copy-button-textarea\" tabindex=\"-1\" aria-hidden=\"true\" readonly>FLUSH PRIVILEGES;<\/textarea><\/pre><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" style=\"width:24px;height:24px\" fill=\"none\" viewBox=\"0 0 24 24\" stroke=\"currentColor\" stroke-width=\"2\"><path class=\"with-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2m-6 9l2 2 4-4\"><\/path><path class=\"without-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2\"><\/path><\/svg><\/span><pre class=\"shiki github-dark\" style=\"background-color: #24292e\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #E1E4E8\">FLUSH PRIVILEGES;<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n","protected":false},"excerpt":{"rendered":"<p>But de l\u2019article Nous allons voir dans cet article les bases pour se d\u00e9placer dans les m\u00e9andres d\u2019une base de donn\u00e9es Mysql. Pour cet article nous travaillerons sur une base de donn\u00e9es h\u00e9bergeant un site wordpress. Se connecter \u00e0 MySql Quelques r\u00e8gles de s\u00e9curit\u00e9 R\u00e9gles de base pour la connection :<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_kad_post_transparent":"","_kad_post_title":"","_kad_post_layout":"","_kad_post_sidebar_id":"","_kad_post_content_style":"","_kad_post_vertical_padding":"","_kad_post_feature":"","_kad_post_feature_position":"","_kad_post_header":false,"_kad_post_footer":false,"_kad_post_classname":"","footnotes":""},"categories":[34,35],"tags":[],"class_list":["post-1067","post","type-post","status-publish","format-standard","hentry","category-base-de-donnees","category-mysql"],"_links":{"self":[{"href":"https:\/\/communaute-omr.fr\/index.php?rest_route=\/wp\/v2\/posts\/1067","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/communaute-omr.fr\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/communaute-omr.fr\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/communaute-omr.fr\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/communaute-omr.fr\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1067"}],"version-history":[{"count":8,"href":"https:\/\/communaute-omr.fr\/index.php?rest_route=\/wp\/v2\/posts\/1067\/revisions"}],"predecessor-version":[{"id":1093,"href":"https:\/\/communaute-omr.fr\/index.php?rest_route=\/wp\/v2\/posts\/1067\/revisions\/1093"}],"wp:attachment":[{"href":"https:\/\/communaute-omr.fr\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1067"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/communaute-omr.fr\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1067"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/communaute-omr.fr\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1067"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}