{"id":1708,"date":"2018-10-08T11:35:58","date_gmt":"2018-10-08T03:35:58","guid":{"rendered":"https:\/\/damogame.cn:15443\/wordpress\/?p=1708"},"modified":"2018-10-08T11:35:58","modified_gmt":"2018-10-08T03:35:58","slug":"mysql-error-1698-28000-%e9%94%99%e8%af%af","status":"publish","type":"post","link":"https:\/\/i007.cc\/wordpress\/archives\/1708","title":{"rendered":"MySQL ERROR 1698 (28000) \u9519\u8bef"},"content":{"rendered":"

MySQL ERROR 1698 (28000) \u9519\u8bef<\/a><\/h1>\n
<\/div>\n
\n
\n

\u4e4b\u524dMySQL\u670d\u52a1\u7aef\u672c\u673a\u4e0a\u4f7f\u7528\u5bc6\u7801\u767b\u9646root\u8d26\u53f7\u662f\u6ca1\u6709\u95ee\u9898\u7684\uff0c\u4f46\u662f\u4eca\u5929\u4e0d\u77e5\u9053\u662f\u56e0\u4e3a\u52a8\u4e86\u54ea\u91cc\uff0c\u767b\u9646\u5931\u8d25\u5e76\u6709\u8fd9\u4e2a\u9519\u8bef\u4ee3\u7801\uff1a<\/p>\n

\n
~$ mysql -u root -p\r\nEnter password: \r\nERROR 1698 (28000): Access denied for user 'root'@'localhost'<\/pre>\n<\/div>\n
 <\/p>\n
\u89e3\u51b3\u6b65\u9aa4\uff1a<\/p>\n
\u505c\u6b62mysql\u670d\u52a1<\/p>\n
\n
~$ sudo service mysql stop<\/pre>\n<\/div>\n
 <\/p>\n
\u4ee5\u5b89\u5168\u6a21\u5f0f\u542f\u52a8MySQL<\/p>\n
\n
~$ sudo mysqld_safe --skip-grant-tables &<\/pre>\n<\/div>\n
 <\/p>\n
MySQL\u542f\u52a8\u4e4b\u540e\u5c31\u53ef\u4ee5\u4e0d\u7528\u5bc6\u7801\u767b\u9646\u4e86<\/p>\n
\n
~$ mysql -u root\r\nWelcome to the MySQL monitor.  Commands end with ; or \\g.\r\nYour MySQL connection id is 2\r\nServer version: 5.7.10 MySQL Community Server (GPL)<\/pre>\n<\/div>\n
 <\/p>\n
\u67e5\u770b\u4e00\u4e0buser\u8868\uff0c\u9519\u8bef\u7684\u8d77\u56e0\u5c31\u662f\u5728\u8fd9\u91cc\uff0c root\u7684plugin\u88ab\u4fee\u6539\u6210\u4e86auth_socket\uff0c\u7528\u5bc6\u7801\u767b\u9646\u7684plugin\u5e94\u8be5\u662fmysql_native_password\u3002<\/p>\n
\n
\"\u590d\u5236\u4ee3\u7801\"<\/a><\/span><\/div>\n
mysql> select user, plugin from mysql.user;\r\n+-----------+-----------------------+\r\n| user      | plugin                |\r\n+-----------+-----------------------+\r\n| root      | auth_socket           |\r\n| mysql.sys | mysql_native_password |\r\n| dev       | mysql_native_password |\r\n+-----------+-----------------------+\r\n3 rows in set (0.01 sec)<\/pre>\n
\"\u590d\u5236\u4ee3\u7801\"<\/a><\/span><\/div>\n<\/div>\n
 <\/p>\n
\u5173\u4e8eauth_socket\uff0c\u5728\u5b98\u65b9\u6709\u8bf4\u660e\uff1a\u00a0https:\/\/dev.mysql.com\/doc\/mysql-security-excerpt\/5.5\/en\/socket-authentication-plugin.html<\/a>\u00a0\uff0c\u53cd\u6b63\u73b0\u5728\u6682\u65f6\u4e0d\u7528\u5b83\uff0c \u90a3\u5c31\u628a\u8fd9\u91cc\u6539\u4e86\u3002<\/p>\n
\n
\"\u590d\u5236\u4ee3\u7801\"<\/a><\/span><\/div>\n
mysql> update mysql.user set authentication_string=PASSWORD('newPwd'), plugin='mysql_native_password' where user='root';\r\nQuery OK, 1 row affected, 1 warning (0.00 sec)\r\nRows matched: 1  Changed: 1  Warnings: 1\r\n\r\nmysql> flush privileges;\r\nQuery OK, 0 rows affected (0.00 sec)<\/pre>\n
\"\u590d\u5236\u4ee3\u7801\"<\/a><\/span><\/div>\n<\/div>\n
 <\/p>\n
\u91cd\u542f\u670d\u52a1\uff0c\u95ee\u9898\u5c31\u89e3\u51b3\u4e86<\/p>\n
\n
\"\u590d\u5236\u4ee3\u7801\"<\/a><\/span><\/div>\n
~$ sudo service mysql stop\r\n...\r\n * MySQL Community Server 5.7.10 is stopped\r\n~$ sudo service mysql start\r\n..\r\n * MySQL Community Server 5.7.10 is started\r\n~$ mysql -u root -p\r\nEnter password: \r\nWelcome to the MySQL monitor.  Commands end with ; or \\g.\r\nYour MySQL connection id is 2\r\nServer version: 5.7.10 MySQL Community Server (GPL)<\/pre>\n
\"\u590d\u5236\u4ee3\u7801\"<\/a><\/span><\/div>\n<\/div>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"
MySQL ERROR 1698 (28<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"colormag_page_container_layout":"default_layout","colormag_page_sidebar_layout":"default_layout","footnotes":""},"categories":[],"tags":[118],"class_list":["post-1708","post","type-post","status-publish","format-standard","hentry","tag-02-"],"_links":{"self":[{"href":"https:\/\/i007.cc\/wordpress\/wp-json\/wp\/v2\/posts\/1708","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/i007.cc\/wordpress\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/i007.cc\/wordpress\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/i007.cc\/wordpress\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/i007.cc\/wordpress\/wp-json\/wp\/v2\/comments?post=1708"}],"version-history":[{"count":0,"href":"https:\/\/i007.cc\/wordpress\/wp-json\/wp\/v2\/posts\/1708\/revisions"}],"wp:attachment":[{"href":"https:\/\/i007.cc\/wordpress\/wp-json\/wp\/v2\/media?parent=1708"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/i007.cc\/wordpress\/wp-json\/wp\/v2\/categories?post=1708"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/i007.cc\/wordpress\/wp-json\/wp\/v2\/tags?post=1708"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}