mysql命令记录

删除用户：DROP USER 'gewufei'@'%';

进入mysql：mysql.exe -uroot -p   

切换库：use mysql;

创建账户：CREATE USER 'zhangsan'@'%' IDENTIFIED BY '123456';

修改密码：ALTER USER 'username'@'localhost' IDENTIFIED BY 'new_password';

修改密码加密方式：ALTER USER 'wubeisheng'@'%' IDENTIFIED WITH mysql_native_password BY '123456';

修改外网访问：update user set host=’%’ where user=’root’

查看密码加密方式：select host,user,plugin from user;

刷新权限：FLUSH PRIVILEGES;

指定用户访问指定库： GRANT ALL PRIVILEGES ON ads.* TO 'zhangsan'@'%';