MySQL modify master database

The original text is reproduced to ：mysql modify the database data Storage location - Y archives Y - Blog Garden

After the change , The service restart is unsuccessful. The solution is as follows ：

1、 Modify folder permissions , increase Network Service User to folder permissions , And set to all permissions

2、 Control panel - Management tools - Computer management - Local users and groups

2.1、Administrators Add to group Network Service

3、 If the above does not work , Then the configuration file my.ini The file needs to be saved as ANSI File format

original text ：MySQL Abnormal startup after changing the directory of the database file - Data pie - Blog Garden

Make sure that the encoding of the configuration file is ANSI

have access to notepad Other compilation tools , View encoding , Not ANSI The configuration file of encoding format is in Windows in MySQL Can't read , You can also create a new one directly ANSI Configuration file for , Copy and replace the original content .

summary ：

    Windows The permission control and coding format of are complex , Unlike linux So intuitive , In operation Windows You need to pay extra attention to the prompt of these permission and code changes when you file . Modify the configuration file and try to use more functional compilation tools , Don't use Notepad directly to modify .

4、 About MySQL Summary of problems in batch inserting data ：

MySqlBulkLoader Problems encountered in batch upload and solutions - Looking for the lost lamb - Blog Garden