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