可直接执行sql语句后退出

mysql -h IP -u root -p -e “sql语句; “

新建普通用户

  1. CREATE USER '用户名'@'localhost' IDENTIFIED BY '密码';
  2. CREATE USER '用户名'@'localhost' IDENTIFIED WITH MYSQL_NATIVE_PASSOWRD BY '密码';
-- mysql5.7可正常执行,8.0会报语法错误
GRANT SELECT, UPDATE ON *.* TO '用户名'@'localhost' IDENTIFIED BY '密码';

删除用户

delete from mysql.user where user='test';

修改密码

mysqladmin -u root -p password "password"

# 8.0不可用
set password = password('pwd');

# 权限表重载
flush privileges;

密码丢失

百度一下 —ship-grant-tables;

权限

# 收回权限
revoke create on *.* from '用户'@'localhost';

# 查看权限
show grants for 'root'@'localhost'

访问控制