[null, {"document_url": "https://severalnines.com/blog/clustercontrol-tips-tricks-securing-your-mysql-installation", "unformatted_src": "https://severalnines.com/sites/default/files/Screen%20Shot%202015-10-22%20at%209.24.54%20PM_0.png", "src": "https://severalnines.com/sites/default/files/Screen%20Shot%202015-10-22%20at%209.24.54%20PM_0.png", "formatted_filename": "Screen Shot at"}, {"document_url": "https://severalnines.com/blog/clustercontrol-tips-tricks-securing-your-mysql-installation", "unformatted_src": "https://severalnines.com/sites/default/files/Screen%20Shot%202015-10-22%20at%209.24.54%20PM_0.png", "src": "https://severalnines.com/sites/default/files/Screen%20Shot%202015-10-22%20at%209.24.54%20PM_0.png", "formatted_filename": "Screen Shot at"}, null, {"document_url": "https://severalnines.com/blog/clustercontrol-tips-tricks-securing-your-mysql-installation", "unformatted_src": "https://severalnines.com/sites/default/files/blog/node_4528/image1.jpg", "src": "https://severalnines.com/sites/default/files/blog/node_4528/image1.jpg", "formatted_filename": "image"}, null, {"document_url": "https://severalnines.com/blog/clustercontrol-tips-tricks-securing-your-mysql-installation", "unformatted_src": "https://severalnines.com/sites/default/files/blog/node_4528/image2.jpg", "src": "https://severalnines.com/sites/default/files/blog/node_4528/image2.jpg", "formatted_filename": "image"}, null, {"document_url": "https://severalnines.com/blog/clustercontrol-tips-tricks-securing-your-mysql-installation", "unformatted_src": "https://severalnines.com/sites/default/files/blog/node_4528/image3.jpg", "src": "https://severalnines.com/sites/default/files/blog/node_4528/image3.jpg", "formatted_filename": "image"}, null, {"document_url": "https://severalnines.com/blog/clustercontrol-tips-tricks-securing-your-mysql-installation", "unformatted_src": "https://severalnines.com/sites/default/files/blog/node_4528/image4.jpg", "src": "https://severalnines.com/sites/default/files/blog/node_4528/image4.jpg", "formatted_filename": "image"}, null, null, null, null, null, null, null]


ClusterControl Tips & Tricks: Securing your MySQL Installation (Updated)

ClusterControl Security & Compliance ClusterControl Tips & Tricks Requires ClusterControl 1.2.11 or later. Applies to MySQL based clusters.

In the User Interface go to Manage > Developer Studio. Expand the folders so that you see s9s/mysql/programs. Click on security_audit.js and then press Compile and Run.

If there are problems you will clearly see it in the messages section: Enlarged Messages output: Here we have accounts that can connect from any hosts and accounts which do not have a password. Those accounts should not exist in a secure database installation. That is rule number one. To correct this problem, click on mysql_secure_installation.js in the s9s/mysql/programs folder.

Click on the dropdown arrow next to Compile and Run and press Change Settings. You will see the following dialog and enter the argument “STRICT”: Then press Execute. The mysql_secure_installation.js script will then do on each MySQL database instance part of the cluster:

In the Message box you will see: The MySQL database servers part of this cluster have now been secured and you have reduced the risk of compromising your data.

You can re-run security_audit.js to verify that the actions have had effect.

Happy Clustering!

PS.: To get started with ClusterControl, click here! clustercontrol Database galera innodb management MariaDB MySQL operations security 

More from 'ClusterControl Tips & Tricks' series 


A New Way to Personalize Your PostgreSQL Monitoring with Prometheus 

Monitoring & Alerting ClusterControl ClusterControl Tips & Tricks