关于mysql用户

1.删除用指定户

 delete from user where user='root' and host='%';

2. 给用户授权

--增删改
GRANT select, insert, update, delete ON project_class.*  TO 'rgzx'@'%' IDENTIFIED BY 'rgzx@123321@' WITH GRANT OPTION;
--所有
grant all privileges on root.* to 'root'@'172.18.23.201' identified by 'root';

3. 关于绑架的博客

4.查看用户

use mysql;
select user, host from user;

5.刷新

flush privileges；

6.创建用户

create user 'root'@'%' identified by 'root';

7.docker登录

docker exec -it 容器名/容器id mysql -uroot -p root

8.收回权限

-- REVOKE DROP ON *.*  FROM '用户名'@'%';
REVOKE DROP ON project_class.*  FROM 'rgzx'@'%';

9.查看用户权限

--show grants for 用户名;
show grants for rgzx;

10.docker进去mysql

docker exec -it 容器id bash

11.修改密码

--5.7后
update user set authentication_string=password('root') where user='root' and host='%';
--5.7前
update user set password=password('root') where user='root' and host='%';

12.查看数据文件存储位置

show global variables like "%datadir%";