Hi,
To try to understand and solve this problem (I don't have a 4K Native hard drive), please do the following on your Wampserver installation on D: 4K native. I thank you for that.
We can try to create the MySQL data folder "by hand" and see what happens and, to avoid being bothered by MariaDB, we can start by not using it (temporarily) with Wampserver, so:
- Right-Click Wampmanager tray icon -> Wamp settings -> Allow MariaDB to uncheck it
We will now delete the MySQL service
- Left-Click Wampmanager tray icon -> MySQL -> Service administration -> Stop service
- Left-Click Wampmanager tray icon -> MySQL -> Service administration -> Remove service
And, to avoid having to spend time sorting out information from log files, we will empty them:
- Right-Click Wampmanager tray icon -> Tools -> Empty logs -> Empty all log files (Then y + Enter)
Exit Wampserver.
With Files Explorer, delete the totality of files and folders into wamp\bin\mysql\mysql5.7.19\data\ and the folder data itself.
Note: We delete the data folder because it was created by MySQL itself.
With Files explorer (Right-Click New) we create the data folder wamp\bin\mysql\mysql5.7.19\data\
Note: We create the data folder by the Windows system and not by MySQL
Exit Files Explorer
Open a command windows "as an administrator" (The word administrator MUST be in the title bar) on the folder wamp\bin\mysql\mysql5.7.19\bin\
In this command windows type :
mysqld.exe --initialize-insecure
This will recreate the content of data folder
Launch Wampserver (Icon will be not green)
(mysql.log should be empty)
Install MySQL service
- Left-Click Wampmanager tray icon -> MySQL -> Service administration -> Install service
(mysql.log should be empty)
Start MySQL service
- Left-Click Wampmanager tray icon -> MySQL -> Service administration -> Start/Resume service
Icon should be green now and there is no error in mysql.log
2018-02-18T10:01:37.841538Z 0 [Warning] InnoDB: Resizing redo log from 2*3072 to 2*320 pages, LSN=2539324
2018-02-18T10:01:37.950738Z 0 [Warning] InnoDB: Starting to delete and rewrite log files.
2018-02-18T10:01:37.997538Z 0 [Warning] InnoDB: New log files created, LSN=2539324
This has just been done in real time on my J: disk, but it is not 4K native.
---------------------------------------------------------------
Documentation Apache -
Documentation PHP -
Documentation MySQL -
Wampserver install files & addonsEdited 2 time(s). Last edit at 02/18/2018 05:54PM by Otomatic.