查看Zabbix所使用的数据库用户的信息及其权限:
mysql> show grants for zabbix@localhost;
+---------------------------------------------------------------------------------------------------------------+
| Grants for zabbix@localhost |
+---------------------------------------------------------------------------------------------------------------+
| GRANT USAGE ON *.* TO 'zabbix'@'localhost' IDENTIFIED BY PASSWORD '*DEEF4D7D88CD046ECA02A80393B7780A63E7E789' |
| GRANT ALL PRIVILEGES ON `zabbix`.* TO 'zabbix'@'localhost' |
+---------------------------------------------------------------------------------------------------------------+
2 rows in set (0.05 sec)
注释:数据库用户zabbix@localhost其实已经有备份库zabbix的权限了。
再创建一个数据库用户zhuohua@localhost,并赋权:
mysql> grant all on *.* to zhuohua@localhost identified by '168';
Query OK, 0 rows affected (0.02 sec)
查看数据库用户zhuohua@localhost的权限:
mysql> show grants for zhuohua@localhost;
+-------------------------------------------------------------------------------------------------------------------------+
| Grants for zhuohua@localhost |
+-------------------------------------------------------------------------------------------------------------------------+
| GRANT ALL PRIVILEGES ON *.* TO 'zhuohua'@'localhost' IDENTIFIED BY PASSWORD '*242E46A1E8D30FE06F7CE37B55BFC25BA981D70C' |
+-------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)
注释:数据库用户zhuohua@localhost已经有完全管理库zabbix的权限了。
再次查看所有数据库用户及其主机信息: