Detailed explanation on the use and installation of Mysql 5.7.19 winx64 ZIP Archive

This article introduces you to a summary of the installation and use process of mysql 5.7.19 winx64 ZIP Archive. Friends who need it can refer to it

I learned to install MySQL today, and some problems occurred during the process. Check it out I solved it after reading several related articles and recorded it for your reference.

1. Download

Choose the version that suits you. Archive says you can unzip it directly after downloading. Installation is not allowed, which is more convenient.

2. Create a new file my.ini in the root directory of MySQL (it did not exist before) and add the following content to the file.

[mysql]
# 设置mysql客户端默认字符集
default-character-set=utf8 
[mysqld]
#设置3306端口
port=3306 
# 设置mysql的安装目录
basedir=E:\Databases\mysql\mysql-5.7.19-winx64
# 设置mysql数据库的数据的存放目录
datadir=E:\Databases\mysql\mysql-5.7.19-winx64\data
# 允许最大连接数
max_connections=200
# 服务端使用的字符集默认为8比特编码的latin1字符集
character-set-server=utf8
# 创建新表时将使用的默认存储引擎
default-storage-engine=INNODB
# 免密码登陆
skip-grant-tables

I added the last line later because I didn’t know a password when logging in, so I added it in the my.ini file The last sentence is that you can log in without a password.

3. Find Path in the environment variable and add the path to the mysql bin.

For example, mine is: “;E:\Databases\mysql\mysql-5.7.19-winx64\bin”

4. Run cmd as an administrator. Be sure to run it as an administrator. You can check how to run your system as an administrator.

5. Run the following command

mysqld --initialize
 mysqld install
 net start mysql
 mysql -u -root

Summarize

The above is the detailed content of Detailed explanation on the use and installation of Mysql 5.7.19 winx64 ZIP Archive. For more information, please follow other related articles on the PHP Chinese website!