Notes: MySQL Download and install

1. Download:

The official website download is required to register, or you already have an Oracle account.

Can directly Baidu MySQL into the official website, or directly below the link;

Attached link:dev.mysql.com/downloads/mysql/

The specific download step will not say, here I download is mysql-5.7.16-winx64 version.

2. Unzip

Originally wanted to upload the zip to the blog, the result upload can not exceed 10M, OK.

After decompression:

You need to copy My-default.ini in the directory and change the name to the My.ini file ():

The configuration My.ini 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=d:\mysql\mysql-5.7.16-winx64
# Set up a storage directory for MySQL database data
Datadir=d:\mysql\mysql-5.7.16-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 here: The installation path needs to be switched to your own decompression file path

3. Install the service and start the service

1. Install: Run cmd in the admin province, enter the MySQL bin file directory, run the Mysqld-install installation service, the first time the installation succeeds in the same.

2. Start: cmd input net start MySQL

But........ WTF, what's the situation, look down

So what's the problem?

In fact, this is the origin of the Data folder;

At this time the cmd input:mysqld--initialize-insecure--user=mysql;

Generate Data folder

Then enter net start MySQL ...

OK start success!

Note: If you do not want to manually start the MySQL service every time, you can directly cmd knock services.msc into the service, set up the MySQL service startup mode, here is no longer described.

4. Set the password

Of course it is necessary to start the MySQL service, after the boot, it is still cmd to the MySQL installation path below

Enter Mysql-uroot-p, at which time the password for MySQL is empty, so.

Go on ...

Set Password: set password for [email protected] = password (' 000000 ')

Down ...

Exit: Exit can be reversed to the previous path. Enter mysql-uroot-p in the page and enter the password you just set, ok!

5. Configure Environment variables

Intermediate process is not in the narrative, direct, environment variable configuration, you do not have to go into the directory operation so troublesome, CMD directly into the can.

Of course there are other ways to install MySQL, the above is only personal learning income, if fortunate to be seen, and learn, trouble left your valuable advice.

Hope to learn together!!!

Notes: MySQL Download and install