Bagaimana cara menginisialisasi direktori data mysql?

Disediakan oleh. mysql-server-inti-5. 7_5. 7. 21-1ubuntu1_amd64 mysql_upgrade(1). • If the data directory does not exist but mysql_install_db fails, you must remove any partially created data directory before running mysql_install_db again. • Invocation syntax before MySQL 5.7.5: shell> scripts/mysql_install_db [options] Because the MySQL server, mysqld, must access the data directory when it runs later, you should either run mysql_install_db from the same system account that will be used for running mysqld, or run it as root and specify the --user option to indicate the user name that mysqld will run as. It might be necessary to specify other options such as --basedir if mysql_install_db does not use the correct location for the installation directory. For example: shell> bin/mysql_install_db --user=mysql \ --basedir=/opt/mysql/mysql \ --datadir=/opt/mysql/mysql/data Note After mysql_install_db sets up the InnoDB system tablespace, changes to some tablespace characteristics require setting up a whole new instance. This includes the file name of the first file in the system tablespace and the number of undo logs. If you do not want to use the default values, make sure that the settings for the innodb_data_file_path and innodb_log_file_size configuration parameters are in place in the MySQL configuration file before running mysql_install_db. Also make sure to specify as necessary other parameters that affect the creation and location of InnoDB files, such as innodb_data_home_dir and innodb_log_group_home_dir. If those options are in your configuration file but that file is not in a location that MySQL reads by default, specify the file location using the --defaults-extra-file option when you run mysql_install_db. Note If you have set a custom TMPDIR environment variable when performing the installation, and the specified directory is not accessible, mysql_install_db may fail. If so, unset TMPDIR or set TMPDIR to point to the system temporary directory (usually mysql_config_editor(1). If the --login-path option is specified, the user, host, and password values are taken from the login path and used to create the administrative account. The password must be defined in the login path or an error occurs, unless the --insecure option is also specified. In addition, with --login-path, any --admin-host and --admin-user options are ignored. This option was added in MySQL 5.7.5. • --mysqld-file=file_name The path name of the mysqld binary to execute. The option value must be an absolute path name or an error occurs. If this option is not given, mysql_install_db searches for mysqld in these locations: • In the bin directory under the --basedir option value, if that option was given. • In the bin directory under the --srcdir option value, if that option was given. • In the bin directory under the --builddir option value, if that option was given. • In the local directory and in the bin and sbin directories under the local directory. • In //www.gnu.org/licenses/.

LIHAT JUGA

For more information, please refer to the MySQL Reference Manual, which may already be installed locally and which is also available online at //dev.mysql.com/doc/. _

PENGARANG

Oracle Corporation (//dev.mysql.com/).

Bagaimana cara menginisialisasi direktori data di MySQL 8?

Di mana direktori data MySQL?

Apa direktori data default di MySQL?

Bagaimana cara mengubah direktori data di MySQL?