Shulou(Shulou.com)06/01 Report--

Official website address: https://dev.mysql.com/downloads/mysql/

This is the RHEL6.5 system, so choose the RedHat 6x86 mysql-8.0.11 64bit operating system-download the first RPM Bundle-- mysql-8.0.11-1.el6.x86_64.rpm-bundle.tar.

Currently, MySQL8.0.11 Community Edition provides a variety of installation methods, but no installation instructions have been found for the mysql_secure_installation included in the Linux Generic installation package.

So the recommended RPM installation is used here:

1. After decompression, mysql-8.0.11-1.el6.x86_64.rpm-bundle.tar has the following seven files:

-rw-r--r-- 1 root root 28987588 Apr 9 01:06 mysql-community-client-8.0.11-1.el6.x86 Apr 64.rpmMuhasha rwkashi-1 root root 672184 Apr 9 01:06 mysql-community-common-8.0.11-1.el6.x86q64.rpmKuhashi Rwkashi-1 root root 4443296 Apr 9 01:06 RPM-1.el6.x86 Apr 64.rpm RPMI RWW- Mysql-community-libs-8.0.11-1 root root 2579460 Apr 9 01:06 mysql-community-libs-8.0.11-1.el6.x86 Apr 64.rwkhokyu rwqoq-1 root root 1902676 RPMI 9 01:06 mysql-community-libs-compat-8.0.11-1.el6.x86q64.rpm Mustang RWMuk-1 root root 395918848 Apr 9 01:07 mysql-community-server-8.0.11-1.el6.x86_64.rpm-rw-r -- r root root-1 root root 49092596 Apr 9 01:07 mysql-community-test-8.0.11-1.el6.x86_64.rpm

Then create a mysql user:

Useradd mysqlpasswd mysql

2. The installation order is: (it is recommended to uninstall all previous mysql-related packages before installation, rpm-e-- nodeps)

[root@python] # rpm-ivh mysql-community-common-8.0.11-1.el6.x86_64.rpmwarning: mysql-community-common-8.0.11-1.el6.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEYPreparing... # [100%] 1:mysql-community-common # [100%] [root@python] # rpm-ivh mysql-community-libs- 8.0.11-1.el6.x86_64.rpmwarning: mysql-community-libs-8.0.11-1.el6.x86_64.rpm: Header V3 DSA/SHA1 Signature Key ID 5072e1f5: NOKEYPreparing... # [100%] 1:mysql-community-libs # [100%] [root@python] # rpm-ivh mysql-community-libs -compat-8.0.11-1.el6.x86_64.rpmwarning: mysql-community-libs-compat-8.0.11-1.el6.x86_64.rpm: Header V3 DSA/SHA1 Signature Key ID 5072e1f5: NOKEYPreparing... # [100%] file / usr/lib64/mysql/libmysqlclient.so.16.0.0 from install of mysql-community-libs-compat-8.0.11-1.el6.x86_64 conflicts with file from package mysql-libs-5.1.73-8.0.1.el6_8.x86_64 file / Usr/lib64/mysql/libmysqlclient_r.so.16.0.0 from install of mysql-community-libs-compat-8.0.11-1.el6.x86_64 conflicts with file from package mysql-libs-5.1.73-8.0.1.el6_8.x86_64 [root@python ~] # rpm-e-nodeps mysql-libs-5.1.73-8.0.1.el6_8.x86_64 [root@python ~] # rpm-ivh mysql-community-libs -compat-8.0.11-1.el6.x86_64.rpmwarning: mysql-community-libs-compat-8.0.11-1.el6.x86_64.rpm: Header V3 DSA/SHA1 Signature Key ID 5072e1f5: NOKEYPreparing... # [100%] 1:mysql-community-libs-co### [100%] [root@python ~] # rpm-ivh mysql-community- Server-8.0.11-1.el6.x86_64.rpmwarning: mysql-community-server-8.0.11-1.el6.x86_64.rpm: Header V3 DSA/SHA1 Signature Key ID 5072e1f5: NOKEYerror: Failed dependencies: mysql-community-client (x86-64) > = 8.0.0 is needed by mysql-community-server-8.0.11-1.el6.x86_64 [root@python] # rpm-ivh mysql-community-client-8.0.11-1.el6.x86_64.rpmwarning: mysql-community-client-8.0.11-1.el6.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEYPreparing... # [100%] 1:mysql-community-client # [100%] [root@python] # rpm-ivh mysql-community-server- 8.0.11-1.el6.x86_64.rpmwarning: mysql-community-server-8.0.11-1.el6.x86_64.rpm: Header V3 DSA/SHA1 Signature Key ID 5072e1f5: NOKEYPreparing... # [100%] 1:mysql-community-server # [100%] [root@python] # rpm-ivh mysql-community-devel- 8.0.11-1.el6.x86_64.rpmwarning: mysql-community-devel-8.0.11-1.el6.x86_64.rpm: Header V3 DSA/SHA1 Signature Key ID 5072e1f5: NOKEYPreparing... # [100%] 1:mysql-community-devel # [100%] ^ [A [root @ python] # rpm-ivh mysql- Community-test-8.0.11-1.el6.x86_64.rpmwarning: mysql-community-test-8.0.11-1.el6.x86_64.rpm: Header V3 DSA/SHA1 Signature Key ID 5072e1f5: NOKEYerror: Failed dependencies: perl (JSON) is needed by mysql-community-test-8.0.11-1.el6.x86mm 64muri-lazy to install perl So the test suite is not installed.

