mysql_install_db位置_MySQL数据库的初始化mysql_install_db

一、mysql_install_db说明

当MySQL的系统库(mysql系统库)发生故障或需要新加一个mysql实例时，需要初始化mysql数据库。

需要使用的命令：/usr/local/mysql/bin/mysql_install_db

#/usr/local/mysql/bin/mysql_install_db --help 可以查看帮助信息如下

Usage: /usr/local/mysql/bin/mysql_install_db [OPTIONS]

--basedir=path      The path to the MySQL installation directory.

--cross-bootstrap   For internal use.  Used when building the MySQLsystem

tables on a different host than the target.

--datadir=path      The path to the MySQL data directory.

--force             Causes mysql_install_db to run even if DNS does not

work.  In that case, grant table entries thatnormally

use hostnames will use IP addresses.

--ldata=path        The path to the MySQL data directory.

--rpm               For internal use.  This option is used by RPMfiles

during the MySQL installation process.

--skip-name-resolve  Use IPaddresses rather than hostnames when creating

grant table entries.  This option can be usefulif

your DNS does not work.

--srcdir=path       For internal use.  The directory under which

mysql_install_db looks for support files such as the

error message file and the file for popoulating the