Mysql 命令 1 2 3 4 5 6 7 8 9 10 desc table； #显示表头 select Host,User,plugin from user; #用户名，登录方式，用户名，认证方式， ALTER USER root@localhost IDENTIFIED WITH mysql_native_password BY 'root'; #修改root认证方式mysql_native_password，密码为root FLUSH PRIVILEGES; #刷新认证表 UPDATE user SET Password=PASSWORD('newpassword') where USER='root'; #修改密码 ALTER USER root@localhost identified WITH mysql_native_password BY 'root'; #修改密码 set password for root@localhost = password('root'); #进入数据修……

阅读全文