{"id":2820,"date":"2022-09-29T09:59:06","date_gmt":"2022-09-29T09:59:06","guid":{"rendered":"https:\/\/www.webhi.com\/how-to\/?p=2820"},"modified":"2022-10-01T12:11:02","modified_gmt":"2022-10-01T12:11:02","slug":"autoriser-lacces-a-distance-a-une-base-de-donnees-mysql","status":"publish","type":"post","link":"https:\/\/www.webhi.com\/how-to\/fr\/autoriser-lacces-a-distance-a-une-base-de-donnees-mysql\/","title":{"rendered":"Autoriser l\u2019acc\u00e8s \u00e0 distance \u00e0 une base de donn\u00e9es MySQL"},"content":{"rendered":"\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" width=\"1200\" height=\"675\" src=\"https:\/\/www.webhi.com\/how-to\/gilrogre\/2022\/09\/mysql_remote_fr.jpg\" alt=\"Autoriser l\u2019acc\u00e8s \u00e0 distance \u00e0 MySQL MariaDB\" class=\"wp-image-2821\" srcset=\"https:\/\/www.webhi.com\/how-to\/gilrogre\/2022\/09\/mysql_remote_fr.jpg 1200w, https:\/\/www.webhi.com\/how-to\/gilrogre\/2022\/09\/mysql_remote_fr-300x169.jpg 300w, https:\/\/www.webhi.com\/how-to\/gilrogre\/2022\/09\/mysql_remote_fr-1024x576.jpg 1024w, https:\/\/www.webhi.com\/how-to\/gilrogre\/2022\/09\/mysql_remote_fr-768x432.jpg 768w, https:\/\/www.webhi.com\/how-to\/gilrogre\/2022\/09\/mysql_remote_fr-150x84.jpg 150w\" sizes=\"(max-width: 1200px) 100vw, 1200px\" \/><\/figure>\n\n\n\n<p>De nombreux sites Web et applications commencent avec le serveur web et le moteur de base de donn\u00e9es fonctionnant sur la m\u00eame machine. Une configuration comme celle-ci, peut devenir compliqu\u00e9e et difficile \u00e0 l\u2019\u00e9chelle au fil du temps. La solution est de s\u00e9parer ces fonctions et d\u2019\u00e9tablir une base de donn\u00e9es distante. Permettre au serveur et \u00e0 la base de donn\u00e9es de cro\u00eetre ind\u00e9pendamment sur leurs machines respectives.<\/p>\n\n\n\n<p>Pour activer cela, ouvrir votre fichier <kbd>mysqld.cnf<\/kbd>&nbsp;:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"bash\" class=\"language-bash\">$ sudo nano \/etc\/mysql\/mysql.conf.d\/mysqld.cnf<\/code><\/pre>\n\n\n\n<p class=\"has-text-align-center\"><kbd>ou<\/kbd><\/p>\n\n\n\n<pre class=\"wp-block-code ltr\"><code lang=\"bash\" class=\"language-bash\">$ sudo nano \/etc\/mysql\/my.cnf<\/code><\/pre>\n\n\n\n<p class=\"has-text-align-center\"><kbd>ou<\/kbd><\/p>\n\n\n\n<pre class=\"wp-block-code ltr\"><code lang=\"bash\" class=\"language-bash\">$ sudo nano \/etc\/my.cnf<\/code><\/pre>\n\n\n\n<p>Trouvez la ligne qui commence par la directive <kbd>bind-address<\/kbd>. Elle appara\u00eetra comme suit&nbsp;:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\"># If MySQL is running as a replication slave, this should be\n# changed. Ref https:\/\/dev.mysql.com\/doc\/refman\/8.0\/en\/server-system-variables.html#sysvar_tmpdir\n# tmpdir                = \/tmp\n#\n# Instead of skip-networking the default is now to listen only on\n# localhost which is more compatible and is not less secure.\nbind-address            = 127.0.0.1\nmysqlx-bind-address     = 127.0.0.1<\/pre>\n\n\n\n<p>Cette valeur est d\u00e9finie \u00e0 <kbd>127.0.0.1<\/kbd> par d\u00e9faut, ce qui signifie que le serveur ne cherchera que les connexions locales. Cette directive doit \u00eatre modifi\u00e9e pour faire r\u00e9f\u00e9rence \u00e0 une adresse IP externe. Pour le d\u00e9pannage, vous pouvez d\u00e9finir cette directive sur une adresse IP g\u00e9n\u00e9rique, telle que <kbd>*<\/kbd> ,<kbd>&nbsp;: &nbsp;: <\/kbd>, ou <kbd>0.0.0.0<\/kbd>&nbsp;:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\"># If MySQL is running as a replication slave, this should be\n# changed. Ref https:\/\/dev.mysql.com\/doc\/refman\/8.0\/en\/server-system-variables.html#sysvar_tmpdir\n# tmpdir                = \/tmp\n#\n# Instead of skip-networking the default is now to listen only on\n# localhost which is more compatible and is not less secure.\nbind-address            = 0.0.0.0<\/pre>\n\n\n\n<p>Enregistrer et fermer le fichier apr\u00e8s avoir modifi\u00e9 ce param\u00e8tre.<\/p>\n\n\n\n<p>Red\u00e9marrez ensuite le service MySQL pour appliquer les modifications apport\u00e9es \u00e0 <kbd>mysqld.cnf&nbsp;<\/kbd>:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"bash\" class=\"language-bash\">$ sudo systemctl restart mysql<\/code><\/pre>\n\n\n\n<p>Si vous avez d\u00e9j\u00e0 un compte utilisateur MySQL que vous avez l\u2019intention d\u2019utiliser pour vous connecter \u00e0 la base de donn\u00e9es \u00e0 partir d\u2019un h\u00f4te distant, vous devez reconfigurer ce compte pour vous connecter \u00e0 partir du serveur distant plut\u00f4t que <strong>localhost<\/strong>. Ouvrez le client MySQL en tant qu\u2019utilisateur principal de MySQL ou un autre compte utilisateur privil\u00e9gi\u00e9&nbsp;:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"bash\" class=\"language-bash\">$ sudo mysql<\/code><\/pre>\n\n\n\n<p>si l\u2019utilisateur root a un mot de passe, utilisez&nbsp;:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"bash\" class=\"language-bash\">$ mysql -u root -p<\/code><\/pre>\n\n\n\n<p>Avec la commande suivante, nous pouvons cr\u00e9er un nouveau compte utilisateur qui se connectera uniquement depuis l\u2019h\u00f4te distant&nbsp;:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"sql\" class=\"language-sql\">mysql&gt; CREATE USER 'bob'@'r_server_ip' IDENTIFIED BY 'password';<\/code><\/pre>\n\n\n\n<p>Ou Pour modifier l\u2019h\u00f4te d\u2019un utilisateur existant, vous pouvez utiliser MySQL&nbsp;<code>RENAME USER<\/code>&nbsp;commande. Ex\u00e9cutez la commande suivante :<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"sql\" class=\"language-sql\">mysql&gt; RENAME USER 'bob'@'localhost' TO 'bob'@'r_server_ip';<\/code><\/pre>\n\n\n\n<p>Puis, pour vos besoins sp\u00e9cifiques, attribuez au nouvel utilisateur les droits pertinents. L\u2019exemple suivant permet \u00e0 un utilisateur de CR\u00c9ER, MODIFIER et SUPPRIMER des bases de donn\u00e9es, des tables et des utilisateurs, ainsi que des donn\u00e9es INS\u00c9RER, METTRE \u00c0 JOUR et SUPPRIMER de n\u2019importe quelle table du serveur. Il permet \u00e9galement \u00e0 l\u2019utilisateur d\u2019interroger des donn\u00e9es \u00e0 l\u2019aide de SELECT, de construire des cl\u00e9s \u00e9trang\u00e8res \u00e0 l\u2019aide du mot-cl\u00e9 REFERENCES et d\u2019effectuer des op\u00e9rations FLUSH en utilisant la permission RELOAD. Cependant, vous ne devez fournir aux personnes que l\u2019acc\u00e8s dont elles ont besoin, alors n\u2019h\u00e9sitez pas \u00e0 modifier les privil\u00e8ges de votre propre utilisateur au besoin.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"sql\" class=\"language-sql\">mysql&gt; GRANT CREATE, ALTER, DROP, INSERT, UPDATE, DELETE, SELECT, REFERENCES, RELOAD on *.* TO 'bob'@'r_server_ip' WITH GRANT OPTION;<\/code><\/pre>\n\n\n\n<p>Apr\u00e8s cela, c\u2019est une bonne id\u00e9e d\u2019ex\u00e9cuter la commande <kbd>FLUSH PRIVILEGES<\/kbd>. Cela lib\u00e9rera toute m\u00e9moire mise en cache par le serveur \u00e0 la suite des pr\u00e9c\u00e9dentes instructions <kbd>CREATE USER<\/kbd> et <kbd>GRANT<\/kbd>&nbsp;:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"sql\" class=\"language-sql\">mysql&gt; FLUSH PRIVILEGES;<\/code><\/pre>\n\n\n\n<p>Le client MySQL peut alors \u00eatre ferm\u00e9&nbsp;:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"sql\" class=\"language-sql\">mysql&gt; exit;<\/code><\/pre>\n\n\n\n<p>Enfin, si un pare-feu est install\u00e9 sur votre serveur de base de donn\u00e9es, vous devez ouvrir le port 3306 \u2014 le port par d\u00e9faut de MySQL \u2014 pour permettre la communication avec MySQL.<\/p>\n\n\n\n<p>Si vous ne souhaitez vous connecter au serveur de base de donn\u00e9es qu\u2019\u00e0 partir d\u2019une seule machine, utilisez la commande suivante pour autoriser cette machine \u00e0 se connecter \u00e0 distance. Remplacez r_server_ip par l\u2019adresse IP r\u00e9elle de l\u2019ordinateur auquel vous souhaitez vous connecter&nbsp;:<\/p>\n\n\n\n<p class=\"has-text-align-center\"><kbd>UFW<\/kbd><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"bash\" class=\"language-bash\">$ sudo ufw allow from r_server_ip to any port 3306<\/code><\/pre>\n\n\n\n<p class=\"has-text-align-center\"><kbd>Iptables<\/kbd><\/p>\n\n\n\n<pre class=\"wp-block-code ltr\"><code lang=\"bash\" class=\"language-bash\">$ sudo iptables -A INPUT -p tcp -s r_server_ip --dport 3306 -j ACCEPT\n$ sudo iptables-save<\/code><\/pre>\n\n\n\n<p class=\"has-text-align-center\"><kbd>firewalld<\/kbd><\/p>\n\n\n\n<pre class=\"wp-block-code ltr\"><code lang=\"bash\" class=\"language-bash\">$ sudo firewall-cmd --permanent --zone=public --add-port=3306\/tcp<\/code><\/pre>\n\n\n\n<p>toutefois, pour permettre \u00e0 quiconque d\u2019acc\u00e9der \u00e0 votre base de donn\u00e9es MySQL en cours d\u2019utilisation&nbsp;:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"bash\" class=\"language-bash\"># UFW\n$ sudo ufw allow 3306\n\n# Iptaples\n$ sudo iptables -A INPUT -p tcp --dport 3306 -j ACCEPT<\/code><\/pre>\n\n\n\n<p>Ensuite, essayez d\u2019acc\u00e9der \u00e0 distance \u00e0 votre base de donn\u00e9es depuis une autre machine&nbsp;:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted has-background\" style=\"background-color:#e3efff\"><strong>Note:<\/strong> Si vous avez configur\u00e9 votre pare-feu pour accepter uniquement les connexions \u00e0 partir d\u2019une seule adresse IP, vous devez tenter d\u2019acc\u00e9der \u00e0 la base de donn\u00e9es en utilisant la machine associ\u00e9e \u00e0 cette adresse.<\/pre>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"bash\" class=\"language-bash\">$ mysql -u user -h db_server_ip -p<\/code><\/pre>\n\n\n\n<p>Si vous pouvez acc\u00e9der \u00e0 votre base de donn\u00e9es, cela d\u00e9montre que la directive <kbd>bind-address<\/kbd> dans votre fichier de configuration \u00e9tait la source du probl\u00e8me. Cependant, d\u00e9finir <kbd>bind-address<\/kbd> \u00e0 <kbd>0.0.0.0<\/kbd> n\u2019est pas s\u00fbr puisqu\u2019il autorise les connexions \u00e0 votre serveur depuis n\u2019importe quelle adresse IP.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>De nombreux sites Web et applications commencent avec le serveur web et le moteur de base de donn\u00e9es fonctionnant sur la m\u00eame machine. Une configuration comme celle-ci, peut devenir compliqu\u00e9e et difficile \u00e0 l\u2019\u00e9chelle au fil du temps. La solution est de s\u00e9parer ces fonctions et d\u2019\u00e9tablir une base de donn\u00e9es distante. Permettre au serveur ..<\/p>\n<div class=\"clear-fix\"><\/div>\n<p><a href=\"https:\/\/www.webhi.com\/how-to\/fr\/autoriser-lacces-a-distance-a-une-base-de-donnees-mysql\/\" title=\"read more...\">Read more<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[59,31],"tags":[],"yoast_head":"\n<title>Autoriser l\u2019acc\u00e8s \u00e0 distance \u00e0 une base de donn\u00e9es MySQL - WebHi Tutorials &amp; Documentations<\/title>\n<meta name=\"description\" content=\"Tutoriel facile pour permettre l&#039;acc\u00e8s des utilisateurs \u00e0 distance \u00e0 la base de donn\u00e9es MySQL ou MariaDB \u00e9tape par \u00e9tape. M\u00e9thode qui fonctionne sur la plupart des distributions Linux (Ubuntu, CentOS, RedHat, Debian, Fedora, Suse, ...)\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.webhi.com\/how-to\/fr\/autoriser-lacces-a-distance-a-une-base-de-donnees-mysql\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Autoriser l\u2019acc\u00e8s \u00e0 distance \u00e0 une base de donn\u00e9es MySQL - WebHi Tutorials &amp; Documentations\" \/>\n<meta property=\"og:description\" content=\"Tutoriel facile pour permettre l&#039;acc\u00e8s des utilisateurs \u00e0 distance \u00e0 la base de donn\u00e9es MySQL ou MariaDB \u00e9tape par \u00e9tape. M\u00e9thode qui fonctionne sur la plupart des distributions Linux (Ubuntu, CentOS, RedHat, Debian, Fedora, Suse, ...)\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.webhi.com\/how-to\/fr\/autoriser-lacces-a-distance-a-une-base-de-donnees-mysql\/\" \/>\n<meta property=\"og:site_name\" content=\"WebHi Tutorials &amp; Documentations\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/webhi.technology\" \/>\n<meta property=\"article:published_time\" content=\"2022-09-29T09:59:06+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-10-01T12:11:02+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.webhi.com\/how-to\/gilrogre\/2022\/09\/mysql_remote_fr.jpg\" \/>\n<meta name=\"author\" content=\"webhi\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@WebHiTechnology\" \/>\n<meta name=\"twitter:site\" content=\"@WebHiTechnology\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"webhi\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"TechArticle\",\"@id\":\"https:\/\/www.webhi.com\/how-to\/fr\/autoriser-lacces-a-distance-a-une-base-de-donnees-mysql\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.webhi.com\/how-to\/fr\/autoriser-lacces-a-distance-a-une-base-de-donnees-mysql\/\"},\"author\":{\"name\":\"webhi\",\"@id\":\"https:\/\/www.webhi.com\/how-to\/#\/schema\/person\/b31e76e2311cdc0bb90f5e2733059a54\"},\"headline\":\"Autoriser l\u2019acc\u00e8s \u00e0 distance \u00e0 une base de donn\u00e9es MySQL\",\"datePublished\":\"2022-09-29T09:59:06+00:00\",\"dateModified\":\"2022-10-01T12:11:02+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.webhi.com\/how-to\/fr\/autoriser-lacces-a-distance-a-une-base-de-donnees-mysql\/\"},\"wordCount\":655,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.webhi.com\/how-to\/#organization\"},\"articleSection\":[\"Bases de donn\u00e9es\",\"S\u00e9curit\u00e9\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.webhi.com\/how-to\/fr\/autoriser-lacces-a-distance-a-une-base-de-donnees-mysql\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.webhi.com\/how-to\/fr\/autoriser-lacces-a-distance-a-une-base-de-donnees-mysql\/\",\"url\":\"https:\/\/www.webhi.com\/how-to\/fr\/autoriser-lacces-a-distance-a-une-base-de-donnees-mysql\/\",\"name\":\"Autoriser l\u2019acc\u00e8s \u00e0 distance \u00e0 une base de donn\u00e9es MySQL - WebHi Tutorials &amp; Documentations\",\"isPartOf\":{\"@id\":\"https:\/\/www.webhi.com\/how-to\/#website\"},\"datePublished\":\"2022-09-29T09:59:06+00:00\",\"dateModified\":\"2022-10-01T12:11:02+00:00\",\"description\":\"Tutoriel facile pour permettre l'acc\u00e8s des utilisateurs \u00e0 distance \u00e0 la base de donn\u00e9es MySQL ou MariaDB \u00e9tape par \u00e9tape. M\u00e9thode qui fonctionne sur la plupart des distributions Linux (Ubuntu, CentOS, RedHat, Debian, Fedora, Suse, ...)\",\"breadcrumb\":{\"@id\":\"https:\/\/www.webhi.com\/how-to\/fr\/autoriser-lacces-a-distance-a-une-base-de-donnees-mysql\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.webhi.com\/how-to\/fr\/autoriser-lacces-a-distance-a-une-base-de-donnees-mysql\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.webhi.com\/how-to\/fr\/autoriser-lacces-a-distance-a-une-base-de-donnees-mysql\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.webhi.com\/how-to\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Autoriser l\u2019acc\u00e8s \u00e0 distance \u00e0 une base de donn\u00e9es MySQL\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.webhi.com\/how-to\/#website\",\"url\":\"https:\/\/www.webhi.com\/how-to\/\",\"name\":\"WebHi Tutorials &amp; Documentations\",\"description\":\"System administration and knowledge base\",\"publisher\":{\"@id\":\"https:\/\/www.webhi.com\/how-to\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.webhi.com\/how-to\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.webhi.com\/how-to\/#organization\",\"name\":\"WebHi Technology\",\"url\":\"https:\/\/www.webhi.com\/how-to\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.webhi.com\/how-to\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.webhi.com\/how-to\/gilrogre\/2022\/07\/logo.png\",\"contentUrl\":\"https:\/\/www.webhi.com\/how-to\/gilrogre\/2022\/07\/logo.png\",\"width\":288,\"height\":95,\"caption\":\"WebHi Technology\"},\"image\":{\"@id\":\"https:\/\/www.webhi.com\/how-to\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/webhi.technology\",\"https:\/\/twitter.com\/WebHiTechnology\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.webhi.com\/how-to\/#\/schema\/person\/b31e76e2311cdc0bb90f5e2733059a54\",\"name\":\"webhi\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.webhi.com\/how-to\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/www.webhi.com\/how-to\/ahuphiph\/litespeed\/avatar\/e20da107d0f4c765ead2eef88ad019d8.jpg?ver=1780005063\",\"contentUrl\":\"https:\/\/www.webhi.com\/how-to\/ahuphiph\/litespeed\/avatar\/e20da107d0f4c765ead2eef88ad019d8.jpg?ver=1780005063\",\"caption\":\"webhi\"},\"sameAs\":[\"https:\/\/www.webhi.com\/how-to\"],\"url\":\"https:\/\/www.webhi.com\/how-to\/author\/webhi\/\"}]}<\/script>\n","yoast_head_json":{"title":"Autoriser l\u2019acc\u00e8s \u00e0 distance \u00e0 une base de donn\u00e9es MySQL - WebHi Tutorials &amp; Documentations","description":"Tutoriel facile pour permettre l'acc\u00e8s des utilisateurs \u00e0 distance \u00e0 la base de donn\u00e9es MySQL ou MariaDB \u00e9tape par \u00e9tape. M\u00e9thode qui fonctionne sur la plupart des distributions Linux (Ubuntu, CentOS, RedHat, Debian, Fedora, Suse, ...)","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.webhi.com\/how-to\/fr\/autoriser-lacces-a-distance-a-une-base-de-donnees-mysql\/","og_locale":"en_US","og_type":"article","og_title":"Autoriser l\u2019acc\u00e8s \u00e0 distance \u00e0 une base de donn\u00e9es MySQL - WebHi Tutorials &amp; Documentations","og_description":"Tutoriel facile pour permettre l'acc\u00e8s des utilisateurs \u00e0 distance \u00e0 la base de donn\u00e9es MySQL ou MariaDB \u00e9tape par \u00e9tape. M\u00e9thode qui fonctionne sur la plupart des distributions Linux (Ubuntu, CentOS, RedHat, Debian, Fedora, Suse, ...)","og_url":"https:\/\/www.webhi.com\/how-to\/fr\/autoriser-lacces-a-distance-a-une-base-de-donnees-mysql\/","og_site_name":"WebHi Tutorials &amp; Documentations","article_publisher":"https:\/\/www.facebook.com\/webhi.technology","article_published_time":"2022-09-29T09:59:06+00:00","article_modified_time":"2022-10-01T12:11:02+00:00","og_image":[{"url":"https:\/\/www.webhi.com\/how-to\/gilrogre\/2022\/09\/mysql_remote_fr.jpg"}],"author":"webhi","twitter_card":"summary_large_image","twitter_creator":"@WebHiTechnology","twitter_site":"@WebHiTechnology","twitter_misc":{"Written by":"webhi","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"TechArticle","@id":"https:\/\/www.webhi.com\/how-to\/fr\/autoriser-lacces-a-distance-a-une-base-de-donnees-mysql\/#article","isPartOf":{"@id":"https:\/\/www.webhi.com\/how-to\/fr\/autoriser-lacces-a-distance-a-une-base-de-donnees-mysql\/"},"author":{"name":"webhi","@id":"https:\/\/www.webhi.com\/how-to\/#\/schema\/person\/b31e76e2311cdc0bb90f5e2733059a54"},"headline":"Autoriser l\u2019acc\u00e8s \u00e0 distance \u00e0 une base de donn\u00e9es MySQL","datePublished":"2022-09-29T09:59:06+00:00","dateModified":"2022-10-01T12:11:02+00:00","mainEntityOfPage":{"@id":"https:\/\/www.webhi.com\/how-to\/fr\/autoriser-lacces-a-distance-a-une-base-de-donnees-mysql\/"},"wordCount":655,"commentCount":0,"publisher":{"@id":"https:\/\/www.webhi.com\/how-to\/#organization"},"articleSection":["Bases de donn\u00e9es","S\u00e9curit\u00e9"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.webhi.com\/how-to\/fr\/autoriser-lacces-a-distance-a-une-base-de-donnees-mysql\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.webhi.com\/how-to\/fr\/autoriser-lacces-a-distance-a-une-base-de-donnees-mysql\/","url":"https:\/\/www.webhi.com\/how-to\/fr\/autoriser-lacces-a-distance-a-une-base-de-donnees-mysql\/","name":"Autoriser l\u2019acc\u00e8s \u00e0 distance \u00e0 une base de donn\u00e9es MySQL - WebHi Tutorials &amp; Documentations","isPartOf":{"@id":"https:\/\/www.webhi.com\/how-to\/#website"},"datePublished":"2022-09-29T09:59:06+00:00","dateModified":"2022-10-01T12:11:02+00:00","description":"Tutoriel facile pour permettre l'acc\u00e8s des utilisateurs \u00e0 distance \u00e0 la base de donn\u00e9es MySQL ou MariaDB \u00e9tape par \u00e9tape. M\u00e9thode qui fonctionne sur la plupart des distributions Linux (Ubuntu, CentOS, RedHat, Debian, Fedora, Suse, ...)","breadcrumb":{"@id":"https:\/\/www.webhi.com\/how-to\/fr\/autoriser-lacces-a-distance-a-une-base-de-donnees-mysql\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.webhi.com\/how-to\/fr\/autoriser-lacces-a-distance-a-une-base-de-donnees-mysql\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.webhi.com\/how-to\/fr\/autoriser-lacces-a-distance-a-une-base-de-donnees-mysql\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.webhi.com\/how-to\/"},{"@type":"ListItem","position":2,"name":"Autoriser l\u2019acc\u00e8s \u00e0 distance \u00e0 une base de donn\u00e9es MySQL"}]},{"@type":"WebSite","@id":"https:\/\/www.webhi.com\/how-to\/#website","url":"https:\/\/www.webhi.com\/how-to\/","name":"WebHi Tutorials &amp; Documentations","description":"System administration and knowledge base","publisher":{"@id":"https:\/\/www.webhi.com\/how-to\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.webhi.com\/how-to\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.webhi.com\/how-to\/#organization","name":"WebHi Technology","url":"https:\/\/www.webhi.com\/how-to\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.webhi.com\/how-to\/#\/schema\/logo\/image\/","url":"https:\/\/www.webhi.com\/how-to\/gilrogre\/2022\/07\/logo.png","contentUrl":"https:\/\/www.webhi.com\/how-to\/gilrogre\/2022\/07\/logo.png","width":288,"height":95,"caption":"WebHi Technology"},"image":{"@id":"https:\/\/www.webhi.com\/how-to\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/webhi.technology","https:\/\/twitter.com\/WebHiTechnology"]},{"@type":"Person","@id":"https:\/\/www.webhi.com\/how-to\/#\/schema\/person\/b31e76e2311cdc0bb90f5e2733059a54","name":"webhi","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.webhi.com\/how-to\/#\/schema\/person\/image\/","url":"https:\/\/www.webhi.com\/how-to\/ahuphiph\/litespeed\/avatar\/e20da107d0f4c765ead2eef88ad019d8.jpg?ver=1780005063","contentUrl":"https:\/\/www.webhi.com\/how-to\/ahuphiph\/litespeed\/avatar\/e20da107d0f4c765ead2eef88ad019d8.jpg?ver=1780005063","caption":"webhi"},"sameAs":["https:\/\/www.webhi.com\/how-to"],"url":"https:\/\/www.webhi.com\/how-to\/author\/webhi\/"}]}},"_links":{"self":[{"href":"https:\/\/www.webhi.com\/how-to\/wp-json\/wp\/v2\/posts\/2820"}],"collection":[{"href":"https:\/\/www.webhi.com\/how-to\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.webhi.com\/how-to\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.webhi.com\/how-to\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.webhi.com\/how-to\/wp-json\/wp\/v2\/comments?post=2820"}],"version-history":[{"count":14,"href":"https:\/\/www.webhi.com\/how-to\/wp-json\/wp\/v2\/posts\/2820\/revisions"}],"predecessor-version":[{"id":2883,"href":"https:\/\/www.webhi.com\/how-to\/wp-json\/wp\/v2\/posts\/2820\/revisions\/2883"}],"wp:attachment":[{"href":"https:\/\/www.webhi.com\/how-to\/wp-json\/wp\/v2\/media?parent=2820"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.webhi.com\/how-to\/wp-json\/wp\/v2\/categories?post=2820"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.webhi.com\/how-to\/wp-json\/wp\/v2\/tags?post=2820"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}