Учетные записи и привилегии (mysql.user)
Зарегистрированные пользователи СУБД
| Пользователь (User) | Хост (Host) | Плагин | Глобальные и объектные привилегии (Grants) | SSL |
|---|---|---|---|---|
| root | localhost | caching_sha2_password | ALL PRIVILEGES WITH GRANT OPTION | ANY |
| app_backend | 10.24.0.% | caching_sha2_password | SELECT, INSERT, UPDATE, DELETE ON production_ecommerce.* | X509 |
| bi_readonly | 10.24.8.14 | caching_sha2_password | SELECT, SHOW VIEW ON *.* | ANY |
| backup_agent | 127.0.0.1 | mysql_native_password | SELECT, RELOAD, LOCK TABLES, REPLICATION CLIENT | NONE |