[troubleshooting] common problems and solutions when installing MySQL in Windows system

Preface ：
Author's brief introduction ： Husky who yearns for power , You can call me Siberian Husky , One devoted to TFS - The whole stack Empowered bloggers
CSDN Blog expert certification 、 Nova plan Season 3 full stack track top_1 、 Huawei cloud sharing expert 、 Alibaba cloud expert Blogger
If there is something wrong with the knowledge of the article , Please correct me. ！ Learn with you , Progress together
The motto of life ： Being superior to some other man , Is not high , The true nobility is to be superior to one's former self .
If you feel the blogger's article is good , Please pay attention. 、 give the thumbs-up 、 Collect three companies to support bloggers

---

Column series （ Click unlock ）	Learning route （ Click unlock ）	Knowledge orientation
Python Full stack white paper	Zero foundation beginner level chapter	Easy to get started in an easy to understand way , Let you fall in love with Python The charm of .
	Advanced Grammar	Mainly around multi-threaded programming 、 Regular expression learning 、 Including project exercises close to actual combat .
	Office automation	Realize the automatic operation of daily office software , Save time 、 Improve office efficiency .
	Automation test practice	From the perspective of actual combat , One step ahead , Rapid transformation test development engineer .
	Database development practice	Master the knowledge of relational and non relational databases , Improve the actual development ability of the database .
	Introduction and practice of reptile	Updating
	Data analysis	Updating
	Introduction to the front +flask Full stack	Updating
	django+vue Full stack	Updating
	expand - Introduction to artificial intelligence	Updating
The road to network security	Stepping on a pit	Record the pit encountered during learning and drilling , It is convenient for those who come from behind to catch up
	Net security literacy	Three days fishing , No deep understanding of the principle , It will only make you a script boy .
	vulhub The loopholes in the shooting range reappear	Make it easy to reproduce vulnerabilities , Let security researchers focus more on the vulnerability principle itself .
	shell Programming	Don't involve linux Basics , The final case will be in the direction of safety reinforcement . [ To be finished ]
	WEB Vulnerability attack and defense	2021 year 9 month 3 Stop updating on , Move to safe communities such as prophet community and small secret circles
	Collection of penetration tools	2021 year 9 month 3 Stop updating on , Move to safe communities such as prophet community and small secret circles
A little Engineer	Test artifact - Charles	Software test data packet capture analysis artifact
	Test artifact - Fiddler	Learn to fiddle , Learn not to stand upside down and eat , Rarefied ！
	Test artifact - Jmeter	Not just a performance test artifact , It can also be used to build a lightweight interface automation testing framework .
	RobotFrameWork	Python Automatic test tool realized , This chapter only introduces UI Automation part .
	Java Realization UI automation	Document written in 2016 year ,Java Realized UI automation , It still has reference significance .
	MonkeyRunner	There are not many application scenarios for this tool at present , The document has been deleted , Only for the sake of good typesetting .

stay WIndows System installation MySQL when , Sometimes the installation or link fails , The solutions of the two scenarios are summarized below , I hope I can help you .

1、 Missing patch package

The solution is as follows ：

In fact, this is because there is no installation KB2999226 Patch caused , Click to see “ Log files ”, There's a line in it “C:ProgramDataPackage CacheFC6260C33678BB17FB8B88536C476B4015B7C5E9packagesPatchdWindows8.1-KB2999226-x64.msu" /quiet /norestart’”;

This shows that the patch is brought , But its installation failed , Click this patch directly , An error will pop up “ This update does not apply to your computer ”;

First, install 2919355 Patch No , Download address ：https://support.microsoft.com/zh-cn/kb/2919355

2、 Previously installed mysql, But not unloaded clean

• 1、 Go to the control panel and put mysql Delete .
• 2、 To c disc C:Program Files Under the catalogue mysql Directory delete .
• 3、 If there are settings on other disks, the directory should also be deleted , Empty directories should also be deleted .
• 4、 eliminate MYSQL Data storage directory , Generally in C:Documents and SettingsAll UsersApplication DataMySQL Under the table of contents （ Need to pay attention to when Application Data This folder is hidden by default , To pass the Tools -> Folder options -> see -> Show all files and folders To set hidden files visible ）, Delete MySQL Folder
• 5、win+r The shortcut key opens " function ", Input regedit , Open the registry ：
  • 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
  • Some words , Delete all ！（ skill ： use F3 Loop search "mysql"）
• 6、 If the task manager is about mysql The content was also deleted .
• 7、 Turn off the firewall .
• 8、 Restart the computer and reinstall .

---

Be careful ： Here, if you do not restart the computer, a Red Cross will appear in the third step of reinstallation .

3、 Other mistakes

The solution is as follows ：

Didn't finish the last few steps , At this time root The password of is empty , No password , You can use it directly root The user login

adopt root After entering, you can create a new user

---

Carry out orders ：

use mysql;

CREATE USER 'dev'@'localhost' IDENTIFIED BY 'dev123';

flush privileges;

So at this point ： User name is dev, password dev123