Whether the modified tables takes effect immediately

[moluzhui]

auth mysql has two tables including mqtt_user and mqtt_acl. My attempts to add new users took effect immediately, but the access and topic changes to the acl didn't seem to take effect immediately. Whether some fields of both tables need to be restarted by the emqx or reload plug-in, or whether the broker needs to be reconnected to make changes to the database take effect?

[HJianBo]

Hi @moluzhui In the emqx.conf, we enable ACL cache by default:

enable_acl_cache = on

So, it can not works immediately after modified ACL rows

[moluzhui]

So, if I set enable_acl_cache to off, does the modify table implementation take effect in time, or do I need to change some other configuration?

[HJianBo]

No, Just turn off theenable_acl_cache option