I'm setting up HaProxy with Mysql8 and I need to create a user with no password for haproxy.
When I try to create a user with an empty password I get: "ERROR 1819 (HY000): Your password does not satisfy the current policy requirements".
How can disable the password requirements for MySQL8? This account would have no permissions so I'm not worried not having a password.