{"id":39,"date":"2007-05-14T21:31:38","date_gmt":"2007-05-14T19:31:38","guid":{"rendered":"http:\/\/michauko.org\/blog\/2007\/05\/14\/installer-une-base-de-donnees-mysql-sous-debian\/"},"modified":"2009-10-08T15:31:15","modified_gmt":"2009-10-08T13:31:15","slug":"installer-une-base-de-donnees-mysql-sous-debian","status":"publish","type":"post","link":"https:\/\/michauko.org\/blog\/installer-une-base-de-donnees-mysql-sous-debian-39\/","title":{"rendered":"Installer une base de donn\u00e9es MySQL sous Debian"},"content":{"rendered":"<p>Ce chapitre fait partie d&rsquo;une s\u00e9rie, issu de <a href=\"https:\/\/michauko.org\/docs\/debian_testing\/\">ma documentation Debian<\/a> et extrait histoire d&rsquo;all\u00e9ger cette doc.<br \/>\nIl servait d&rsquo;\u00e9tape \u00e0 l&rsquo;installation du logiciel <a href=\"http:\/\/gallery.menalto.com\/\">Gallery2<\/a>.<br \/>\nJe recopie tel quel.<\/p>\n<p>Voici la proc\u00e9dure basique pour cr\u00e9er une base vide et prot\u00e9ger l&rsquo;acc\u00e8s root par un mot de passe.<br \/>\nC&rsquo;est une base obligatoire pour installer d&rsquo;autres logiciels qui utilisent MySQL, qu&rsquo;ils soient ou non \u00ab\u00a0packag\u00e9s\u00a0\u00bb Debian.<!--more--><\/p>\n<p>Le principe est simple :<\/p>\n<pre>apt-get install mysql-server mysql-client<\/pre>\n<p>En fin de manipulation, vous pourrez vous connecter \u00e0 la base MySQL pour contr\u00f4ler que tout est ok :<\/p>\n<pre>etchrulz:~# mysql -u root\r\nWelcome to the MySQL monitor.  Commands end with ; or \\g.\r\nYour MySQL connection id is 5 to server version: 4.1.14-Debian_6-log\r\n\r\nType 'help;' or '\\h' for help. Type '\\c' to clear the buffer.\r\n\r\nmysql> show databases;\r\n+----------+\r\n| Database |\r\n+----------+\r\n| mysql    |\r\n| test     |\r\n+----------+\r\n2 rows in set (0.00 sec)\r\n\r\nmysql> quit\r\nBye<\/pre>\n<p>Afin de prot\u00e9ger votre base de donn\u00e9es, on cr\u00e9e un password au compte root. Notez que le compte root de la base n&rsquo;a rien \u00e0 voir avec le compte root de votre Linux :<\/p>\n<pre>mysql -u root<\/pre>\n<p>puis :<\/p>\n<pre>SET PASSWORD FOR 'root@localhost' = PASSWORD('mon_mot_de_passe_en_clair');\r\nFLUSH PRIVILEGES;\r\nquit;<\/pre>\n<p>Ensuite, pour vous connecter \u00e0 la base, comme le \u00ab root@localhost \u00bb poss\u00e8de maintenant un mot de passe, il vous faudra pr\u00e9ciser \u00ab -p \u00bb sur la ligne de commande pour qu&rsquo;il demande ce mot de passe. V\u00e9rifiez.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Ce chapitre fait partie d&rsquo;une s\u00e9rie, issu de ma documentation Debian et extrait histoire d&rsquo;all\u00e9ger cette doc. Il servait d&rsquo;\u00e9tape \u00e0 l&rsquo;installation du logiciel Gallery2. Je recopie tel quel. Voici la proc\u00e9dure basique pour cr\u00e9er &hellip;<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_crdt_document":"","_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[2,387,82],"tags":[],"class_list":["post-39","post","type-post","status-publish","format-standard","hentry","category-debian","category-ligne-de-commande","category-pl"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Installer une base de donn\u00e9es MySQL sous Debian - Le blog de Michauko<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/michauko.org\/blog\/installer-une-base-de-donnees-mysql-sous-debian-39\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Installer une base de donn\u00e9es MySQL sous Debian - Le blog de Michauko\" \/>\n<meta property=\"og:description\" content=\"Ce chapitre fait partie d&rsquo;une s\u00e9rie, issu de ma documentation Debian et extrait histoire d&rsquo;all\u00e9ger cette doc. Il servait d&rsquo;\u00e9tape \u00e0 l&rsquo;installation du logiciel Gallery2. Je recopie tel quel. Voici la proc\u00e9dure basique pour cr\u00e9er &hellip;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/michauko.org\/blog\/installer-une-base-de-donnees-mysql-sous-debian-39\/\" \/>\n<meta property=\"og:site_name\" content=\"Le blog de Michauko\" \/>\n<meta property=\"article:published_time\" content=\"2007-05-14T19:31:38+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2009-10-08T13:31:15+00:00\" \/>\n<meta name=\"author\" content=\"michauko\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u00c9crit par\" \/>\n\t<meta name=\"twitter:data1\" content=\"michauko\" \/>\n\t<meta name=\"twitter:label2\" content=\"Dur\u00e9e de lecture estim\u00e9e\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/michauko.org\\\/blog\\\/installer-une-base-de-donnees-mysql-sous-debian-39\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/michauko.org\\\/blog\\\/installer-une-base-de-donnees-mysql-sous-debian-39\\\/\"},\"author\":{\"name\":\"michauko\",\"@id\":\"https:\\\/\\\/michauko.org\\\/blog\\\/#\\\/schema\\\/person\\\/0cd9f3d9ce4dccc05df81a5b27051ea9\"},\"headline\":\"Installer une base de donn\u00e9es MySQL sous Debian\",\"datePublished\":\"2007-05-14T19:31:38+00:00\",\"dateModified\":\"2009-10-08T13:31:15+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/michauko.org\\\/blog\\\/installer-une-base-de-donnees-mysql-sous-debian-39\\\/\"},\"wordCount\":184,\"commentCount\":0,\"articleSection\":[\"Debian\",\"ligne de commande\",\"planet-libre.org\"],\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/michauko.org\\\/blog\\\/installer-une-base-de-donnees-mysql-sous-debian-39\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/michauko.org\\\/blog\\\/installer-une-base-de-donnees-mysql-sous-debian-39\\\/\",\"url\":\"https:\\\/\\\/michauko.org\\\/blog\\\/installer-une-base-de-donnees-mysql-sous-debian-39\\\/\",\"name\":\"Installer une base de donn\u00e9es MySQL sous Debian - Le blog de Michauko\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/michauko.org\\\/blog\\\/#website\"},\"datePublished\":\"2007-05-14T19:31:38+00:00\",\"dateModified\":\"2009-10-08T13:31:15+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/michauko.org\\\/blog\\\/#\\\/schema\\\/person\\\/0cd9f3d9ce4dccc05df81a5b27051ea9\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/michauko.org\\\/blog\\\/installer-une-base-de-donnees-mysql-sous-debian-39\\\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/michauko.org\\\/blog\\\/installer-une-base-de-donnees-mysql-sous-debian-39\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/michauko.org\\\/blog\\\/installer-une-base-de-donnees-mysql-sous-debian-39\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\\\/\\\/michauko.org\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Installer une base de donn\u00e9es MySQL sous Debian\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/michauko.org\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/michauko.org\\\/blog\\\/\",\"name\":\"Le blog de Michauko\",\"description\":\"Si tu ne comprends pas le titre de l&#039;article, passe ton chemin\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/michauko.org\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"fr-FR\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/michauko.org\\\/blog\\\/#\\\/schema\\\/person\\\/0cd9f3d9ce4dccc05df81a5b27051ea9\",\"name\":\"michauko\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/5c3a8969c185fd0eef3893a15408f3ef1b36a6681a066b1eb32045643c30ba65?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/5c3a8969c185fd0eef3893a15408f3ef1b36a6681a066b1eb32045643c30ba65?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/5c3a8969c185fd0eef3893a15408f3ef1b36a6681a066b1eb32045643c30ba65?s=96&d=mm&r=g\",\"caption\":\"michauko\"},\"sameAs\":[\"http:\\\/\\\/michauko.org\\\/\"],\"url\":\"https:\\\/\\\/michauko.org\\\/blog\\\/author\\\/randomized2\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Installer une base de donn\u00e9es MySQL sous Debian - Le blog de Michauko","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:\/\/michauko.org\/blog\/installer-une-base-de-donnees-mysql-sous-debian-39\/","og_locale":"fr_FR","og_type":"article","og_title":"Installer une base de donn\u00e9es MySQL sous Debian - Le blog de Michauko","og_description":"Ce chapitre fait partie d&rsquo;une s\u00e9rie, issu de ma documentation Debian et extrait histoire d&rsquo;all\u00e9ger cette doc. Il servait d&rsquo;\u00e9tape \u00e0 l&rsquo;installation du logiciel Gallery2. Je recopie tel quel. Voici la proc\u00e9dure basique pour cr\u00e9er &hellip;","og_url":"https:\/\/michauko.org\/blog\/installer-une-base-de-donnees-mysql-sous-debian-39\/","og_site_name":"Le blog de Michauko","article_published_time":"2007-05-14T19:31:38+00:00","article_modified_time":"2009-10-08T13:31:15+00:00","author":"michauko","twitter_card":"summary_large_image","twitter_misc":{"\u00c9crit par":"michauko","Dur\u00e9e de lecture estim\u00e9e":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/michauko.org\/blog\/installer-une-base-de-donnees-mysql-sous-debian-39\/#article","isPartOf":{"@id":"https:\/\/michauko.org\/blog\/installer-une-base-de-donnees-mysql-sous-debian-39\/"},"author":{"name":"michauko","@id":"https:\/\/michauko.org\/blog\/#\/schema\/person\/0cd9f3d9ce4dccc05df81a5b27051ea9"},"headline":"Installer une base de donn\u00e9es MySQL sous Debian","datePublished":"2007-05-14T19:31:38+00:00","dateModified":"2009-10-08T13:31:15+00:00","mainEntityOfPage":{"@id":"https:\/\/michauko.org\/blog\/installer-une-base-de-donnees-mysql-sous-debian-39\/"},"wordCount":184,"commentCount":0,"articleSection":["Debian","ligne de commande","planet-libre.org"],"inLanguage":"fr-FR","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/michauko.org\/blog\/installer-une-base-de-donnees-mysql-sous-debian-39\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/michauko.org\/blog\/installer-une-base-de-donnees-mysql-sous-debian-39\/","url":"https:\/\/michauko.org\/blog\/installer-une-base-de-donnees-mysql-sous-debian-39\/","name":"Installer une base de donn\u00e9es MySQL sous Debian - Le blog de Michauko","isPartOf":{"@id":"https:\/\/michauko.org\/blog\/#website"},"datePublished":"2007-05-14T19:31:38+00:00","dateModified":"2009-10-08T13:31:15+00:00","author":{"@id":"https:\/\/michauko.org\/blog\/#\/schema\/person\/0cd9f3d9ce4dccc05df81a5b27051ea9"},"breadcrumb":{"@id":"https:\/\/michauko.org\/blog\/installer-une-base-de-donnees-mysql-sous-debian-39\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/michauko.org\/blog\/installer-une-base-de-donnees-mysql-sous-debian-39\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/michauko.org\/blog\/installer-une-base-de-donnees-mysql-sous-debian-39\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/michauko.org\/blog\/"},{"@type":"ListItem","position":2,"name":"Installer une base de donn\u00e9es MySQL sous Debian"}]},{"@type":"WebSite","@id":"https:\/\/michauko.org\/blog\/#website","url":"https:\/\/michauko.org\/blog\/","name":"Le blog de Michauko","description":"Si tu ne comprends pas le titre de l&#039;article, passe ton chemin","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/michauko.org\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"fr-FR"},{"@type":"Person","@id":"https:\/\/michauko.org\/blog\/#\/schema\/person\/0cd9f3d9ce4dccc05df81a5b27051ea9","name":"michauko","image":{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/secure.gravatar.com\/avatar\/5c3a8969c185fd0eef3893a15408f3ef1b36a6681a066b1eb32045643c30ba65?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/5c3a8969c185fd0eef3893a15408f3ef1b36a6681a066b1eb32045643c30ba65?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/5c3a8969c185fd0eef3893a15408f3ef1b36a6681a066b1eb32045643c30ba65?s=96&d=mm&r=g","caption":"michauko"},"sameAs":["http:\/\/michauko.org\/"],"url":"https:\/\/michauko.org\/blog\/author\/randomized2\/"}]}},"_links":{"self":[{"href":"https:\/\/michauko.org\/blog\/wp-json\/wp\/v2\/posts\/39","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/michauko.org\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/michauko.org\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/michauko.org\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/michauko.org\/blog\/wp-json\/wp\/v2\/comments?post=39"}],"version-history":[{"count":2,"href":"https:\/\/michauko.org\/blog\/wp-json\/wp\/v2\/posts\/39\/revisions"}],"predecessor-version":[{"id":810,"href":"https:\/\/michauko.org\/blog\/wp-json\/wp\/v2\/posts\/39\/revisions\/810"}],"wp:attachment":[{"href":"https:\/\/michauko.org\/blog\/wp-json\/wp\/v2\/media?parent=39"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/michauko.org\/blog\/wp-json\/wp\/v2\/categories?post=39"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/michauko.org\/blog\/wp-json\/wp\/v2\/tags?post=39"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}