For me the problem was the following: The MariaDB server is running with the --strict-password-validation option so it cannot execute this...
Separate names with a comma.