On 12/26/21 12:59, Josip Deanovic wrote:
When using MySQL roles and grant statement to change privileges, the command "flush privileges" is not necessary but it doesn't hurt. When modifying mysql/user and similar tables then it is necessary to issue "flush privileges" in order to re-read and apply changes made to the tables.
Never hurts to be sure. You will never cause a problem by calling FLUSH PRIVILEGES when you didn't need to.
Unfortunately, many years ago KDE PIM application suite moved to akonadi which uses and manages its own mysql instance. That made it awfully slow and unstable, hard to debug and understand and even harder to trace the problem and fix but the wheel of "progress" doesn't care much about functionality.
I totally hear you. Prime case in point: systemd.
Also, you mentioned "embedded instance" but I am not sure if this can be called embedded instance because the there is an actual mysql daemon running. It just uses dedicated config file and datadir.
Embedded as in "the application sets up its own dedicated mysql instance that it assumes nothing else will use".
-- Phil Stracchino Babylon Communications ph...@caerllewys.net p...@co.ordinate.org Landline: +1.603.293.8485 Mobile: +1.603.998.6958 _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users