Mysql 5.7.13 winx64 installation and configuration method graphic tutorial, 5.7.13winx64

Mysql 5.7.13 winx64 installation and configuration method graphic tutorial, 5.7.13winx64

I have summarized the notes for installing mysql and shared them with you.

1. Download

: Http://dev.mysql.com/downloads/mysql/

Select windows (x86, 64-bit) and ZIP Archive based on the computer configuration. Click Download To go to the page, as shown in figure

Click "No thanks" at the bottom to start my download.

My mysql installation path is D: \ Mysql \ mysql-5.7.13-winx64

2. Configure the my. ini file and add the data folder.

Create a new my. ini file under the mysql installation path

Write the following code in the my. ini file:

[Mysql] # set the default character set of the mysql client default-character-set = utf8 [mysqld] # set port 3306 to port 3306 # set the mysql installation directory basedir = D: \ Mysql \ mysql-5.7.13-winx64 # Set the mysql database data storage directory datadir = D: \ Mysql \ mysql-5.7.13-winx64 \ data # maximum number of connections allowed max_connections = 200 # the character set used by the server defaults to the 8-bit latin1 character set character-set-server = utf8 # default storage engine default-storage-engine = INNODB

Create a folder named data

Open cmd

If the installation is successful, it will be OK (I have already installed it, so the service already exist will appear)

3. Start the mysql server

Start Task Manager-click Service

Enter Service

Right-click mysql and choose start or restart.

4. Open mysql

Enter mysql-u root-p and password in cmd.

If you want to reset the password mysqladmin-u root-p password

After entering mysql, enter show databases;

Enter use myweb;

Enter show tables;

The above is the installation and configuration method of mysql 5.7.13winx64. I hope it will be helpful for your learning.