Mysql 8 upgrade in Windows with Zip installation

 

1. Download Mysql8 Zip files 

https://dev.mysql.com/downloads/file/?id=509736

2. Extract the Zip file

3. Paste the my.ini file into the unzip folder from the local(local)

4. create the Mysql 8 instance, open the command prompt with Mysql8 bin path 

mysqld --initialize-insecure --basedir="D:\Mysql3\mysql-8.0.26-winx64\bin"  --datadir="D:\Mysql3\mysql-8.0.26-winx64\Data"

mysqld --install MysqlZip8 --defaults-file="D:\Mysql3\mysql-8.0.26-winx64\my.ini"

5. Start the service

6. login to mysql server with root user and empty password

7. set the password for root user

alter user 'root'@'localhost' identified by 'P@ssw0rd';

flush privileges;

8. Stop the Mysql8 service

9. Stop the Mysql7 service

10. Change the datadir in Mysql8 my.ini as Mysql5.7 datadir path.

11. Start the Mysql8 service