3. The relevant information after installation is as follows:

[root@python ~] # mysql-Vmysql Ver 8.0.11 for Linux on x861664 (MySQL Community Server-GPL) [root@python ~] # ll / etc/init.d/mysqld-rwxr-xr-x 1 root root 7166 Apr 8 16:21 / etc/init.d/mysqld [root@python ~] # ll / etc/my.cnf-- profile location-rw-r--r-- 1 root root 1188 Apr 8 16:21 / etc/my.cnf

The default datadir is / var/lib/mysql/, which can be modified by modifying my.cnf. The startup command is as follows:

[root@python ~] # service mysqld startInitializing MySQL database: [OK] Starting mysqld: [OK]

4. You can't log in without a password, so add skip-grant-tables to my.cnf and restart it to reset your password.

Mysql > alter user root@'localhost' identified by 'mysql';ERROR 1290 (HY000): The MySQL server is running with the-- skip-grant-tables option so it cannot execute this statementmysql > exitBye

I can't believe you can't change it. So:

Mysql > delete from mysql.user where user='root';Query OK, 1 row affected (0.10 sec) mysql > flush privileges;Query OK, 0 rows affected (0.00 sec) mysql > create user root@'localhost' identified by 'mysql';ERROR 1819 (HY000): Your password does not satisfy the current policy requirements

Still can not be changed, check the password complexity requirements:

Mysql > show variables like'% pass%' +-+ | Variable_name | Value | +-- -+-+ | caching_sha2_password_auto_generate_rsa_keys | ON | | caching_sha2_password_private_key_path | private_key.pem | | caching_sha2_password_public_key_path | public_key.pem | | default_password_lifetime | 0 | disconnect_on_expired_password | ON | | mysql_native_password_ Proxy_users | OFF | | password_history | 0 | password_reuse_interval | 0 | report_password | | sha256_password_auto_generate_rsa_keys | ON | | sha256_password_private_key_path | private_key.pem | | sha256_password_proxy_users | OFF | | sha256_password_public_key _ path | public_key.pem | | validate_password.check_user_name | ON | | validate_password.dictionary_file | | validate_password.length | 8 | validate_password.mixed_case_count | 1 | validate_password.number_count | 1 | validate_password.policy | MEDIUM | | validate_password.special_char_count | 1 | +-+ +

Check the official website https://dev.mysql.com/doc/refman/8.0/en/validate-password-options-variables.html#sysvar_validate_password.policy

Three values are found, as shown below:

So set it to 0, and then set validate_password.length to 4, which means a minimum of 4 characters are required. It is set to 4 because the value of this parameter cannot be less than the result of the following formula:

Validate_password.number_count+ validate_password.special_char_count+ (2 * validate_password.mixed_case_count)

