Installing from the command line

1. Import-Module BitsTransfer

2. Start-BitsTransfer https://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-5.7.23-winx64.zip
3. extractZipFile.ps1 c:\temp\mysql-5.7.23-winx64.zip C:\pf
4. cd \pf\mysql-5.7.23-winx64\bin
5. .\mysqld --initialize --console (make sure you have run the patch above before running this command)
6. A series of messages will traverse the screen, completing with the following statement “A temporary password is generated for root@localhost: xxxxxxxx”
7. 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.
8. Start MySQL using the command
   1. start mysqld --console
9. MySQL is now running as a background process
10. From Windows firewall enable the port that MySQL is on
11. Log in to mysql with the command - .\mysql -u root -p
12. Enter password: <autogenerated password>
13. alter user ‘root’@’localhost’ identified by ‘ppp’;
14. Use workbench or the console and a root user that can access the db from outside localhost