MySql 8.0. 11 Winxp64 of Installation Free Configuration Tutorial

1. Unzip the zip package to the installation directory

First, unzip mysql-8. 0.11-winx64.zip to install D:/mysql-8. 0.11-winx64,

2. Configuration files

Add my. ini under the installation root

Basic Profile (my)

[mysqld]
basedir = D:\mysql-8.0.11-winx64
datadir = D:\mysql-8.0.11-winx64\data
port = 3306
lower_case_table_names = 2
default_authentication_plugin=mysql_native_password

Refer to basic configuration:

[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 = D:\Program\MySQL
datadir = D:\DBs\MySQL
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

3. Initialize the database

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

mysqld --initialize --console

When the execution is complete, the initial default password of the root user is printed, such as:

2018-04-20T02: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-04-20T02: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-04-20T02:35:01.508173Z 0 [ERROR] [MY-010340] [Server] Error message file 'D:\Program\MySQL\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-04-20T02:35:05.464644Z 5 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: APWCY5ws&hjQ
2018-04-20T02:35:07.017280Z 0 [System] [MY-013170] [Server] D:\Program\MySQL8\bin\mysqld.exe (mysqld 8.0.11) initializing of server has completed

Where, in line 4, "APWCY5ws & hjQ "is the initial password. Before changing the password, you need to remember this password, which is needed for subsequent login.

If you don't remember, it's okay. Delete the initialized datadir directory, execute the initialization command again, and it will be regenerated. Of course, you can also use security tools to force the password to be changed, and you can use any method at will.

4. Install services

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

mysqld --install [服务名]

Step 4 Start the service

net start MySQL

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 the password. Remember the password in Step 3, fill it in and log in successfully, and enter MySQL command mode.

Previously, the password authentication plug-in of MySQL was "mysql_native_password", but now it is "caching_sha2_password".

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

Execute commands in MySQL:

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password';

Modify the password verification plug-in and change 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 entry in the configuration file.

[mysqld]
default_authentication_plugin=mysql_native_password

Summarize