summaryrefslogtreecommitdiffstats
path: root/roles/common-SQL/tasks
diff options
context:
space:
mode:
authorGuilhem Moulin <guilhem@fripost.org>2013-12-15 22:51:44 +0100
committerGuilhem Moulin <guilhem@fripost.org>2015-06-07 02:51:25 +0200
commitfaee1bbc276b63a81f3b81eae0f02bcaffabca6d (patch)
treefccc7fe2893b5a245dc56a3e1b86fbbef1f18de6 /roles/common-SQL/tasks
parent8dfcb7e08442b4af8f285bdd7732750938b25b9f (diff)
Load relevant MySQL authplugins.
Also, turn off all TCP/IP listener ports.
Diffstat (limited to 'roles/common-SQL/tasks')
-rw-r--r--roles/common-SQL/tasks/main.yml13
1 files changed, 13 insertions, 0 deletions
diff --git a/roles/common-SQL/tasks/main.yml b/roles/common-SQL/tasks/main.yml
index e32c863..553e269 100644
--- a/roles/common-SQL/tasks/main.yml
+++ b/roles/common-SQL/tasks/main.yml
@@ -9,6 +9,19 @@
- mysql-server
- python-mysqldb
+- name: Copy MySQL's configuration
+ copy: src=etc/mysql/my.cnf
+ dest=/etc/mysql/my.cnf
+ owner=root group=root
+ mode=0644
+ register: r
+ notify:
+ - Restart MySQL
+
+# We need to restart now and load the relevant authplugin before we
+# connect to the database.
+- meta: flush_handlers
+
- name: Force root to use UNIX permissions
mysql_user: name=root auth_plugin=auth_socket
state=present