mysql5.7.13 environment setup tutorial (unzipped version)_MySQL

2. Configure mysql

1. Configure my.ini
I renamed the mysql-5.7.13-winx64 file here to mysql (the original file name is too long). The my-default.ini under this file is the default configuration file. We need to re-implement the configuration here: change my- Copy default.ini and rename it to my.ini, and replace the file directories of basedir, datadir and other parameters with the path to the directory where your own mysql is located.

 # For advice on how to change settings please see
 # http://dev.mysql.com/doc/refman/5.7/en/server-configuration-defaults.html
 # *** DO NOT EDIT THIS FILE. It's a template which will be copied to the
 # *** default location during install, and will be replaced if you
 # *** upgrade to a newer version of MySQL.
 [mysqld]

# Remove leading # and set to the amount of RAM for the most important data
# cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.
# innodb_buffer_pool_size = 128M

# Remove leading # to turn on a very important data integrity option: logging
# changes to the binary log between backups.
# log_bin

# These are commonly set, remove the # and set as required.
basedir = C:\mysql
datadir = C:\mysql\data
# port = .....
# server_id = .....


# Remove leading # to set options mainly useful for reporting servers.
# The server defaults are faster for transactions and fast SELECTs.
# Adjust sizes as needed, experiment to find the optimal values.
# join_buffer_size = 128M
# sort_buffer_size = 2M
# read_rnd_buffer_size = 2M

sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES 

2. Configure environment variables
Add the path of your mysql bin folder to PATH, it’s very simple, not much to say.

3. Run mysql
Run cmd as administrator (must run as administrator) and enter the mysql bin file
mysqld --remove mysqld --install
mysqld --initialize //A data folder will be generated
net start mysql //Start the mysql service

After executing these three commands in sequence, open the data folder and find the error file type file under it. This file is the log log of this mysql initialization, including the initialization password. If "root@localhost is created with an empty password !" is displayed, it is empty. Then execute
mysql -uroot -p
Enter the user name and password, and if "Type 'help;' or 'h' for help. Type 'c' to clear the current input statement." is displayed, the connection is successful.

4. Login error
If there is a problem when logging in and "Access denied for user 'root'@'localhost'" is displayed, you can try to reset the root password: 1. Modify the /my.ini file, add skip-grant-tables under [mysqld], and then start mysql

mysql -u root

 mysql> update mysql.user set password=PASSWORD（'新密码'） where User='root'
mysql> flush privileges；
mysql> quit