====== Install & Configure MySQL ======

===== Installation =====

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

===== Configuration =====

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.

===== Security Considerations =====

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:
    * <code>
# 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
</code>
  * Restart MySQL for the changes to take effect.

===== Navigation =====

Previous: [[docs:install_configure_apache|]] | Next: [[docs:install_configure_php|]]