This article gives you detailed instructions on how to install and securely manage MySQL on a CentOS Dedicated or Cloud Server. This is specifically for dedicated servers where you have root level access (i.e. Self Managed or partially managed). If you are here looking for how to install MySQL on an AIT Fully Managed platform, then you will need to review this FAQ.
- Install the MySQL server by using yum.
- yum install mysql-server
- Next, start MySQL.
- /sbin/service mysqld start
- Once started, secure MySQL using this tool.
- /usr/bin/mysql_secure_installation
- Allow remote connections to your MySQL database. This command will open up the default MySQL port on your server. You don’t have to do this if you are not planning on remotely connecting to your MySQL server from any other location.
- I INPUT -p tcp –dport 3306 -m state –state NEW,ESTABLISHED -j ACCEPT -I OUTPUT -p tcp –sport 3306 -m state –state ESTABLISHED -j ACCEPT
- Start or restart the MySQL service.
- /sbin/service mysqld start
- Connect to the MySQL database using the MySQL CLI tool. You will be prompted for your password.
- /usr/bin/mysql -u root -p
- If needed, set your new password (if not already done above).
- /usr/bin/mysqladmin -u root password ‘new-password’
- or
- /usr/bin/mysqladmin -u root –password=’new-password’ -h hostname-of-your-server ‘new-password’]
That’s it!