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:
    • # 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.

Navigation

 
docs/install_configure_mysql.txt (1617 views) · Last modified: 2013/04/04 17:18 by esisler