mysql 8.0 Windows zip Package Version Installation Details

The installation process of MySQL 8.0 Windows zip is described as follows

Prepare:

MySQL8.0 Windows zip package download address.

Environment: Windows 10

Step 1 Install

1. Unzip the zip package to the installation directory

For example, my installation directory is: D:\ Program\ MySQL

2. Configuration files

In Windows system, the configuration file is my. ini file under the installation directory by default. Some configurations need to be configured during initial installation, and most of them can be changed after installation. Of course, in extreme cases, everything can be changed.

Add my. ini to the installation root, as I have here: D:\ Program\ MySQL\ my. ini, and write to the 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

Note that basedir inside is my local installation directory, datadir is my database data files to store the location, the configuration needs to be configured according to their own environment.

For all configuration items, please refer to: MySQL 8.0 Reference Manual

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 your hands are cheap, close fast, or 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.

Reference: Link address

4. Install services

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

mysqld--install [service name]
The following service name can not be written, and the default name is mysql. Of course, if you need to install multiple MySQL services on your computer, you can distinguish them by different names, such as mysql5 and mysql8.

Once the installation is complete, you can start the service of MySQL with the command net start mysql.

Reference: Link address

2. Change passwords and password authentication plug-ins

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.

Prior to MySQL 8.0. 4, execute

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

You can change the password, but MySQL 8.0. 4 starts, so it doesn't work by default. Because before, the password authentication plug-in for MySQL was "mysql_native_password", 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

Reference: Link address

Step 3 Speed test

No need to test. Officials say MySQL8 is twice as fast as 5.

Attached, CentOS tar. gz package installation

wget https://cdn.mysql.com//Downloads/MySQL-8.0/mysql-8.0.11-linux-glibc2.12-x86_64.tar.gz
shell> tar zxvf mysql-8.0.11-linux-glibc2.12-x86_64.tar.gz -C /usr/local/
shell> groupadd mysql
shell> useradd -r -g mysql -s /bin/false mysql
shell> cd /usr/local
shell> ln -s mysql-8.0.11-linux-glibc2.12-x86_64 mysql
shell> cd mysql
shell> mkdir mysql-files
shell> chown mysql:mysql mysql-files
shell> chmod 750 mysql-files
shell> bin/mysqld --initialize --user=mysql
shell> bin/mysql_ssl_rsa_setup
shell> bin/mysqld_safe --user=mysql &
# Next command is optional
shell> cp support-files/mysql.server /etc/init.d/mysql.server

Reference: Link address

Wonderful topic sharing: mysql installation tutorials for different versions mysql5.7 installation tutorials for different versions mysql5.6 installation tutorials