Installation and configuration of Mysql5.7.11 on Windows 10 (unzipped version)_MySQL

First step

my-default.ini 添加配置：
#绑定IPv4和3306端
bind-address = 127.0.0.1
port = 3306
# 设置mysql的安装目
basedir= E:\mysql
# 设置mysql数据库的数据的存放目
datadir=E:\mysql\data
# 允许最大连接数
max_connections=200
#设置默认字符集为utf8
default-character-set=utf8

Step 2

Right-click My Computer->Properties->Advanced->Environment Variables and add the path to the mysql bin directory in the path.

Select the environment variable and enter the MySQL path under the Path path in the environment variable to the bin and it will be ok.

Such as D:mysql-5.7.11-winx64bin

Step 3

1) Run cmd with administrator privileges and enter the bin directory in the MySQL decompression directory.

cd /d D:\mysql-5.7.11-winx64\bin

2) mysqld –romve delete mysql service

3) mysqld –install install mysql service

4) mysqld –initialize must be initialized

5) net start mysql

PS: mysql5.7.11 service cannot be started, solution for error code 3534:

Solution (provided the data folder has been generated):

mysqld –romve 删除mysql服务 
mysqld –install 安装mysql服务 
mysqld –initialize 一定要初始化 
net start mysql

The above is the installation and configuration of Mysql5.7.11 on Windows 10 (decompressed version) introduced by the editor. I hope it will be helpful to you. If you have any questions, please leave me a message and the editor will reply to you in time. . Thank you very much for your support of the website!