Shulou(Shulou.com)06/01 Report--

Uninstall MySQL

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

Control Panel-- "all Control Panel items--" programs and functions, uninstall all MySQL-related programs

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

If installed on disk C, check the folders C:\ Program Files (x86) and C:\ Program Files

3. Delete the registry about MySQL

Entering "C:\ Windows\ regedit.exe" in File Explorer pops up the registry

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

If you can find the following, delete

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

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

4. Paste the following scarlet letter into the File Explorer address bar (this is a hidden folder)

C:\ ProgramData\ MySQL

Delete everything under this folder

5. Restart the computer

Download MySQL

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

1. After the download is complete, extract the file to your favorite location

2. Add: in the my.ini configuration file:

[mysqld]

# # Port # # port=3306

# # need to add settings for character encoding (just put it under port) # #

Character-set-server=utf8

# # path to decompress files: # # 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 package to 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 the name you like. After running it, Service successfully installed appears to indicate success.

5. Initialization statement C:\ Program Files\ MySQL\ mysql-5.7.28-winx64\ bin > mysqld-- after initialize is successful

There will be a lot of initial data in the storage path of the database (data) you set.

6. Start the service in cmd

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

7. Find the file at the end of .err in the initialization file

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

8. Log in to mysql:

Enter the command in cmd: mysql3306-u root-p initial password

Change password command after login: mysql > set password for root@localhost = password ('root')

Summary

The above is the tutorial of Windows 64-bit reinstallation MySQL (Zip version, decompressed version MySQL installation) introduced by Xiaobian. I hope it will be helpful to you, and thank you very much for your support to the website!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.