{"id":262,"date":"2015-07-15T07:23:55","date_gmt":"2015-07-15T07:23:55","guid":{"rendered":"http:\/\/192.168.1.32\/?p=262"},"modified":"2023-02-07T15:50:44","modified_gmt":"2023-02-07T15:50:44","slug":"reset-du-mot-de-passe-debian-sys-maint","status":"publish","type":"post","link":"https:\/\/tty.tartux.net\/?p=262","title":{"rendered":"Reset du mot de passe debian-sys-maint"},"content":{"rendered":"

Dans le cas o\u00f9 on rencontre l'erreur :<\/p>\n

ERROR 1045 (28000): Access denied for user 'debian-sys-maint'@'localhost' (using password: YES)<\/p><\/blockquote>\n

Il faut remettre \u00e0 jour le mot de passe de l'utilisateur MySQL \"debian-sys-maint\" avec la proc\u00e9dure suivante :<\/p>\n

grep password \/etc\/mysql\/debian.cnf<\/p>\n

service mysql stop
\nnohup mysqld_safe --skip-grant-tables &<\/p><\/blockquote>\n

Entrer dans la console mysql et connecter la base \"mysql\" :<\/p>\n

mysql -u root -p mysql<\/p><\/blockquote>\n

Dans la console MySQL :<\/p>\n

UPDATE user SET Password=PASSWORD('MOT_DE_PASSE_RECUPERE_AVEC_GREP') WHERE User='debian-sys-maint';
\nFLUSH PRIVILEGES;<\/p><\/blockquote>\n

Remplacer \"MOT_DE_PASSE_RECUPERE_AVEC_GREP\" par celui affich\u00e9 par la commande 'grep' tap\u00e9e au d\u00e9but. Penser \u00e0 laisser les simples quotes ' .<\/p>\n

Control+d pour quitter mysql<\/p>\n

killall mysqld
\nservice mysql start<\/p><\/blockquote>\n","protected":false},"excerpt":{"rendered":"

Dans le cas o\u00f9 on rencontre l'erreur : ERROR 1045 (28000): Access denied for user 'debian-sys-maint'@'localhost' (using password: YES) Il faut remettre \u00e0 jour le mot de passe de l'utilisateur MySQL \"debian-sys-maint\" avec la proc\u00e9dure suivante : grep password \/etc\/mysql\/debian.cnf service mysql stop nohup mysqld_safe --skip-grant-tables & Entrer dans la console mysql et connecter la […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[157,156],"tags":[105,104],"class_list":["post-262","post","type-post","status-publish","format-standard","hentry","category-authentification","category-sql","tag-debian-sys-maint","tag-mysql"],"_links":{"self":[{"href":"https:\/\/tty.tartux.net\/index.php?rest_route=\/wp\/v2\/posts\/262","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/tty.tartux.net\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/tty.tartux.net\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/tty.tartux.net\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/tty.tartux.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=262"}],"version-history":[{"count":3,"href":"https:\/\/tty.tartux.net\/index.php?rest_route=\/wp\/v2\/posts\/262\/revisions"}],"predecessor-version":[{"id":513,"href":"https:\/\/tty.tartux.net\/index.php?rest_route=\/wp\/v2\/posts\/262\/revisions\/513"}],"wp:attachment":[{"href":"https:\/\/tty.tartux.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=262"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tty.tartux.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=262"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tty.tartux.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=262"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}