MySQL installation, startup

First, install, configure environment variables

Http://www.cnblogs.com/mr-wid/archive/2013/05/09/3068229.html

Configure environment variables: Copy your installation directory, for example: G:\DownLoad\MySQL5.6 64-bit Green version \mysql-5.6.17-winx64\bin

Then open Control Panel system and security system advanced system settings System Properties popup Advanced tab last line environment variable user variable "PATH edit"

Put the copy of the installation directory just now, add to the inside, notice and the previous path in English semicolon; Separated

For example: C:\Users\tcdcr\.dnx\bin; G:\DownLoad\MySQL5.6 64-bit Green edition \mysql-5.6.17-winx64\bin

When finished, go to the bin directory, run Mysqld.exe, and then open the command line, enter mysqld--install MySQL--defaults-file= "My.ini", enter.

Configuration of the My.ini,

# Basedir = G:\DownLoad\MySQL5.6 64-bit Green version \mysql-5.6.17-winx64
# DataDir = G:\DownLoad\MySQL5.6 64-bit Green version \mysql-5.6.17-winx64\data

Basedir is the installation directory, DataDir is the database storage directory, many people on the internet said must be the Data folder, I have not tried it.

Second, uninstall the service note

Do not uninstall the service easily, otherwise an exception occurs: The configuration information for this product is corrupted, please contact your technician.

This problem I did not find the right solution, online said to download a green version, run Mysqld.exe, try it, can.

Third, the service started

After completion, in the system services have MySQL this service, enter, start, error: The system cannot find the specified file.

Cause: In the properties of the MySQL service, the executable file path is not correct, modify the method:

Open registry regedit, find the MySQL entry, which has a configuration ImagePath, change the path to your correct installation directory,

Example: "G:\DownLoad\MySQL5.6 64-bit Green edition \mysql-5.6.17-winx64\bin\mysqld"--defaults-file=my.ini MySQL

G:\DownLoad\MySQL5.6 64-bit Green Edition \mysql-5.6.17-winx64\bin\mysqld this point is mysqld.exe.

This is the time to start the service, and the command line can start: net start MySQL

MySQL installation, startup