MySQL Download installation

First, to the official website to download the corresponding version of the package

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

This machine is win7 64-bit download as

Click to download, jump to another page

, click to download the

Two

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

Failed to start

Http://jingyan.baidu.com/article/597035521d5de28fc00740e6.html

Cmd->mysql-uroot-p-Enter password->show databases; Find database->use database name; switch database directory->show tables; lookup table SQL query Work select * FROM table name->exit exit.

MySQL Download installation