{"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-14T12:46:06","modified_gmt":"2026-07-14T10:46:06","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<pre class=\"wp-block-code omr-terminal\"><code>mysql -u &lt;Utilisateur&gt; -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)]&gt;<\/code><\/pre>\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<pre class=\"wp-block-code omr-terminal\"><code>mysql -h &lt;Serveur distant&gt; -u &lt;Utilisateur&gt; -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)]&gt;<\/code><\/pre>\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<pre class=\"wp-block-code omr-terminal\"><code>MariaDB &#91;(none)]&gt; SHOW GLOBAL VARIABLES;\n+----------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+\n| Variable_name                                            | Value                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          |\n+----------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+\n| allow_suspicious_udfs                                    | OFF                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            |\n| alter_algorithm                                          | DEFAULT                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        |\n| analyze_max_length                                       | 4294967295<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\u2026<\/p>\n\n\n\n<pre class=\"wp-block-code omr-terminal\"><code>|\n| wsrep_trx_fragment_size                                  | 0                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              |\n| wsrep_trx_fragment_unit                                  | bytes                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          |\n+----------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+\n655 rows in set (0,001 sec)<\/code><\/pre>\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<pre class=\"wp-block-code omr-terminal\"><code>MariaDB &#91;(none)]&gt; 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<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\u2026<\/p>\n\n\n\n<pre class=\"wp-block-code omr-terminal\"><code>*************************** 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)<\/code><\/pre>\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<pre class=\"wp-block-code omr-terminal\"><code>SHOW GLOBAL VARIABLES LIKE 'Nom Variable';<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Par exemple&nbsp;:<\/p>\n\n\n\n<pre class=\"wp-block-code omr-terminal\"><code>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)<\/code><\/pre>\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<pre class=\"wp-block-code omr-terminal\"><code>Show databases&nbsp;;\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)<\/code><\/pre>\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<pre class=\"wp-block-code omr-terminal\"><code>Use &lt;nom database&gt;&nbsp;;<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Par exemple&nbsp;:<\/p>\n\n\n\n<pre class=\"wp-block-code omr-terminal\"><code>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]&gt;<\/code><\/pre>\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<pre class=\"wp-block-code omr-terminal\"><code>MariaDB &#91;mysql]&gt; 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)<\/code><\/pre>\n\n\n\n<h2 id=\"information-sur-la-table\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Information_sur_la_table\"><\/span>Information sur la table<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<pre class=\"wp-block-code omr-terminal\"><code>MariaDB &#91;mysql]&gt; 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)<\/code><\/pre>\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<pre class=\"wp-block-code omr-terminal\"><code>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)<\/code><\/pre>\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<pre class=\"wp-block-code omr-terminal\"><code>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+---------------------------------------------------------------------------------------------------------------------------------+<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Et mon utilisateur :<\/p>\n\n\n\n<pre class=\"wp-block-code omr-terminal\"><code>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)<\/code><\/pre>\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<pre class=\"wp-block-code omr-terminal\"><code>CREATE USER \u2018&lt;Utilisateur&gt;\u2019@\u2019Host\u2019 IDENTIFIED BY \u2018&lt;Mot de passe&gt;\u2019;<\/code><\/pre>\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\n\n\n<li>Droits restreints<\/li>\n<\/ul>\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<pre class=\"wp-block-code omr-terminal\"><code>ALTER USER \u2018&lt;Utilisateur&gt;\u2019@\u2019Host\u2019IDENTIFIED BY \u2018&lt;Nouveau mot de passe&gt;\u2019<\/code><\/pre>\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<pre class=\"wp-block-code omr-terminal\"><code>FLUSH PRIVILEGES;<\/code><\/pre>\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":{"_uag_custom_page_level_css":"","_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"],"uagb_featured_image_src":{"full":false,"thumbnail":false,"medium":false,"medium_large":false,"large":false,"1536x1536":false,"2048x2048":false},"uagb_author_info":{"display_name":"admin","author_link":"https:\/\/communaute-omr.fr\/?author=1"},"uagb_comment_info":0,"uagb_excerpt":"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 :","_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":6,"href":"https:\/\/communaute-omr.fr\/index.php?rest_route=\/wp\/v2\/posts\/1067\/revisions"}],"predecessor-version":[{"id":1078,"href":"https:\/\/communaute-omr.fr\/index.php?rest_route=\/wp\/v2\/posts\/1067\/revisions\/1078"}],"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}]}}