Basic things to do when performing MySQL Server Installation

Things to configure to setup basic MySQL Server

  • Install the latest version of MySQL server & client available on OS repository or as specified by client.
  • Configure MySQL service to automatically start on boot time. For e.g. on RHEL based OS chkconfig mysqld on
  • Start the server /etc/init.d/mysqld start
  • Now start the basic setup of MySQL by running the script mysql_secure_installation. It will ask you a series of questions & also give you the option to set MySQL root password.
  • Now edit /etc/my.cnf file if you want to change more default options like data directory, enabling detailed/slow logging, etc
  • That’s it with the default secure installation & setup of MySQL server

Leave a Reply

Your email address will not be published. Required fields are marked *