{"id":375,"date":"2011-02-18T16:43:18","date_gmt":"2011-02-18T10:43:18","guid":{"rendered":"http:\/\/norfolk.valman.org\/blog\/?p=375"},"modified":"2011-02-18T17:05:23","modified_gmt":"2011-02-18T11:05:23","slug":"error-1045-access-denied-for-user-rootlocalhost-using-password-no","status":"publish","type":"post","link":"https:\/\/notes.norfolks.fun\/?p=375","title":{"rendered":"ERROR 1045: Access denied for user: ‘root@localhost’ (Using password: NO)"},"content":{"rendered":"

\u0421\u043e\u043e\u0431\u0449\u0435\u043d\u0438\u0435 \u043e\u0442 s10n on 20-\u042f\u043d\u0432-09, 00:38 <\/em><\/p>\n

1. \u041e\u0442\u043a\u0440\u044b\u0432\u0430\u0435\u043c 1 \u0442\u0435\u0440\u043c\u0438\u043d\u0430\u043b, \u0437\u0430\u0445\u043e\u0434\u0438\u043c \u043f\u043e\u0434 root, \u043f\u0438\u0448\u0435\u043c:<\/p>\n

#cd \/usr\/local\/etc\/rc.d
\n#.\/mysql-server stop
\n#cd \/usr\/bin\/
\n#mysqld_safe --skip-grant-tables<\/code>
\n\u043d\u0430 \u044d\u0442\u043e\u043c \u043c\u0435\u0441\u0442\u0435 \u0441\u0438\u0441\u0442\u0435\u043c\u0430 \u043a\u0430\u043a \u0431\u0443\u0434\u0442\u043e \u0437\u0430\u0432\u0438\u0441\u0430\u0442… \u043d\u0430 \u0441\u0430\u043c\u043e\u043c \u0434\u0435\u043b\u0435 \u043f\u0440\u043e\u0441\u0442\u043e mysqld_safe \u043f\u0440\u043e\u0441\u0442\u043e \u043f\u0435\u0440\u0435\u0448\u043b\u0430 \u0432 \u0438\u043d\u0442\u0435\u0440\u0430\u043a\u0442\u0438\u0432\u043d\u044b\u0439 \u0440\u0435\u0436\u0438\u043c \u0438 \u0441\u044e\u0434\u0430 \u0431\u0443\u0434\u0443\u0442 \u0432\u0430\u043b\u0438\u0442\u0441\u044f \u043b\u043e\u0433\u0438.<\/p>\n

2. \u041e\u0442\u043a\u0440\u044b\u0432\u0430\u0435\u043c 2 \u0442\u0435\u0440\u043c\u0438\u043d\u0430\u043b, \u0437\u0430\u0445\u043e\u0434\u0438\u043c \u043f\u043e\u0434 root,
\n\u043f\u0438\u0448\u0435\u043c:
\n#mysql<\/code><\/p>\n

\u0432\u0438\u0434\u0438\u043c \u043f\u0440\u0438\u0432\u0435\u0442\u0441\u0442\u0432\u0438\u0435 \u043c\u0443\u0441\u043a\u0443\u043b\u044f:
\nmysql><\/code><\/p>\n

\u043f\u0438\u0448\u0435\u043c:
\nuse mysql;
\nUPDATE user SET password=('New Password') where user='root';
\nexit;<\/code><\/p>\n

\u0434\u0430\u043b\u0435\u0435 \u0437\u0430\u043f\u0443\u0441\u043a\u0430\u0435\u043c mysql:
\n#mysql -u root -p 'New Password'<\/code><\/p>\n

\u0442\u0435\u043f\u0435\u0440\u044c \u043f\u0435\u0440\u0432\u0443\u044e \u043a\u043e\u043d\u0441\u043e\u043b\u044c \u043c\u043e\u0436\u043d\u043e \u0437\u0430\u043a\u0440\u044b\u0432\u0430\u0442\u044c!<\/p>\n

\u0412\u0441\u0435\u043c \u0443\u0434\u0430\u0447\u0438!<\/p>\n

http:\/\/opennet.ru\/openforum\/vsluhforumID1\/81584.html?n=s10n#4<\/p>\n

PS
\n\u0427\u0443\u0442\u044c \u043d\u0435 \u0437\u0430\u0431\u044b\u043b! <\/strong>
\n\u0423 \u043c\u0435\u043d\u044f \u043f\u043e\u0447\u0435\u043c\u0443-\u0442\u043e \u043f\u043e\u0441\u043b\u0435 \u043f\u0435\u0440\u0435\u0437\u0430\u0433\u0440\u0443\u0437\u043a\u0438 \u0441\u0435\u0440\u0432\u0435\u0440\u0430 \u043c\u0443\u0441\u043a\u0443\u043b\u044c \u0441\u043d\u043e\u0432\u0430 \u0442\u0435\u0440\u044f\u043b \u0431\u0430\u0437\u044b \u0438 \u043f\u0430\u0440\u043e\u043b\u044c \u0440\u0443\u0442\u0430. \u041f\u043e\u043c\u043e\u0433\u043b\u043e \u0442\u043e\u043b\u044c\u043a\u043e \u043a\u043e\u0433\u0434\u0430 \u044f \u0441\u043d\u043e\u0432\u0430 \u043f\u0440\u043e\u0434\u0435\u043b\u0430\u043b \u0432\u0441\u0435 \u043f\u0435\u0440\u0435\u0447\u0438\u0441\u043b\u0435\u043d\u043d\u044b\u0435 \u0432 \u043f\u0440\u0435\u0434\u044b\u0434\u0443\u0449\u0435\u043c \u043f\u043e\u0441\u0442\u0435 \u0434\u0435\u0439\u0441\u0442\u0432\u0438\u044f, \u0442\u043e\u043b\u044c\u043a\u0430 \u043e\u0441\u0442\u0430\u0432\u0438\u0432 \u043f\u0430\u0440\u043e\u043b\u044c root’a \u043f\u0443\u0441\u0442\u044b\u043c:
\n(UPDATE user SET password=(») where user=’root’;)
\n\u0430 \u043f\u043e\u0442\u043e\u043c \u0438\u0437\u043c\u0435\u043d\u0438\u043b \u0435\u0433\u043e \u0435\u0449\u0435 \u0440\u0430\u0437 \u0432\u043e\u0442 \u0442\u0430\u043a:
\nftp# mysql -u root
\nmysql>
\nmysql> SET PASSWORD FOR root@localhost=PASSWORD(‘new_passwd’);
\nmysql> exit<\/p>\n

\u0412\u0441\u0435 \u0434\u0435\u0439\u0441\u0442\u0432\u0438\u044f \u0432\u044b\u043f\u043e\u043b\u043d\u044f\u043b\u0438\u0441\u044c \u043d\u0430
\nFeeBSD 7.01
\nMySQl 5.0 (mysql-server-5.0.67_1)<\/p>\n","protected":false},"excerpt":{"rendered":"

\u0421\u043e\u043e\u0431\u0449\u0435\u043d\u0438\u0435 \u043e\u0442 s10n on 20-\u042f\u043d\u0432-09, 00:38 1. \u041e\u0442\u043a\u0440\u044b\u0432\u0430\u0435\u043c 1 \u0442\u0435\u0440\u043c\u0438\u043d\u0430\u043b, \u0437\u0430\u0445\u043e\u0434\u0438\u043c \u043f\u043e\u0434 root, \u043f\u0438\u0448\u0435\u043c: #cd \/usr\/local\/etc\/rc.d #.\/mysql-server stop #cd \/usr\/bin\/ #mysqld_safe —skip-grant-tables \u043d\u0430 \u044d\u0442\u043e\u043c \u043c\u0435\u0441\u0442\u0435 \u0441\u0438\u0441\u0442\u0435\u043c\u0430 \u043a\u0430\u043a \u0431\u0443\u0434\u0442\u043e \u0437\u0430\u0432\u0438\u0441\u0430\u0442… \u043d\u0430 \u0441\u0430\u043c\u043e\u043c \u0434\u0435\u043b\u0435 \u043f\u0440\u043e\u0441\u0442\u043e mysqld_safe \u043f\u0440\u043e\u0441\u0442\u043e \u043f\u0435\u0440\u0435\u0448\u043b\u0430 \u0432 \u0438\u043d\u0442\u0435\u0440\u0430\u043a\u0442\u0438\u0432\u043d\u044b\u0439 \u0440\u0435\u0436\u0438\u043c \u0438 … \u0427\u0438\u0442\u0430\u0442\u044c \u0434\u0430\u043b\u0435\u0435 →<\/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":[8],"tags":[],"class_list":["post-375","post","type-post","status-publish","format-standard","hentry","category-8"],"_links":{"self":[{"href":"https:\/\/notes.norfolks.fun\/index.php?rest_route=\/wp\/v2\/posts\/375","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/notes.norfolks.fun\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/notes.norfolks.fun\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/notes.norfolks.fun\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/notes.norfolks.fun\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=375"}],"version-history":[{"count":2,"href":"https:\/\/notes.norfolks.fun\/index.php?rest_route=\/wp\/v2\/posts\/375\/revisions"}],"predecessor-version":[{"id":377,"href":"https:\/\/notes.norfolks.fun\/index.php?rest_route=\/wp\/v2\/posts\/375\/revisions\/377"}],"wp:attachment":[{"href":"https:\/\/notes.norfolks.fun\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=375"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/notes.norfolks.fun\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=375"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/notes.norfolks.fun\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=375"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}