I try to install mysql db server on windows 10.
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?
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.