mysql 创建用户并授权

1.登陆mysql

 mysql -u root -p

2.创建用户

create user userdba identified by 'userdbapwd';

3.授权

grant all privileges on database1.* to 'userdba'@'%' identified by 'userdbapwd';

grant all privileges on database1.* to 'userdba'@'%';

all privileges指除了grant之外的所有权限，可以设置自己的权限

REVOKE ALL PRIVILEGES ON database_name.* FROM 'user_name'@'host';

移除所有权限
REVOKE ALL PRIVILEGES ON *.* FROM 'isfmdba'@'%';

3.常用语句

-- 查看数据库
show databases;

--使用数据库
use database1;

--查看表
show tables;

--查询用户
select user,host from user;

--查询用户权限
show grants for userdba;