So continue to create users. MySQL8.0 cancels the syntax of creating users directly by grant, and can only create user and then grant. Therefore, the root is created as follows:

Mysql > create user root@'localhost' identified by 'mysql';ERROR 1396 (HY000): Operation CREATE USER failed for' root'@'localhost'mysql > FLUSH PRIVILEGES;Query OK, 0 rows affected (0.00 sec) mysql > create user root@'localhost' identified by 'mysql';ERROR 1396 (HY000): Operation CREATE USER failed for' root'@'localhost'

Nima. What the hell?

So I went to stackoverflow and said it was a BUG, so I did the following:

Mysql > drop user root@'localhost';-Yes, there are no root@'localhost' users, but you still have to delete it. Query OK, 0 rows affected (0.05sec) mysql > FLUSH PRIVILEGES;Query OK, 0 rows affected (0.01sec) mysql > create user root@'localhost' identified by 'mysql';Query OK, 0 rows affected (0.03sec) mysql > grant all on *. * to root@'localhost' with grant option;Query OK, 0 rows affected (0.03sec)

I finally finished changing the password. Remove the skip-grant-tables parameter of the parameter file, and service mysqld restart restart the service.

5. Finally set the password, create a test user leo, and then try to connect remotely:

$mysql-uleo-pmysql-h292.168.1.193mysql: [Warning] Using a password on the command line interface can be insecure.ERROR 2059 (HY000): Authentication plugin 'caching_sha2_password' cannot be loaded: / usr/lib/mysql/plugin/caching_sha2_password.so: cannot open shared object file: No such file or directory

I can't connect to my 5.7s mysql tool, which is awkward. Check the parameters related to authentication:

Mysql > show variables like'% auth%' +-+ | Variable_name | Value | +-- +- -+ | default_authentication_plugin | caching_sha2_password | +-+ 1 row in set (0.02 sec)

Check the official website and find that the value is as follows:

The official website also said that this value affects the default encryption algorithm for passwords when create user does not explicitly specify auth plugin, shit. Doesn't that mean that the leo user I created earlier uses the default caching_sha2_password authentication? check it out:

Mysql > select user,host,plugin from mysql.user +-+ | user | host | plugin | +- -+ | leo |% | caching_sha2_password | | mysql.infoschema | localhost | mysql_native_password | | mysql.session | localhost | mysql_native_password | | mysql.sys | localhost | mysql_native_password | | root | localhost | caching_sha2_password | +-- +

It's over, it's all TM.

Obviously, you can't update plugin directly, because this may cause the encrypted password to not be decrypted correctly and all your passwords will mutate, so delete and rebuild all your passwords except root@'localhost'.

First, add: default_authentication_plugin=mysql_native_password to the my.cnf, and then restart the service by service mysqld restart:

Mysql > drop user leo;Query OK, 0 rows affected (0.10 sec) mysql > flush privileges;Query OK, 0 rows affected (0.00 sec) mysql > create user leo identified by 'mysql';Query OK, 0 rows affected (0.02 sec) mysql > grant all on *. * to leo Query OK, 0 rows affected (0.08 sec) $mysql-Vmysql Ver 14.14 Distrib 5.7.20, for Linux (x86 / 64) using EditLine wrapper$ mysql-uleo-pmysql-h292.168.1.193mysql: [Warning] Using a password on the command line interface can be insecure.Welcome to the MySQL monitor. Commands end with; or\ g.Your MySQL connection id is 16Server version: 8.0.11 MySQL Community Server-GPLCopyright (c) 2000, 2017, Oracle and/or its affiliates. All rights reserved.Oracle is a registered trademark of Oracle Corporation and/or itsaffiliates. Other names may be trademarks of their respectiveowners.Type 'help;' or'\ h' for help. Type'\ c'to clear the current input statement.mysql >

The remote connection is normal at this point.

Summary

The above is the MySql 8.0.11 installation and configuration tutorial introduced by the editor. I hope it will be helpful to you. If you have any questions, please leave me a message and the editor will reply you in time. Thank you very much for your support to the website!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.