Mysql用户管理

假期学习mysql用户管理

查看mysql数据库权限表的信息
desc user;
desc mysql.db;
desc tables_priv
desc colums_priv;
desc procs_priv;
# 登录
mysql -u root -p
mysql -u root -p -h 192.... -p 3306
mysql -u username -p databaes_name

新建用户

create user 'username'@'localhost' identifiled by 'pasword';
grant select on database_name.* to 'username'@'localhost';
flush privileges;

删除用户

drop user 'username'@'host';

修改密码

alter user 'root'@'localhost' identified by 'new_password';
set password for 'root'@'localhost' = 'new_password';
flush privileges;