{"id":174,"date":"2020-01-04T18:26:25","date_gmt":"2020-01-04T17:26:25","guid":{"rendered":"https:\/\/www.delixirpro.com\/blog\/?p=174"},"modified":"2020-01-04T18:26:27","modified_gmt":"2020-01-04T17:26:27","slug":"mariadb-access-denied-for-user-rootlocalhost","status":"publish","type":"post","link":"https:\/\/www.delixirpro.com\/blog\/2020\/01\/04\/mariadb-access-denied-for-user-rootlocalhost\/","title":{"rendered":"MariaDB : Access denied for user \u2018root\u2019@\u2019localhost\u2019"},"content":{"rendered":"\n<p>Juste apr\u00e8s l\u2019installation de MariaDB sous Ubuntu\/Debian, cette erreur peut appara\u00eetre si l\u2019on essaie de connecter avec phpMyadmin.<\/p>\n\n\n\n<p>Voici comment contourner le probl\u00e8me.<\/p>\n\n\n\n<p>1. Ouvrir une connexion en SSH sur le serveur.<\/p>\n\n\n\n<p>2. Entrer les commandes suivantes :<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">mysql\nCREATE USER 'admin'@'%' IDENTIFIED BY 'mot_de_passe';\nGRANT ALL PRIVILEGES ON *.* TO 'admin'@'%' WITH GRANT OPTION;\nFLUSH PRIVILEGES;\nexit;<\/pre>\n\n\n\n<p>3. Red\u00e9marrer le service MariaDB.<\/p>\n\n\n\n<p>Source :  <a href=\"https:\/\/rdr-it.com\/mariadb-access-denied-for-user-rootlocalhost\/\">https:\/\/rdr-it.com\/mariadb-access-denied-for-user-rootlocalhost\/<\/a> <\/p>\n","protected":false},"excerpt":{"rendered":"<p>Juste apr\u00e8s l\u2019installation de MariaDB sous Ubuntu\/Debian, cette erreur peut appara\u00eetre si l\u2019on essaie de connecter avec phpMyadmin. Voici comment contourner le probl\u00e8me. 1. Ouvrir une connexion en SSH sur le serveur. 2. Entrer&#46;&#46;&#46;<\/p>\n","protected":false},"author":1,"featured_media":175,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8],"tags":[17,16],"class_list":["post-174","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-tech-tips","tag-access-denied","tag-mariadb"],"_links":{"self":[{"href":"https:\/\/www.delixirpro.com\/blog\/wp-json\/wp\/v2\/posts\/174","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.delixirpro.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.delixirpro.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.delixirpro.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.delixirpro.com\/blog\/wp-json\/wp\/v2\/comments?post=174"}],"version-history":[{"count":1,"href":"https:\/\/www.delixirpro.com\/blog\/wp-json\/wp\/v2\/posts\/174\/revisions"}],"predecessor-version":[{"id":176,"href":"https:\/\/www.delixirpro.com\/blog\/wp-json\/wp\/v2\/posts\/174\/revisions\/176"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.delixirpro.com\/blog\/wp-json\/wp\/v2\/media\/175"}],"wp:attachment":[{"href":"https:\/\/www.delixirpro.com\/blog\/wp-json\/wp\/v2\/media?parent=174"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.delixirpro.com\/blog\/wp-json\/wp\/v2\/categories?post=174"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.delixirpro.com\/blog\/wp-json\/wp\/v2\/tags?post=174"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}