{"id":49,"date":"2015-11-28T10:35:56","date_gmt":"2015-11-28T09:35:56","guid":{"rendered":"https:\/\/blog.veldrin.fr\/?p=49"},"modified":"2021-11-18T18:07:26","modified_gmt":"2021-11-18T17:07:26","slug":"error-access-denied-for-user-debian-sys-maintlocalhost-using-password-yes","status":"publish","type":"post","link":"https:\/\/blog.veldrin.fr\/?p=49","title":{"rendered":"error: &lsquo;Access denied for user &lsquo;debian-sys-maint&rsquo;@&rsquo;localhost&rsquo; (using password: YES)&rsquo;"},"content":{"rendered":"<p>R\u00e9installation du serveur, et un message vient m&rsquo;ennuyer \u00e0 chaque commandes \u00ab\u00a0service mysql\u00a0\u00bb. En effet Debian utilise un utilisateur sp\u00e9cial pour toute ses interaction avec le service Mysql.<\/p>\n<p>Nous retrouvons donc les information dans le fichier de conf \/etc\/mysql\/debian.conf<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"shell\"># Automatically generated for Debian scripts. DO NOT TOUCH!\r\n[client]\r\nhost = localhost\r\nuser = debian-sys-maint\r\npassword = mot de passe al\u00e9atoire\r\nsocket = \/var\/run\/mysqld\/mysqld.sock\r\n[mysql_upgrade]\r\nhost = localhost\r\nuser = debian-sys-maint\r\npassword = mot de passe al\u00e9atoire\r\nsocket = \/var\/run\/mysqld\/mysqld.sock\r\nbasedir = \/usr<\/pre>\n<p>Nous prenons donc notre \u00ab\u00a0mot de passe al\u00e9atoire\u00a0\u00bb et nous allons le red\u00e9finir dans les privil\u00e8ges MYSQL afin de synchroniser le user avec le syst\u00e8me : Tadaaaa !<\/p>\n","protected":false},"excerpt":{"rendered":"<p>R\u00e9installation du serveur, et un message vient m&rsquo;ennuyer \u00e0 chaque commandes \u00ab\u00a0service mysql\u00a0\u00bb. En effet Debian utilise un utilisateur sp\u00e9cial pour toute ses interaction avec le service Mysql. Nous retrouvons donc les information dans le fichier de conf \/etc\/mysql\/debian.conf # Automatically generated for Debian scripts. DO NOT TOUCH! [client] host = localhost user = debian-sys-maint &hellip; <\/p>\n<p class=\"link-more\"><a href=\"https:\/\/blog.veldrin.fr\/?p=49\" class=\"more-link\">Continuer la lecture<span class=\"screen-reader-text\"> de &laquo;&nbsp;error: &lsquo;Access denied for user &lsquo;debian-sys-maint&rsquo;@&rsquo;localhost&rsquo; (using password: YES)&rsquo;&nbsp;&raquo;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[2,5,8,7],"class_list":["post-49","post","type-post","status-publish","format-standard","hentry","category-linuxdebian6","tag-debian-6","tag-linux","tag-mysql","tag-squeeze"],"_links":{"self":[{"href":"https:\/\/blog.veldrin.fr\/index.php?rest_route=\/wp\/v2\/posts\/49","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.veldrin.fr\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.veldrin.fr\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.veldrin.fr\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.veldrin.fr\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=49"}],"version-history":[{"count":2,"href":"https:\/\/blog.veldrin.fr\/index.php?rest_route=\/wp\/v2\/posts\/49\/revisions"}],"predecessor-version":[{"id":90,"href":"https:\/\/blog.veldrin.fr\/index.php?rest_route=\/wp\/v2\/posts\/49\/revisions\/90"}],"wp:attachment":[{"href":"https:\/\/blog.veldrin.fr\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=49"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.veldrin.fr\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=49"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.veldrin.fr\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=49"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}