\u9ed8\u8ba4\u7528\u6237\u662froot\uff0c\u5bc6\u7801\u4e3a\u7a7a\u3002\u5f53\u5b89\u88c5WordPress\u548cmoodle\u65f6\uff0c\u6570\u636e\u5e93\u5bc6\u7801\u4e0d\u5141\u8bb8\u7a7a\u3002\u53ef\u505a\u5982\u4e0b\u5904\u7406\uff1a>mysql -u root -p ;<\/p>\n\n\n\n
>use mysql;; <\/p>\n\n\n\n
> insert into user(host,user) values(“%”‘,” mysql cnliutz\u53ef\u8fdc\u7a0b\u8bbf\u95ee\uff0c*.*\u4ee3\u8868\u6240\u6709\u6570\u636e\u5e93\uff0c2234\u662f\u5bc6\u7801\uff0c%\u4ee3\u8868\u8fdc\u7a0b\uff0c\u4e5f\u53ef\u4ee5\u662flocalhost\u3002<\/p>\n\n\n\n myql 8.0<\/strong><\/p>\n\n\n\n >use mysql: >create user cnliutz identified by “galaxy”; <\/p>\n","protected":false},"excerpt":{"rendered":"cnliutz');<\/code><\/p>\n\n\n\n>grant all privileges on *.* to 'root'@'<\/code>%' identified by '2234<\/code>‘
mysql>GRANT ALL PRIVILEGES ON *.*<\/em> TO ‘root’@’%’ IDENTIFIED BY ‘2345’ WITH GRANT OPTION;
mysql>flush privileges;<\/p>\n\n\n\n
>alter user ‘root’@’localhost’ identified with mysql_native_password by “galaxy”;
create new user:<\/strong><\/p>\n\n\n\n
>grant all privileges on .<\/em> to ‘cnliutz’@’%’ ;
>flush privileges;
<\/p>\n\n\n\n