{"repo":"eslam-gomaa/mysql_secure_installation_Ansible","free":true,"listed":false,"github":"https://github.com/eslam-gomaa/mysql_secure_installation_Ansible","clone":"git clone https://github.com/eslam-gomaa/mysql_secure_installation_Ansible.git","description":"Idempotent Ansible Module that provides the functions of \"mysql_secure_installation\" script","language":"Python","stars":44,"topics":["ansible","playbook","mysql","python","module","automation"],"license":null,"category":"databases-storage","readme_excerpt":"mysql secure installation Ansible ✋ Wait a second ! This module has been refactored to get rid of the dependencies issue across distributions, And it's much simpler now. Updates - [x] use pymysql lib instead of MySQLdb 👎 - [x] Enable authentication with unix socket - [x] Add an option to disable unix socket - [x] make the output more understandable - [x] run different commands based on different MySQL versions (Due to changes in newer MySQL versions) To do, - [ ] Update the module doc - [ ] Test with more distributions - [ ] Validate that disable unix socket works well in MySQl version = 1.4 --- Features An Idempotent Ansible Module that provides the functions of mysql secure installation - Change MySQL Root Password - for a list of hosts i.e localhost , 127.0.0.1 , ::1 , .etc. - Remove Anonymous User - Disallow Root Login Remotely - Remove Test Database - disable unix socket 💎 The Module is Idempotent Means that when you run it again, will not re-execute the commands If the desired state meets the current state --- Dependencies This is NOT something to worry about, It is something to make sure it's meet if you faced an error 1. mysqladmin command (already installed with MySQL/Mariadb) -- Needed to get information such as unix socket location & MySQL version 2. python-pymysql which can be easily installed using the pkg manager e.g: apt, yum The only caveat is that this package name may differ between distributions e.g: python3-pymysql or python36-pymysql (Trying to cover al","default_branch":null,"files":null,"tree":[],"storefront":"/r/eslam-gomaa","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/eslam-gomaa/mysql_secure_installation_Ansible/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."}