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;