Installation of Mysql 64-bit decompression version

Download the unzipped version of MySQL first

https://dev.mysql.com/downloads/file/?id=474496

Extract

Go inside and create a new folder and file.

Open the My.ini file (open with a text editor, not installed with the system's own Notepad)

Copy the following code in.

#代码开始
[Client]
#设置3306端口
Port = 3306

[Mysqld]
#设置3306端口
Port = 3306
# set up the MySQL installation directory
Basedir=e:\software\mysql\mysql-5.6.39-winx64
# Set up a storage directory for MySQL database data
Datadir=e:\software\mysql\mysql-5.6.39-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
Sql_mode=no_engine_substitution,strict_trans_tables

[MySQL]
# Set the MySQL client default character set
Default-character-set=utf8
#代码结束

bind-address=127.0.0.1

Save Exit!

Next Configure Environment variables

Create a new system variable mysql_home, and configure the variable value to E:\SoftWare\Mysql\mysql-5.6.39-winx64

Next, edit the system variable path, and add the%mysql_home%\bin to the path variable value.

Run command prompt cmd as Administrator

Switch to the bin directory of the extracted directory of MySQL

  mysqld - install net start mysql

The first time you log in, you can go straight in.

To set a password for the root user

Mysql>Use mysql;database changedmysql> Update UserSetAuthentication_string=password ('Root')whereUser='Root'; Query OK,3Rows Affected (0.00sec) Rows matched:3Changed:3Warnings:0MySQL>flush Privileges; Query OK,0Rows Affected (0.00sec) MySQL>

Installation of Mysql 64-bit decompression version