Install and delete mysql by decompression, and decompress mysql

Install and delete mysql by decompression, and decompress mysql

1. Install mysql

(1) decompress the downloaded mysql compressed file to the directory where mysql needs to be installed.

 

(2) Open the decompressed folder, copy the default. ini file, and rename it my. ini. The configuration of this file is as follows:

 

(3) Add the mysql installation Path to the Path variable in the system environment variable configuration.

 

(4.exe open cmd.exe with the administrator ID, enter the binfile In the mysql installation directory, and start Installation

First, enter mysqld-install, then enter net start mysql to start the service, and then you can use mysql-u root-p to enter mysql. The first time you enter mysql, there is no password. Exit.

 

To change the password of mysql, you can use mysqladmin-u username-p old password New password

Grant all root permissions: grant all privileges on *. * to root @ "%" identified ".";

Flush privileges;

 

Ii. Completely Delete

(1) stop the service, and then find the software starting with mysql in the control panel to uninstall it, but I didn't find it. I chose to delete the installation file directly, prompting that my file is occupied.

(2) run the cmd window command to delete the mysql service SC delete mysql (mysql here refers to the mysql service name)

(3) Delete the Registry win + R and enter regedit and press enter to go to registry editing.

Find the HKEY_LOCAL_MACHINE \ SYSTEM \ ControlSet001 \ Services \ Eventlog \ Application \ MySQL directory to delete it.

HKEY_LOCAL_MACHINE \ SYSTEM \ ControlSet002 \ Services \ Eventlog \ Application \ MySQL directory is deleted (this item is not found in my computer. The other two items are deleted and completely deleted)

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

The "deleted" command is always prompted to be occupied, but it cannot be deleted,

Delete it forcibly. In the cmd window, enter the binfile In the mysql installation directory, enter the command mysqld.exe-remove, and then delete the file in the mysql installation directory, delete the installation file,

So far, MySQL has been completely deleted and another new version can be installed.