Mysql Compression Package Version installation configuration method graphics and text tutorial _mysql

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

First, download the MySQL compressed package file

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

① choose the appropriate version of MySQL: Figure

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

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

Second, compression package decompression installation

Can be installed in any one of the system disk, I am accustomed to install under D disk, so under D disk a new MySQL folder to store MySQL file files (do not and I said do not know how to extract files). Directory structure: D:\mysql\mysql-5.6.33-winx64. By this step, many beginners will run the directory directly D:\mysql\mysql-5.6.33-winx64\ Bin under the Mysql.exe file, and then pop a box, flashing a bit is gone, because the MySQL service has not yet been installed, so far just to download the package and then extract to the corresponding directory.

The following describes how to install the MySQL service:

1, configure My.ini files.

In D:\mysql\mysql-5.6.33-winx64\ (note this directory to be with your own directory, I download here is 5.6 version, if you download is 5.5 version, this directory is different from the directory to create a new configuration file named My.ini, and then copy the following configuration code to the My.ini (the path in the code to change to its own file storage path). As shown in figure:

Code:

[MySQL]
# set MySQL client default character set
Default-character-set=utf8 
[mysqld]
#设置3306端口
port = 3306 
# set MySQL installation directory
basedir=d:\mysql\mysql-5.6.33-winx64
# Set up a directory of MySQL database data
datadir=d:\mysql\mysql-5.6.33-winx64\ Data
# allows maximum number of connections
max_connections=200
# The character set used by the service side defaults to a 8-bit encoded latin1 character Set
Character-set-server=utf8
# The default storage engine to use when creating a new table
Default-storage-engine=innodb

2, install the MySQL service:

As an administrator to run C:\Windows\System32 directory to find this Cmd.exe, note that you must run as an administrator, or you can not install successfully. As an administrator to open the cmd window, the directory switch to the file you extract the bin directory, and then enter mysqld install carriage return run on the line, the attention is mysqld, not MySQL. Just enter the command in my picture directly in CMD. As shown in figure:

The installation was successful as shown in the following illustration:

After the installation was successful, someone directly entered mysql-uroot-p and then enter, still prompted not to connect to the database, this is why? This is because MySQL is installed after the successful installation, but also to open the MySQL service to use.

3. Start MySQL Service

① Control Panel-"Management tools-" service-"mysql-" started.

At this point, you can use the MySQL service. After installation, the startup process, if 1066 error, is because of the My.ini configuration problem, focus on the My.ini inside the path has not been modified into its own path.

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

Wonderful topic sharing: MySQL different versions of the installation Tutorials mysql5.7 version Installation Tutorials

The above is the entire content of this article, I hope to help you learn, but also hope that we support the cloud habitat community.