After installing MySQL at night (System: Deepin WINXPSP2, MySQL version: 5.1.32), the default data storage path is configured with MySQL's own configuration tool: C:/Documents and Settings/all users/ Application Data/mysql/mysql Server 5.1/data/. Feel very uncomfortable, the modification has always wanted to modify this path in the Configuration tool, the results found "NO way." Had to manually modify the My.ini. As a result, the painful journey begins:
1, the modified path is: E:\dev\MySQL5.1\Data, the result of restarting the service (start in the Windows service) will appear 1067 prompt
2, then hurriedly with the configuration tool reconfiguration, when the configuration tool to start the service that step continues to error
3. Open cmd, "net stop MySQL" "net start MySQL" continue 1067
4, later found E:\dev\MySQL5.1\Data this path does not exist, so create, continue to start the service, still this problem, so delete My.ini reconfiguration, the service started successfully, but DataDir became the default path, basically can be concluded that datadir problem , Baidu found a lot of articles said to what system directory to find My.ini changes, the results can not find this file
5, enter E:\dev\MySQL5.1\Data always feel less folder, so open c:/documents andsettings/all users/application data/mysql/mysql Server 5.1/ data/, Wow, finally appeared in the phpMyAdmin under the usual see MySQL and test two folders and other files (MySQL Data directory next folder is a library), so copy all the contents of the default data directory under the custom data directory, Restart the MySQL service. OK, finally the 1000.
Turn the family's: http://www.itblog.org/read.php?id=138 plus own
Basedir= "C:/Program files/mysql/mysql Server 5.1/"
Datadir= "D:\java\mysql" (note that the wording here is \ not/)
Reprint: http://blog.sina.com.cn/s/blog_a8d86cc60101cg4b.html
After you change the MySQL data path (datadir) under Windows, service startup 1067 resolves that the MySQL database storage location cannot be changed