mysql> create database nagios_monitor;
mysql> grant
select
on nagios_monitor.* to nagios@
'%'
identified by
'123qaz!@#'
;
Query OK, 0 rows affected (0.00 sec)
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)
mysql>
select
User,Password,Host from mysql.user;
+--------+-------------------------------------------+--------------+
| User | Password | Host |
+--------+-------------------------------------------+--------------+
| root | *B9627CB37815863D1E98D0C41E0233A772355E2B | localhost |
| root | *B9627CB37815863D1E98D0C41E0233A772355E2B | 127.0.0.1 |
| root | *B9627CB37815863D1E98D0C41E0233A772355E2B | ::1 |
| cacti | *BC3E1F14C7940F9C8BCDB05A38385754BB55CD64 | localhost |
| nagios | *BC3E1F14C7940F9C8BCDB05A38385754BB55CD64 | % |
+--------+-------------------------------------------+--------------+
8 rows
in
set
(0.00 sec)