Question :
I try to install mysql db server on windows 10.
Version mysql-installer-community-5.7.16.0.msi
During the installation Install MSI does not offer to change the installation directory.
Do I correctly understand that I can’t change the installation directory during the installation process?
Answer :
There are two methods available, either use ZIP archive to install or you may have to change the datadir variable in my.ini after installation. You can use following steps
-
Complete the installation
-
Identify the config file and then look for related datadir being used, you may used mysql>show variables like ‘datadir’ within mysql to identify datadir or the service details for concerned my.ini
-
Stop the service if it is already running
-
Change the value of datadir in my.ini, it is usually placed under C:ProgramDataMySQL
-
Copy/move the folder contents to newer location
- Make sure permissions are provided to user who owns mysql service
- Start service and verify using mysql>show variables like ‘datadir’
Hope it helps
You can make the following steps:
- Manually create folder
C:Program filesMySQLMySQL Server 5.7
(this is in 64 bits version) - Run the installer normally
Create an empty folder, although is empty folder, makes the installer allow you to choose another location.