系统会提示你输入密码。 执行ALTER USER命令,修改用户认证方式和密码: 一旦登录到MySQL命令行界面,你可以执行以下命令来修改用户的认证方式和密码: sql ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '12345'; 这条命令将'root'@'%'用户的认证方式修改为mysql_native_password,并将密码设置...
SELECT * FROM USER; 修改密码 UPDATE USER SET PASSWORD=PASSWORD(‘你的密码’) WHERE USER=‘root’; 也可分配权限账户: GRANT SELECT ON test.employee TO ‘eric’@‘localhost’ IDENTIFIED BY ‘123456’; GRANT DELETE ON test.employee TO ‘eric’@‘localhost’ IDENTIFIED BY ‘123456’; 刷新权限 ...