On 2021-12-27 21:01, Dmitri Maziuk wrote:
Thank you, I learned something today (not that I wanted to: I try to stay away from that POS as much as I can, but that doesn't work 100%). Now I know why you had to grant to both 'root'@'localhost' and 'root'@'127.0.0.1' -- in addition to 'root'@'%' of course.
Special care should be used when allowing access from other hosts. For example that 'root'@'%' would allow root access from any IP. Most people continue to keep mysql root user without password which might prove as a bad practice, especially in constellation with incorrectly set access permissions (grants). Also, all traffic is plain-text and very few people decide to configure TLS encryption although MySQL supports is for decades. -- Josip Deanovic _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
