{"repo":"geerlingguy/ansible-role-mysql","free":true,"listed":false,"github":"https://github.com/geerlingguy/ansible-role-mysql","clone":"git clone https://github.com/geerlingguy/ansible-role-mysql.git","description":"Ansible Role - MySQL","language":"Jinja","stars":1131,"topics":["mysql","ansible","role","database","mariadb","playbook"],"license":"MIT","category":"databases-storage","readme_excerpt":"Ansible Role: MySQL Installs and configures MySQL or MariaDB server on RHEL/CentOS or Debian/Ubuntu servers. Requirements No special requirements; note that this role requires root access, so either run it in a playbook with a global become: true , or invoke the role in your playbook like: Role Variables Available variables are listed below, along with default values (see defaults/main.yml ): The home directory inside which Python MySQL settings will be stored, which Ansible will use when connecting to MySQL. This should be the home directory of the user which runs this Ansible role. The mysql user name and mysql user password can be set if you are running this role under a non-root user account and want to set a non-root user. The MySQL root user account details. Whether to force update the MySQL root user's password. By default, this role will only change the root user's password when MySQL is first configured. You can force an update by setting this to true . Note: If you get an error like ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES) after a failed or interrupted playbook run, this usually means the root password wasn't originally updated to begin with. Try either removing the .my.cnf file inside the configured mysql user home or updating it and setting password='' (the insecure default password). Run the playbook again, with mysql root password update set to yes , and the setup should complete. Note: If you get an error like ERROR 16","default_branch":null,"files":null,"tree":[],"storefront":"/r/geerlingguy","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/geerlingguy/ansible-role-mysql/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}