Windows 10 + mysql 8.0.11 zip installation tutorial detailed

Prepare:

MySQL 8.0 Windows zip package download address: https://cdn.mysql.com//Downloads/MySQL-8.0/mysql-8.0.11-winx64.zip

Environment: Windows 10

1. Installation

1. Unzip the zip package to the installation directory

My installation directory is D:\Program Files\mysql-8.0.11-winx64

2. Configuration File

The default configuration file in Windows system is the my.ini file in the installation directory. Some configurations need to be configured during the initial installation, and most of them can be changed after the installation is complete. I don’t know what other people’s situation is. My my.ini file does not exist in the file directory, so I created a new file as follows

Write the basic configuration as follows:

[mysqld]
default_authentication_plugin=mysql_native_password
# 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=D:\Program Files\mysql-8.0.11-winx64
datadir=D:\Program Files\mysql-8.0.11-winx64\data (these two lines are the main modifications, the data folder will be automatically generated, and the others can be directly pasted)
port = 3306
# 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 
character-set-server = utf8mb4
performance_schema_max_table_instances = 600
table_definition_cache = 400
table_open_cache = 256
[mysql]
default-character-set = utf8mb4
[client]
default-character-set = utf8mb4

Note that basedir is my local installation directory, and datadir is where my database data files are stored. Each configuration needs to be configured according to your own environment.

3. Initialize the database

Execute the command in the bin directory of the MySQL installation directory:

mysqld --initialize --console

After the execution is complete, the initial default password of the root user will be printed, for example:

2018-05-01T14:35:01.507037Z 0 [Warning] [MY-010915] [Server] 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release.
2018-05-01T14:35:01.507640Z 0 [System] [MY-013169] [Server] D:\Program\MySQL8\bin\mysqld.exe (mysqld 8.0.11) initializing of server in progress as process 11064
2018-05-01T14:35:01.508173Z 0 [ERROR] [MY-010340] [Server] Error message file 'D:\Program Files\mysql-8.0.11-winx64\share\english\errmsg.sys' had only 1090 error messages, but it should contain at least 4512 error messages. Check that the above file is the right version for this program!
2018-05-01T14:35:05.464644Z 5 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: APWCY5ws&hjQ
2018-05-01T14:35:07.017280Z 0 [System] [MY-013170] [Server] D:\Program\MySQL8\bin\mysqld.exe (mysqld 8.0.11) initializing of server has completed

Among them, "APWCY5ws&hjQ" in the fourth line is the initial password. Before changing the password, you need to remember this password as it will be needed for subsequent logins.

If you accidentally close the directory too quickly or forget to remember, it's OK. Just delete the initialized datadir directory and execute the initialization command again, and it will be regenerated. Of course, you can also use security tools to force a password change, using any method you like.

4. Installation service

Execute the command in the bin directory of the MySQL installation directory:

mysqld --install [service name]

The service name behind it can be omitted, the default name is mysql. Of course, if you need to install multiple MySQL services on your computer, you can distinguish them with different names, such as mysql5 and mysql8.

After the installation is complete, you can start the MySQL service through the command net start mysql.

2. Change password and password authentication plug-in

Execute the command in the bin directory of the MySQL installation directory:

mysql -uroot -p

At this time, you will be prompted to enter a password. Remember the password in step 3. Fill it in to log in successfully and enter the MySQL command mode.

Before MySQL 8.0.4, execute

SET PASSWORD=PASSWORD('[modified password]');

You can change the password, but starting with MySQL 8.0.4, this is not possible by default. Because before, the password authentication plugin for MySQL was "mysql_native_password", and now it uses "caching_sha2_password".

Because many database tools and link packages currently do not support "caching_sha2_password", for convenience, I temporarily changed back to the "mysql_native_password" authentication plug-in.

Execute the command in MySQL:

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password'; (Note that there must be a semicolon) (Note that there must be a semicolon)

Modify the password verification plug-in and modify the password at the same time.

If you want to use the "mysql_native_password" plug-in authentication by default, you can configure the default_authentication_plugin item in the configuration file.

[mysqld]
default_authentication_plugin=mysql_native_password

Let's take a look at installing mysql8.0.11 under win10

1. Unzip the downloaded software to D:\mysql.

2. Create my.ini under D:\mysql and add settings such as basedir, datadir, port, etc.

3. Add D:\mysql\bin to the system environment variables

4. Run cmd as an administrator to initialize the database: mysql --initialize --console. Remember the initial root password.

5. Install the database service: mysqld --install service name (default is mysql)

6. Start the database: net start service name

7. Log in: mysql -u root -p, enter the initialization password

8. Modify the root password: alter user 'root'@'localhost' identified by 'xxxxx';

For more information, please refer to: https://dev.mysql.com/doc/refman/8.0/en