\u767b\u9646\u8fdb\u53bbmysql\u7ec8\u7aef<\/p>\n
use mysql;<\/p>\n
update user set host = ‘%’ where user = ‘root’; (\u4f7fmysql root\u7528\u6237\u53ef\u4ee5\u8fde\u63a5\u4e0a\u4efb\u610f\u7684ip\u5730\u5740)<\/p>\n
FLUSH PRIVILEGES\uff1b<\/p>\n
\u5bc6\u7801\u4fee\u6539\u4e5f\u53d8\u66f4\u4e86<\/p>\n
\u6cd5\u4e00\uff1a<\/p>\n
mysql> update mysql.user set authentication_string=password(‘123qwe’) where user=’root’ and Host = ‘localhost’;
\n1
\n\u6cd5\u4e8c\uff1a<\/p>\n
mysql> alter user ‘root’@’localhost’ identified by ‘123’;
\n1
\n\u6cd5\u4e09\uff1a<\/p>\n
mysql> set password for ‘root’@’localhost’=password(‘123’);
\n1
\n\u8bb0\u5f97\u6700\u540e\u8981\u5237\u65b0\u6743\u9650<\/p>\n
mysql> flush privileges;<\/p>\n","protected":false},"excerpt":{"rendered":"
\u767b\u9646\u8fdb\u53bbmysql\u7ec8\u7aef use mysql; update user set h … \u7ee7\u7eed\u9605\u8bfb