Use of the initial execution file at MySQL startup

You can specify the SQL file that is initially executed after mysql is started in the configuration file. The syntax is as follows: [mysqld] or [server:

You can specify the SQL file that is initially executed after mysql is started in the configuration file. The syntax is as follows: [mysqld] or [server:

You can specify the SQL file initially executed after mysql is started in the configuration file. Its syntax is:

In [mysqld] or [server], specify:

Init-file = D: \ mysql-5.5.28-winx64 \ abc. SQL, followed by the specific SQL file value

For example:

Abc. SQL:

After mysql is started, query:

After the second startup, the following result is displayed:

Of course, we should note that the content of this init_file is required:

1. Make sure that the -- disable-grant-options switch is not added during mysqld compilation.
2. Make sure that each line of the script specified by init-file is a specific executable statement.