Important
MySQL Server - Visual Studio Redistribution 2013 for VS 12 - fixes problem with running MySQL on Windows Server 2012 R2
https://support.microsoft.com/en-us/help/3179560/update-for-visual-c-2013-and-visual-c-redistributable-package
The file is available here if the above link is broken
Installing from the command line
Import-Module BitsTransfer
- Start-BitsTransfer https://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-5.7.23-winx64.zip
- extractZipFile.ps1 c:\temp\mysql-5.7.23-winx64.zip C:\pf
- cd \pf\mysql-5.7.23-winx64\bin
- .\mysqld --initialize --console
- A series of messages will traverse the screen, completing with the following statement “A temporary password is generated for root@localhost: xxxxxxxx”
- Make a note of the password, do not lose it. If you do lose the password, delete the whole of the MySQL folder and repeat from step 24.
- Start MySQL using the command
- start mysqld --console
- MySQL is now running as a background process