Install & Configure MySQL

If not included as part of the initial Linux installation, install MySQL & dependencies.

Follow the documentation for starting MySQL for the first time & run the 'mysql_secure_installation' script to:

• Set the MySQL root password.
• Remove anonymous users.
• Disallow root login remotely.
• Remove test database.
• Reload privilege tables.

The following are optional, but recommended, steps to help improve the security of your ReadingRecord server.

• Per the MySQL config file '/etc/my.cnf', disable symbolic-links to prevent assorted security risks.
• Since Apache & MySQL are running on the same server, there's no need for MySQL to listen on a network port, so disable this as well.
• Options should be placed in the '[mysqld]' section of the config file, code snippets look like this:

  • # Disabling symbolic-links is recommended to prevent assorted security risks;
    # to do so, uncomment this line:
    symbolic-links=0
    
    # Don't listen on a network port
    skip-networking

• Restart MySQL for the changes to take effect.

Previous: Install & Configure Apache | Next: Install & Configure PHP