Mysql常用命令

8.0修改root用户密码

alter user 'root'@'localshot' identified by 'password' ;

8.0授权root用户

grant all privileges on *.* to 'root'@'localhost' ;

修改root用户登录权限

update mysql.user set Host='%' where user='root';

查询用户及密码格式

select user,host,plugin from mysql.user ;

查询用户

select user,host from mysql.user;

查看用户对库权限

show grants for 'user'@'%';

清除用户对库所有权限

REVOKE ALL PRIVILEGES ON *.* FROM 'user'@'%';

清除用户对指定库权限

REVOKE ALL PRIVILEGES ON db1.* FROM 'user'@'%';

创建用户

create user 'newuser'@'%' identified by 'password' ;

创建用户及密码认证格式

create user 'montior'@'%' identified with mysql_native_password by 'Jianren@123';

删除用户

drop user 'newuser'@'%' ;

创建数据库

create database newdate ;

删除数据库

drop database newdate; 

授权用户对指定库权限

grant all on newdate.* to newuser;   #授权newuser用户对newdate库所有权限

授权用户对所有库有读权限

grant select  on *.* to 'newuser'@'%' with grant option; 

授权用户对库有读写权限

grant select,insert,update,delete on *.* to 'newuser'@'%' ;

清除链接缓存

flush hosts ;