\u75c7\u72b6\uff1a<\/p>\n
\u5b89\u88c5\u4e86mysql 8.0.11 \u4e4b\u540e\u672c\u5730\u53ef\u4ee5\u767b\u5f55\uff0c\u4f46\u662f\u8fdc\u7a0b\u7b2c\u4e09\u65b9\u5de5\u5177\u65e0\u6cd5\u8fde\u63a5\uff0c\u9632\u706b\u5899\u5df2\u7ecf\u653e\u901a\u7684\uff0c<\/p>\n
\u89e3\u51b3\u4e4b\u9053\uff1a<\/p>\n
\u9996\u5148\u767b\u9646\u5230mysql\u547d\u4ee4\u884c\uff1a<\/p>\n
mysql -u root -p
1
\u8fdb\u5165\u4e4b\u540e\u9009\u62e9mysql\u5e93\uff0c\u7528\u6237\u4fe1\u606f\u90fd\u5b58\u5728\u8fd9\u4e2a\u5e93\u7684user\u8868\u4e2d<\/p>\n
use mysql;
1
select host, user, authentication_string, plugin from user
1
\u53ef\u4ee5\u770b\u5230\uff0c\u7528\u6237\u5bf9\u5e94\u7684\u4e3b\u673a\u662flocalhost\uff0c\u800c\u4e0d\u662f%\uff0c\u6240\u4ee5\u4e0d\u80fd\u8fde\u63a5\u3002
\u5904\u7406\u65b9\u6cd5\uff1a
1\u3001\u6388\u6743root\u7528\u6237\u53ef\u4ee5\u8fdc\u7a0b\u767b\u9646<\/p>\n
GRANT ALL ON *.* TO ‘root’@’%’;
1
2\u3001\u5237\u65b0\u6743\u9650<\/p>\n
flush privileges;
1
3\u3001\u4fee\u6539\u52a0\u5bc6\u89c4\u5219<\/p>\n
ALTER USER ‘root’@’localhost’ IDENTIFIED BY ‘yourpassword’ PASSWORD EXPIRE NEVER;
1
4\u3001\u66f4\u65b0 root \u7528\u6237\u5bc6\u7801<\/p>\n
ALTER USER ‘root’@’%’ IDENTIFIED WITH mysql_native_password BY ‘yourpassword’;
1
5\u3001\u5237\u65b0\u6743\u9650<\/p>\n
FLUSH PRIVILEGES;
1
\u6d4b\u8bd5\u8fde\u63a5\u3002\u7528 Navicat \u8fde\u63a5\u6570\u636e\u5e93\u5c31\u53ef\u4ee5\u6b63\u5e38\u8fde\u63a5\u4e86\u3002<\/p>\n
\u53e6\uff0c\u7ed9\u666e\u901a\u7528\u6237\u8fdc\u7a0b\u8fde\u63a5\u7684\u6743\u9650\uff1a
1\u3001\u6388\u6743 myuser \u7528\u6237\u5bf9\u6307\u5b9a\u5e93\u7684\u6240\u6709\u8868\uff0c\u6240\u6709\u6743\u9650\u5e76\u8bbe\u7f6e\u8fdc\u7a0b\u8bbf\u95ee<\/p>\n
GRANT ALL ON \u6307\u5b9a\u5e93.* TO ‘myuser’@’%’;
1
2\u3001\u66f4\u65b0 \u8be5 \u7528\u6237\u5bc6\u7801<\/p>\n
ALTER USER ‘myuser’@’%’ IDENTIFIED WITH mysql_native_password BY ‘yourpassword’;
1
3.\u5237\u65b0\u6743\u9650<\/p>\n
FLUSH PRIVILEGES;
——————— <\/p>\n","protected":false},"excerpt":{"rendered":"
\u75c7\u72b6\uff1a \u5b89\u88c5\u4e86mysql 8.0.11 \u4e4b\u540e\u672c\u5730\u53ef\u4ee5\u767b\u5f55\uff0c\u4f46\u662f\u8fdc\u7a0b\u7b2c\u4e09\u65b9\u5de5\u5177\u65e0\u6cd5\u8fde\u63a5\uff0c\u9632\u706b\u5899\u5df2\u7ecf\u653e\u901a\u7684\uff0c \u89e3\u51b3 … \u7ee7\u7eed\u9605\u8bfb mysql 8.0.11 \u7528Navicat\u8fdc\u7a0b\u65e0\u6cd5\u8fde\u63a5<\/span>