重庆思庄Oracle、Redhat认证学习论坛

标题: EM监控MYSQL用户权限 [打印本页]

作者: 郑全 时间: 2024-10-10 14:39
标题: EM监控MYSQL用户权限
1.登录数据库
mysql -u root -p

2.创建监控用户 cREATE USER 'monitoring'@'%' IDENTIFIED BY 'cloud_4U';

3.授权

GRANT SELECT, REPLICATION CLIENT, SHOW DATABASES, PROCESS, EXECUTE ON *.* TO 'monitoring'@'%' IDENTIFIED BY 'cloud_4U';

4.刷新权限生效
FLUSH PRIVILEGES;

5.使用 Sys Schema Table Metadata Lock Waits 度量
[mysqld]
performance-schema-instrument='wait/lock/metadata/sql/mdl=ON'

欢迎光临重庆思庄Oracle、Redhat认证学习论坛 (http://bbs.cqsztech.com/)