MySQL Free install version

MySQL Free install version

Http://www.cnblogs.com/niuniutry/p/3555778.html

Http://www.cnblogs.com/vforbox/p/4828151.html

"Solution" MySQL-5.7.9 Service failed to start-"NET helpmsg 3534"

http://blog.csdn.net/i_am_wangbo/article/details/49999407

[download MySQL 5.6.13]

From the MySQL official website mysql.com find the MySQL Community Server 5.6.13 for http://dev.mysql.com/downloads/mysql/, where you can choose the operating system platform. Hongo selected the Microsoft Windows platform. Here are three optional download files, the first of which is MySQL Installer 5.6 for Windows, which will download an. msi executable installation file. There are also two uncompressed versions (Zip version), namely Windows (x86, 64-bit), Zip Archive and Windows (x86, 32-bit), Zip Archive. Downloaded, respectively, are Mysql-5.6.13-winx64.zip and mysql-5.6.13-win32.zip. Hongo chose Windows (x86, 64-bit), ZIP Archive, because my server operating system is Windows 64bit R2.

[install MySQL 5.6.13]

Download the ZIP package has 212MB, downloaded for a few minutes just fine.

1, unzip the mysql-5.6.13-winx64.zip to the D:\mysql-5.6.13\ directory.

2, clean up the debug files inside
Open this directory, found inside the folder and files with a installed after the MySQL basically no difference. Perhaps you will be very depressed, this MySQL5.6.13 incredibly has 1.04GB, hehe, look carefully you will find, inside has very have debug file. A suffix of. lib or. pdb can actually be removed. There are also some directories called Debug, also deleted. This is not a lot smaller.

3. Create My.ini as MySQL configuration file
By default there is no My.ini file, which requires us to create one manually. How to create it? Do you have a template like php.ini? In fact, in the MySQL5.6.13 with a my-default.ini, can be counted as a template, but the contents of the inside is too little. So Hongo take everyone to create a my.ini by hand.
Create a text file directly, named My.ini. Open it and enter the following:

[Mysqld]

#绑定IPv4和3306端口
Bind-address = 0.0.0.0
Port = 3306

# set up the MySQL installation directory
basedir=d:/mysql-5.6.13

# Set up a storage directory for MySQL database data
Datadir=d:/mysql-5.6.13/data

# Maximum number of connections allowed
max_connections=200

Well, the parameters required for such a basic MySQL environment are sufficient.

4. Install MySQL as a service
Open a cmd.exe, switch directory to D:\MySQL-5.6.13\bin, run: Mysqld-install, prompt service installation succeeded! (The WIN8 administrator runs the command line). Run Services.msc A look, there really is a service called MySQL, start it.
Delete Service Mysqld-remove

By this, MySQL5.6.13 has been able to use the normal.

--------------------------------------------------------------------------------------------------------------- --------------------------------------------------------------------------------------------------------------- ----------

Installation process reference from: MySQL 5.6 for Windows uncompressed version configuration installation

After successful installation, start MySQL, enter:

[HTML]View PlainCopy

1. net start MySQL

Tips:

[HTML]View PlainCopy

1. "The MySQL service failed to start and the service did not report any errors, please type NET helpmsg 3534 for more help." ”

Check below, enter in the current directory:

[HTML]View PlainCopy

1. Mysqld--initialize

or error, and checked again, the reason is:

Mysqld--initialize-insecure automatically generates a root user without a password, mysqld--initialize automatically generates a root user with a random password. The Data folder is not empty and cannot execute this command.

Workaround:

[HTML]View PlainCopy

1. Delete all files in the data directory or remove them.

The MySQL service started successfully.

Reference from: 20 floor and 30 floor of http://bbs.csdn.net/topics/391851148.

MySQL Free install version