MySQL 03 管理与配置

1 查看MySQL服务器是否开启

ps -ef | grep mysqld

2 用户管理

1）创建用户

// 给用户授权，privileges可以使select、insert等
grant privileges on database.table to 'username'@'hostname' [identified by 'password'];
// 不授权，创建用户
create user 'username'@'hostname' identified by 'password';
// 添加用户
insert into mysql.user (host,user,password) values('hostname','username',password('password'));
// 刷新权限
flush privileges;

2）删除用户

// 方法一
drop user 'username'@'hostname';
// 方法二
delete from mysql.user where ...;
flush privileges;

3）修改用户（root）密码

// 方法1
mysqladmin -u username -p password new_password;
// 方法2
update mysql.user set password=password('new_password') where ....;
flush privileges;
// 方法3
set password=password('new_password');

4）root用户修改其他用户密码

set password for 'username'@'hostname'=password('new_password');

3 权限管理

1）授予权限

grant privileges on database.table to 'username'@'hostname' identified by 'new_password';

2）查看权限

show grants for 'username'@'hostname';

3）收回权限

revoke privileges on database.table from 'username'@'hostname';