What should I do if mysql my.ini does not take effect?

Mysql my.ini does not take effect Solution: 1. Press the "Win R" key to pop up the run window, and then enter "regedit"; 2. Open "HKEY_LOCAL_MACHINE->SYSTEM-" in the registry editor. >CurrentControlSet->Services->MySQL56”; 3. Modify the ImagePath configuration.

The operating environment of this tutorial: Windows 10 system, mysql version 5.6, Dell G3 computer.

mysql my.ini What to do if it doesn’t take effect?

Windows10 installs mysql 5.6. Modifying my.ini in the installation directory does not take effect after restarting.

The installation directory is as follows: C:\Program Files\MySQL\MySQL Server 5.6. No matter how you modify my.ini in the current directory, it will not take effect. The reason is that mysql startup does not necessarily read this configuration file.

How to find the configuration read by mysql, the answer is in the registry.

Win R The run window pops up, enter regedit

and open it in the registry editor: HKEY_LOCAL_MACHINE-->SYSTEM-->CurrentControlSet-- >Services-->MySQL56

Find ImagePath according to the path, double-click, and the edit string will pop up to find this setting.

Modify this configuration, or modify my.ini in this directory.

Recommended study: "MySQL Video Tutorial"

The above is the detailed content of What should I do if mysql my.ini does not take effect?. For more information, please follow other related articles on the PHP Chinese website!