MySQL Compression package version of the installation method of the detailed

MySQL installation can have MSI installation and zip decompression two kinds of installation methods. The zip archive is extracted to the directory, and it needs to be configured to use it. The following is a detailed description of the installation method of the MySQL compression package version, if this article has an incorrect understanding, I hope you correct, thank you very much.

First, download the MySQL archive package file.

: http://dev.mysql.com/downloads/mysql/

① Select the appropriate MySQL version:

② according to the computer system to select the appropriate version, click Download to go to the jump page for no login download (that is, no need to register on the site): 1, shown in Figure 2

Click "No Thanks, just start my download." Start download

Second, the compression package decompression installation. Can be installed in any system disk, I am accustomed to install under the D disk, so in the D disk under the new MySQL folder to store MySQL files (do not and I do not know how to extract files). Directory structure: D:\mysql\mysql-5.6.33-winx64. In this step, many beginners will run the directory directly D:\mysql\mysql-5.6.33-winx64\ Bin of the Mysql.exe file, and then pop up a box, flash a bit disappeared, because the MySQL service has not been installed, so far just download the compressed package and then extract to the appropriate directory. Here's how to install the MySQL service and see how I'm faking ...

1, configure the My.ini file.

In D:\mysql\mysql-5.6.33-winx64\ (note this directory to be and your own directory, I download here is version 5.6, if you download the 5.5 version, this directory is not the same directory to create a new configuration file, the file name My.ini, and then copy the following configuration code to the My.ini (the path in the code to change to their own file storage path).

Code:

[MySQL]
# Set the MySQL client default character set
Default-character-set=utf8
[Mysqld]
#设置3306端口
Port = 3306
# set up the MySQL installation directory
Basedir=d:\mysql\mysql-5.6.33-winx64
# Set up a storage directory for MySQL database data
Datadir=d:\mysql\mysql-5.6.33-winx64\data
# Maximum number of connections allowed
max_connections=200
# The character set used by the service side defaults to the 8-bit encoded latin1 character set
Character-set-server=utf8
# The default storage engine that will be used when creating a new table
Default-storage-engine=innodb

2. Install MySQL service:

Run as administrator to find this cmd.exe in the C:\Windows\System32 directory, be sure to run as administrator, or the installation will not succeed. After you open the CMD window as an administrator, switch the directory to the bin directory where you unzipped the files, and then enter mysqld install to run on the line, note that it is mysqld, not MySQL. Just type the command in my picture directly in CMD.

Installation succeeded:

After successful installation, someone directly entered mysql-uroot-p and then enter, still prompted not connected to the database, this is why? This is because after the installation of MySQL successfully, you also need to open the MySQL service to use.

3. Start the MySQL service.

① Control Panel-"management tool-" service-"mysql-" started.

At this point, you can use the MySQL service. After installation, the startup process, if the 1066 error, is due to the My.ini configuration problem, focus on the My.ini inside the path has been modified to their own path.

When you enter the command mysql-uroot-p connect to the database, you will be prompted to enter a password, root password default is empty, directly press ENTER on the line.

MySQL Compression package version of the installation method of the detailed