where is mysql server's default data folder in windows 7

user_253401 0
Viewed 71933

I am looking for the data directory of mysql server (5.1.42) I installed on my machine which runs win7.

There is no 'data' direcotory in C:\Program Files\MySQL\MySQL Server 5.1 and also in C:\Users\MyAccount\AppData\Local||LocalLow||Roaming

mysql windows
11 Answers

After changing the directory, the root password is reset. So, keep in mind, if you change the directory, and have access issues, try to access it without a password then set a new password.

user_12816550

For newer users: The data directory lies in C:\Program Files\MySQL\MySQL Server 8.0\data

I currently have MySQL Server 8.0. If you too, are searching for some error solutions and couldn't find the "data" directory for MySQL, here's a note from the official MySQL:

"The default data directory location is C:\Program Files\MySQL\MySQL Server 8.0\data, or C:\ProgramData\Mysql on Windows 7 and Windows Server 2008. The C:\ProgramData directory is hidden by default. You need to change your folder options to see the directory and contents."

Hope this clears some hurdles

user_131659260
Related