MySQL Settings

Configuration File Location:
for Windows 7:  C:\ProgramData\MySQL\MySQL Server 5.6\my.ini


How to move database to different directory

1. Stop the MySQL instance service.
2. Copy the data directory to the location where the new data directory should be.
3. Giving a full control privileges to user NetworkService on the new data directory, otherwise the service won't start.