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

I. Install MySQL

(1) Extract 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 relevant configuration of this file is:

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

(4) Open cmd.exe as administrator, enter bin file in mysql installation directory, and start installation.

First type mysqld -install to install, then net start mysql to start the service, then mysql can be entered with mysql -u root -p, first entry without password. exit, exit.

To change mysql password, you can use: mysqladmin -u username-p old password password new password

Grant all privileges on *.* to root@"%" identified by ". ";

flush privileges;

II. Complete deletion

(1) Stop the service, and then I should find the software at the beginning of mysql in the control panel to uninstall it, but I didn't find it. I chose to delete the installation file directly, prompting me that the file is occupied.

(2) Use cmd window command to delete mysql service sc delete mysql (mysql here refers to mysql service name)

(3) Delete the registry win+R and enter regedit Enter to enter the registry edit

Find HKEY_LOCAL_MACHINE\SYSTEM\ControlSet001\Services\Eventlog\Application\MySQL directory Delete

HKEY_LOCAL_MACHINE\SYSTEM\ControlSet002\Services\Eventlog\Application\MySQL directory deletion (I did not find this item in my computer, deleted the other two items, successfully deleted completely)

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

(4) I went to delete my installation file and still prompted me that the file was occupied, so I deleted it one by one from the subdirectory of the file. Later, I found that mysqld.exe under the bin directory had been prompted to be occupied, and I could not delete it.

At this point force delete it, enter cmd window, enter my mysql installation directory bin file, enter the command: mysqld.exe -remove, and then go to mysql installation directory to delete this file, you can successfully delete, delete the installation file,

At this point, MySQL is completely deleted, and another new version can be installed.

summary

The above is the mysql decompression method introduced by Xiaobian to you and the method of completely deleting it. I hope it will help you. If you have any questions, please leave a message to me. Xiaobian will reply to you in time. Thank you very much for your support!

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.