I’d like to use the mysql_user module to create accounts that look like this:
GRANT ALL PRIVILEGES ON . TO ‘bob’@'%’ IDENTIFIED BY ‘pass’ REQUIRE SSL;
Looking at the docs, it’s not immediately obvious how to do this.
- mysql_user: name=bob host='%' password=pass priv=*.*:ALL state=present
gets close, but doesn't include the "REQUIRE SSL" portion. Is it possible to include "REQUIRE SSL" during account creation?