mysql用户

1. 学会能按着需求创建一个帐号

2. 知道连接字符串是什么样

3. 密码密码怎么恢复

 

mysql用户权限介绍

mysql用户管理

 

 

 

需要创建一个监控帐号

监控帐号需要执行的命令：

1. show global status/variables; 

2. show slave status\ show master status;

3. show engine innodb status;

4. show processlist; or show full processlist;

5. select xxx from information_schema.xxx;

create user 'monitor

create user 'monitor'@'%' identified by 'mon4zabbix';

% 所有机器源

 

create user 'monitor'@'192.168.11.99' identified by 'mon4zabbix';

grant show , select on information_schema.* to 'monitor'@'%' ;

select user, host, plugin, authentication_string from mysql.user;

ALTER USER 'jeffrey'@'localhost'   IDENTIFIED BY 'new_password' PASSWORD EXPIRE;

 

Drop user ‘用户名’@’来源’;