MySQL -> MariaDB security questions

Droidism20011

• July 20, 2017 14:21

Hi, This is my first time using WHM/cPanel and I am still busy installing, tweaking and hardening my VPS. I got a couple of questions that I really can't find a clear answer to after querying both the Big G and the cPanel forums/documentation. If anyone knows of (a) thread(s) where the answer(s) is/are clearly explained, feel free to direct me to it/them and please let me appologies on forehand. I try to RTFM as much as possible, but still... Question no.1: I would very much like to change MySQL vx.x to MariaDB vx.x. With auto SLL and WHM/cPanel automagically issuing TLS (SSL) certificates for the server is it still advisable to follow all the steps layed out in the

• 

  24x7server

  • July 21, 2017 06:14

  Hi, Question no.1: I would very much like to change MySQL vx.x to MariaDB vx.x. With auto SLL and WHM/cPanel automagically issuing TLS (SSL) certificates for the server is it still advisable to follow all the steps layed out in the How to Configure MySQL SSL Connections documentation or does cPanel take care of generating the appropriate TLS certificates and can I skip that part?
  --> With the change, I think the SSL will remain the same. The link you gave has pretty much everything on it in terms of SSL installation.. Question no.2: After installing/changing MySQL to MariaDB, do I (still) need to manually run "mysql_secure_installation" or does WHM/cPanel automagically take care of this in/via the cPanel upgrade/installation script it uses?
  --> If you upgrade it through WHM interface, then you do not have to do anything (unattended session). It will perform everything...

  0
• 

  cPanelMichael

  • July 21, 2017 16:24

  Hello @Droidism20011,

  I would very much like to change MySQL vx.x to MariaDB vx.x. With auto SLL and WHM/cPanel automagically issuing TLS (SSL) certificates for the server is it still advisable to follow all the steps layed out in the
  "/usr/bin/mysql_secure_installation" is installed as part of the MariaDB package. You can run this command manually if you prefer, but it's not typically required because actions such as configuring a root password, removing the test database, and removing the anonymous user are already done during the initial setup. Thank you.

  0
• 

  Droidism20011

  • July 24, 2017 08:16

  @24x7server and @cPanelMichael Thanks for your help and explanation. Have a great day!

  0

Please sign in to leave a comment.