MySQL Server installation configuration-non-installation version, Windows edition

The documentation is illustrated in the 5.6.30 version

1. Download MySQL

Http://dev.mysql.com/downloads/mysql/5.6.html#downloads

We can choose the version, environment, platform we need:

2. Installation

1) After the download is complete, we begin to unzip the downloaded compressed package (please unzip in C drive)

2) Set configuration file My.ini

Open the Unpacked folder, we see: (My.ini is I added in the)

We create a new My.ini file, the content is as follows

[MySQL]
# Set the MySQL client default character set
Default-character-set=utf8
[Mysqld]
#设置3306端口
port=3306
# set up the MySQL installation directory
Basedir=c:\program files\mysql-5.6.30-winx64
# Set up a storage directory for MySQL database data
Datadir=c:\program Files\mysql-5.6.30-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

Note that you set your own path, Basedir, DataDir. The file encoding is ANSI.

3) command to configure MySQL

Open System Environment variables

Locate the path in the system variable, double-click

Add environment variable, path to the bin directory under Unzip folder

4) command line installation (open the command line please switch to the bin path under MySQL, otherwise there will be inexplicable errors.) Regardless of whether you set the environment variable)

Open the command line as an administrator, and then enter mysqld install mysqld (mysqld Remove is the delete command)

Here is a hint that successfully installation was successful.

Then enter the command net start MySQL to start the service

Here the prompt starts successfully.

Note: I have encountered a ' system error 2 ' and ' 1067 ' ERROR while starting this command. The workaround is MySQL decompression on the C-drive, cmd command without administrator rights, My.ini file to write the wrong path.

5) running MySQL

In the command line just entered mysql–uroot–p, the default is no password. So we can use the command line to manipulate the database.

MySQL Server installation configuration-non-installation version, Windows edition