Super detailed teaching on how to upgrade the version of MySQL

1. Introduction

Upgrade mysql5.7 to mysql 8.0

Prepare two compression packages!

2. Back up the database

1.cmd enters the path in the original database

2. Enter the command

mysqldump -u root -p --all-databases > D:\JAVA_Installation\MySQL\data\Backup.sql

1. Your MySQL username. The username you usually use to log in to the database

2. Save the backup file path

3. Do not create the .sql file in advance, it will be created automatically.

The password will be entered.

Backup Success

3. Uninstall the original Mysql

111. Must do

Open a command window and enter net stop mysql to shut down the MySQL service, then delete the MySQL service input:

sc delete MySQL

1. Uninstall Mysql in the panel (if not, go to the next step)

2. Delete the MYSQL file in C:\Program Files or C:\Program Files (x86) (if not, go to the next step)

3. Delete the registry: windows+R run the "regedit" file and open the registry

(1) Delete registry 1: HKEY_LOCAL_MACHINE\SYSTEM\ControlSet001\Services\EventLog\Application\MySQLD Service

4. Delete C:\ProgramData\MySQL under C drive

Open hidden item option without data

5. Delete the directory: (if not needed)

6. Stop the Mysql service and delete all installation paths

Enter cmd, enter the old version of Bin, and enter mysqld -remove

Deleting a Directory

4. Restore the previous database

Open

Just execute the .sql once

This is the end of this article which teaches you in great detail how to upgrade the MySQL version. For more information on MySQL version upgrade, please search for previous articles on 123WORDPRESS.COM or continue to browse the following related articles. I hope you will support 123WORDPRESS.COM in the future!