Shulou(Shulou.com)06/01 Report--

The database version is 5.7.X

What's the difference?

GRANT USAGE,SELECT,PROCESS,REPLICATION CLIENT,REPLICATION SLAVE ON *. * TO 'zabbix'@'127.0.0.1' IDENTIFIED BY' xxxxxx';flush privileges;CREATE USER 'zabbix'@'localhost' IDENTIFIED BY' XXXXXXXX' WITH MAX_USER_CONNECTIONS 3 * Grant PROCESS,REPLICATION CLIENT, SELECT ON *. * TO 'zabbix'@'localhost'

1. What do these permissions mean?

2. Why do these two different methods appear?

3. Is the result the same?

4. Which method of writing is more secure, although all of them can meet the requirements of monitoring.

Usually I write it in the second way.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.