How to modify the MySQL data path datadir in Windows?

This article mainly explains in detail how to change the MySQL data path datadir on Windows Server 2012. The content is quite good. It is worth taking a look. Friends who like it can pay attention.

Background description

Under Windows, MySQLInstallationThe path cannot be modified, nor can it be configured through the GUI interface;

默认安装路径 %mysql_root% = c:\program files\mysql\mysql server 5.7
默认数据路径 %mysql_data_root% = c:\programdata\mysql\mysql server 5.7|

This directory is hidden by default Directory, you need to set up and view

A 3T data disk is hung on the D drive for massive data storage;

You need to change the MySQL data path to

%mysql_new_data_root% = d:\mysql\data
Step-by-Step

Create directory: d:\mysql;

Set

%mysql_data_root%\data 复制至 %mysql_new_data_root%；

as the NETWORK SERVICE user and set the access permissions of %mysql_new_data_root% | Note: Mysql will not be started without setting! (Many online blogs This step has been missed);

Change the configuration file %mysql_data_root%my.ini | Note: slash direction;

Restart the MySQL service, and then it will be ok.

【Related recommendations】

1. Free mysql online video tutorial

2. MySQL latest manual tutorial

3. Boolean Education Yan Shiba mysql introductory video tutorial

The above is the detailed content of How to modify the MySQL data path datadir in Windows?. For more information, please follow other related articles on the PHP Chinese website!