Use of file Init-file when MySQL starts

In the configuration file, you can specify the SQL file that was initially executed after MySQL startup, with the following syntax:

Under [mysqld] Specify:

Init-file= "D:/mysql/test.sql", followed by a specific SQL file value.

Note that the following two o'clock is OK:

1. Make sure your mysqld compiles without the  --disable-grant-options switch. 2. Ensure that each line of the script specified by Init-file is a specific statement that can be executed.

Don't say much nonsense (mysql7 I used above). Straight into the subject: Test.sql:

 Usetest; begin; Create Table if  not existstest123 (IDint); Insert  intoTest123Values(1); Insert  intoTest123Values(2); Select *  fromtest123; --drop table test123; End;

After you start MySQL, you get a query to see

Use of file Init-file when MySQL starts