Tutorial on reinstalling MySQL on Windows 64-bit (Zip version, decompressed version MySQL installation)

Uninstall MySQL

1. In the control panel, uninstall all components of MySQL

Control Panel -> All Control Panel Items -> Programs and Features, uninstall all programs related to MySQL

2. Find your MySQL installation path and see if there are any folders related to MySQL. Delete them all.

If it is installed on the C drive, check the two folders C:\Program Files (x86) and C:\Program Files

3. Delete the registry about MySQL

Enter "C:\Windows\regedit.exe" in the file explorer and the registry will pop up.

Delete the HKEY_LOCAL_MACHINE\SYSTEM\ControlSet001\Services\Eventlog\Application\MySQL folder

If you can find the following content, delete it

HKEY_LOCAL_MACHINE\SYSTEM\ControlSet002\Services\Eventlog\Application\MySQL

HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Eventlog\Application\MySQL

4. Paste the following red part into the address bar of the file explorer (this is a hidden folder)

C:\ProgramData\MySQL

Delete all contents in this folder

5. Restart your computer

Download MySQL

Official website address: https://dev.mysql.com/downloads/mysql/

1. After downloading, unzip the file to your preferred location

2. Add in the my.ini configuration file:

[mysqld]

##Port## port=3306

##You need to add character encoding settings (just put it below port)##

character-set-server=utf8

##File decompression path: ## basedir = "C:\\Program Files\\MySQL\\mysql-5.7.28-winx64\\"

##Database (data) storage path: ## datadir ="C:\\Program Files\\MySQL\\MySQLData\\" max_allowed_packet = 32M

3. Configure environment variables: (path) C:\Program Files\MySQL\MySQLData\;%MYSQL_HOME%\bin

4. Open cmd and go to the bin directory of the compressed package and run:

mysqld install mysql3306 --defaults-file="C:\Program Files\MySQL\mysql-5.7.28-winx64\my.ini"

mysql3306 is just a name. You can change it to your favorite name. After running, "Service successfully installed" will appear, indicating success.

5. Initialization statement C:\Program Files\MySQL\mysql-5.7.28-winx64\bin>mysqld --initialize After success

A lot of initial data will appear in the database (data) storage path you set

6. Start the service in cmd

C:\mysql-5.7.20-winx64\bin>net start mysql3306

7. Find the file ending with .err in the initialized file

Open the file and search for [Note] A temporary password is generated for root@localhost: followed by the initial password.

8. Log in to mysql:

Enter the command in cmd: mysql3306 -u root -p 初始密碼

To modify the password after logging in, run the command: mysql> set password for root@localhost = password('root');

Summarize

The above is the tutorial on how to reinstall MySQL on Windows 64-bit (Zip version, unzipped version MySQL installation). I hope it will be helpful to everyone. Thank you very much for your support of the 123WORDPRESS.COM website!