Shulou(Shulou.com)06/01 Report--

How does mysql change the path to save data? This problem may be often seen in our daily study or work. I hope you can gain a lot from this question. The following is the reference content that the editor brings to you, let's take a look at it!

Mysql changes the path of data storage: 1, stop the mysql service; 2, open the my.ini configuration file; 3, find the datadir field, modify the save path; 4, execute the [net stop mysql] command to restart the mysql service.

Specific methods:

1. Stop the mysql service

Net stop MySQL

2. Make the following modifications in the my.ini file (mine is in C:\ ProgramData\ MySQL\ MySQL Server 5.7 directory):

3. Restart the mysql service

Enter the following command on the command line as an administrator

Net start MySQL, thank you for your reading! After reading the above, do you have a general idea of how mysql changes the data storage path? I hope the content of the article will be helpful to all of you. If you want to know more about the relevant articles, you are welcome to follow the industry information channel.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.