mysql_install_db

• mysql_install_db initializes the MySQL data directory and creates the system tables that it contains, if they do not exist.
  • Because the MySQL server, mysqld, needs to access the data directory when it runs later, one should either runmysql_install_db from the same account that will be used for running mysqld or run it as root and use the --user option to indicate the username that mysqld will run as.

• Use the following syntax to invoke mysql_install_db:

  mysql_install_db [options]

• mysql_install_db supports the following options:
  • --basedir=path
    • The path to the MySQL installation directory.
  • --force
    • Causes mysql_install_db to run even if DNS does not work.
    • In that case, grant table entries that normally use hostnames will use IP addresses.
  • --datadir=path, --ldata=path
    • The path to the MySQL data directory.
  • --rpm
    • This option is used by RPM files during the MySQL installation process.
  • --skip-name-resolve
    • Use IP addresses rather than hostnames when creating grant table entries.
    • This option can be useful if DNS does not work.
  • --srcdir=path
    • The directory under which mysql_install_db looks for support files such as the error message file and the file for populating the help tables.
    • This option was added in MySQL 5.0.32.
  • --user=user_name
    • The login username to use for running mysqld.
    • Files and directories created by mysqld will be owned by this user.
    • One must be root to use this option.
    • By default, mysqld runs using the current login name.
  • --verbose
    • Print more information about what the program does.
  • --windows
    • This option is used for creating Windows distributions.

What is mysql_secure_installation?

---

---

© 2007 John Michael Pierobon

Notes