After changing the MySQL DATA path (datadir) in windows, the service encountered 1067 problems and solved them.

After installing MySQL (System: Deep winxpsp2, MySQL version: 5.1.32) in the evening, you can use the configuration tool that comes with MySQL to configure the default data storage path: C: /Documents and Settings/all users/Application Data/MySQL Server 5.1/data /. I felt very uncomfortable. I always wanted to modify this path in the configuration tool and found "no way ". I had to manually modify my. ini. Result: The painful process starts. 1. Change the path to E:/dev/mysql5.1/data. Then restart the Service (start the service in Windows) the 1067 prompt is displayed. 2. Use the configuration tool to reconfigure the service. When the configuration tool reaches the Service Startup step, the error persists. 3. Open cmd, "net stop MySQL" "Net start MySQL" Continue 1067 4. Later, we found that the path E:/dev/mysql5.1/data does not exist, so we created and started the service again, delete my. INI is reconfigured and the service is started successfully, but datadir is changed to the default path. It can basically be determined that it is a datadir problem. Baidu has found many articles about which system directory to find my. INI modification. The file cannot be found at all. 5. When you enter E:/dev/mysql5.1/data, the folder is missing, and C:/Documents and Settings/all users/appl is opened. Ication data/MySQL Server 5.1/data/, wow, at last, two folders MySQL and test are frequently seen under phpMyAdmin (the next folder in the MySQL data directory is a library ), copy all contents in the default data directory to the custom data directory and restart the MySQL service. OK, it's a success.