Detailed steps for fully uninstalling and reinstalling MySQL in win10, win10mysql

Detailed steps for fully uninstalling and reinstalling MySQL in win10, win10mysql

I believe that you need to reinstall MySQL for various reasons. I had to replace 64-bit MySQL with 32-bit MySQL because of a problem connecting MySQL and Qt. The installation may cause various problems because the uninstallation is not clean. Now I have recorded the process of uninstalling and re-installing for your reference.

Step 1: stop the service

Start cmd-> enter services. msc-> Find mySQL-> stop SQL Service

Step 2: delete an object

Find your installation directory and delete all files

Step 3: delete the Registry

Start cmd-> enter regedit-> Search for mySQL, right-click to delete all (or find MySQL in the following path, right-click to delete)

HKEY_LOCAL_MACHINE/SYSTEM/ControlSet001/Services/Eventlog/Applications/MySQL HKEY_LOCAL_MACHINE/SYSTEM/ControlSet002/Services/Eventlog/Applications/MySQL HKEY_LOCAL_MACHINE/SYSTEM/CurrentControlSet/Services/Eventlog/Applications/MySQL

Step 4: configure the my. ini file

I downloaded the version is mysql-5.6.17-win32, zip archive, stored in D Disk

Create the my. ini file in the D: \ mysql \ mysql-5.6.17-win32 \ directory and write the following code:

[Mysql] # set the default character set of the mysql client default-character-set = utf8 [mysqld] # set port 3306 to port 3306 # set the mysql installation directory basedir = D: \ mysql \ mysql-5.6.17-win32 # Set the mysql database data storage directory datadir = D: \ mysql \ mysql-5.6.17-win32 \ data # maximum number of connections allowed max_connections = 200 # the character set used by the server defaults to the 8-bit latin1 character set character-set-server = utf8 # default storage engine default-storage-engine = INNODB

Note that the directory address should be replaced with your mySQL storage address.

Step 5: Install

Open cmd (run as Administrator)-> enter cdD: \ mysql \ mysql-5.6.17-win32 \ bin

If you enter mysqld install, the following error occurs:

The system prompts that the service has been installed.

Therefore, we need to continue entering mysqld-remove

The command is successfully run.

Re-enter mysqld install:

Reinstall successfully!

Enter net start mysql:

Prompt that the instance is started successfully.

Summary

The above is a detailed explanation of the steps for fully uninstalling and reinstalling MySQL in win10. I hope it will be helpful to you. If you have any questions, please leave a message for me, the editor will reply to you in a timely manner. Thank you very much for your support for the help House website!