...
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 (make sure you have run the patch above before running this command)
- 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
- From Windows firewall enable the port that MySQL is on
- Log in to mysql with the command - .\mysql -u root -p
- Enter password: <autogenerated password>
- alter user ‘root’@’localhost’ identified by ‘ppp’;
- Use workbench or the console and a root user that can access the db from outside localhost