Post-Installation Procedures

• Grant tables are set up by the mysql_install_db program.
  • When MySQL is installed on Linux using RPM distributions, the server RPM runs mysql_install_db

• To initialize the grant tables, run one of the following commands from the base directory, depending on whether mysql_install_db is located in the bin or scripts directory:
  • bin/mysql_install_db --user=mysql
  • scripts/mysql_install_db --user=mysql

• mysql_install_db needs to be run only the first time MySQL is installed.
  • It may be omitted if upgrading an existing installation.
  • mysql_install_db does not overwrite any existing privilege tables.
    • It should be safe to run in any circumstances.

• The mysql_install_db script creates the server's data directory.
  • Under the data directory, it creates directories for the mysql database that holds all database privileges and the test database for testing MySQL.
  • The script also creates privilege table entries for root and anonymous-user accounts.
  • Initially, the accounts have no passwords.

• The database directories and files need to be owned by the mysql login account so the server has read and write access to them.
  • Use the --user option if mysql_install_db is as root.

• To re-create the privilege tables:
  • First stop the mysqld server if it is running.
  • Then rename the mysql directory under the data directory to save it.
  • Then run mysql_install_db

How do I start the server?

---

---

© 2007 John Michael Pierobon

Notes