Detailed tutorial on MySQL installation

First of all, for my recent days a variety of computer installation database failure, reflect on the summary of all the ways. Now write a detailed tutorial, I hope other people less detours.

First, this content is divided into the following steps:

Complete removal of 1.mysql prior to installation

Selection of 2.mysql versions

3.mysql Green and full version only server-step resolution

4.mysql installation fails, how to use the free-install HDD version

A complete removal of MySQL before installation

First of all, the installation of MySQL for the failure to completely uninstall the operation, the process is more, because not clean up will cause the next installation failure.

Prerequisite: The tools to be prepared are: 1.ccleaner 2.everything,

This is the case after installation:

After the installation is complete, uninstall and clean up the following steps:

A: Turn on the computer-uninstall or change the program---Find the installed MySQL, click Uninstall. If MySQL is not found

Or it has been uninstalled, ignore this step, proceed to step b

B: After uninstalling, open everything, search for MySQL, remove all MySQL files, install packages or anything except.

One problem with this step is that if you don't have enough authority, this MySQL file in C:\ProgramData

cannot be deleted. A tutorial is presented below:

(1) win+r input Notepad

Copy the following content input

Windows Registry Editor Version 5.00
[Hkey_classes_root\*\shell\runas]
@= "Administrator Authorization"
"Noworkingdirectory" = ""
[Hkey_classes_root\*\shell\runas\command]
@= "cmd.exe/c takeown/f \"%1\ "&& icacls \"%1\ "/grant administrators:f"
"Isolatedcommand" = "cmd.exe/c takeown/f \"%1\ "&& icacls \"%1\ "/grant
Administrators:f "
[HKEY_CLASSES_ROOT\EXEFILE\SHELL\RUNAS2]
@= "Administrator Authorization"
"Noworkingdirectory" = ""
[Hkey_classes_root\exefile\shell\runas2\command]
@= "cmd.exe/c takeown/f \"%1\ "&& icacls \"%1\ "/grant administrators:f"
"Isolatedcommand" = "cmd.exe/c takeown/f \"%1\ "&& icacls \"%1\ "/grant
Administrators:f "
[Hkey_classes_root\directory\shell\runas]
@= "Administrator Authorization"
"Noworkingdirectory" = ""
[Hkey_classes_root\directory\shell\runas\command]
@= "cmd.exe/c takeown/f \"%1\ "/r/d y && icacls \"%1\ "/grant administrators:f/T"
"Isolatedcommand" = "cmd.exe/c takeown/f \"%1\ "/r/d y && icacls \"%1\ "/grant
Administrators:f/T "

Save as Administrator rights. Reg on the desktop

Then left-click Yes-OK.

Next, to the MySQL folder that cannot be deleted, right-click to open the path. Then right-click the Select Management

permissions, and then delete it.

C: Run CCleaner, delete redundant MySQL registry

Click Fix selected Issues ... -----No-----fix all selected issues; It is recommended to test multiple times for thorough removal

D: Clear the registry again, open Win+r input regedit enter

Clear the path for all MySQL files:

To this, remove the residue before MySQL installation succeeds.

Two MySQL versions of the selection

MySQL currently has a green simplified installation version, a full installation version and a free installation version.

The green version is the smallest, but it's easy to get stuck in the last step. We recommend that you download the full installation version to install only the Server service. If

Both methods fail and can only be configured for installation with a free install version.

Three MySQL Green edition and install only server installation steps resolved:

See this blog for the Green Edition installation:

Http://www.jb51.net/article/96898.htm

Only install server see this blog:

79518471

After four or more installation packages try to install failed, use the first step to uninstall clean and then configure with the free install version

Free installation version:

https://download.csdn.net/download/lf19820717/9892716

Start configuration after decompression

First: Open the Unpacked folder, locate the My-small file, and then open it with Notepad

Add red content to [mysqld] and [client] , where basedir and datadir = after content is the extracted path

Then configure the environment variables:

Added system variable mysql_home:c:\users\administrator\desktop\mysql-5.5.54-winx64 (unzipped path)
On the last side of the path variable, add:;%mysql_home%\bin

Open a command prompt (right-click Admin authorization and then open)

Input Mysqld--install

Service succesfully installed description successful

Important: The command prompt here does not use Administrator privileges to open the words input mysqld--install

There will be install/remove of the Service denied! error

Then enter the net start MySQL startup service

MySQL is a success.

Enter mysql-uroot-p at the command prompt to verify.

The above is to resolve the failure to install MySQL detailed methods. Where there are errors, you are welcome to point out.

Detailed tutorial on MySQL installation