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

This article mainly gives you a brief introduction to the implementation of binary installation MySQL8.0.11 under the linux7.2 system. You can check the relevant professional terms on the Internet or find some related books to supplement them. We will not dabble here, so let's go straight to the topic. I hope this article on the implementation of binary installation MySQL8.0.11 under the linux7.2 system can bring you some practical help.

1. Download the binary package:

Mysql-8.0.11-linux-glibc2.12-x86_64.tar.gz

2. Add MySQL users and groups:

[root@localhost ~] # userdel mysql (the existing MySQL users are deleted because it is a new system) [root@localhost ~] # groupadd mysql [root@localhost ~] # useradd-g mysql mysql [root@localhost ~] # passwd mysql (the MySQL password should be more complex, or the login system is not allowed when the user is created)

3. Create the installation MySQL target and extract the software to the specified directory

[root@localhost ~] # mkdir-p / mysql/data [root@localhost ~] # chown-R mysql.mysql / mysql [root@localhost ~] # tar zxvf mysql-8.0.11-linux-glibc2.12-x86_64.tar.gz-C / mysql [root@localhost ~] # cd / mysql [root@localhost ~] # mv mysql-8.0.11-linux-glibc2.12-x86_64 / mysql [root@localhost ~] # chown-R mysql.mysql / mysql

4. Initialize the database

[root@localhost ~] # su-mysql

[mysql@localhost ~] $vim / mysql/my.cnf

[client] socket=/mysql/data/ mysql.sock [mysqld] server-id=142port = 3306basedir=/mysql/mysqldatadir=/mysql/datasocket=/mysql/data/mysql.socklog-error=/mysql/data/mysqld.logpid-file=/mysql/data/mysqld.pidlog-bin=/mysql/data/binlogslow_query_log_file = / mysql/data/slow.loglog_slave_updatesexpire_logs_days=7binlog_format=ROW#default_authentication_plugin=mysql_native_password-modify the password encryption method. (see the final explanation in the article) gtid-mode = on enforce-gtid-consistency = 1 skip_slave_start=1 innodb_buffer_pool_size = 1000m innodb_buffer_pool_instances = 2 innodb_log_file_size = 100m innodb_log_files_in_group = 3 Innodb_log_buffer_size = 24m innodb_flush_log_at_trx_commit = 1 innodb_file_per_table = 1 innodb_flush_method = O_DIRECT innodb_io_capacity = 200innodb_io_ Capacity_max = 600innodb_thread_concurrency = 0 innodb_autoinc_lock_mode = 2 innodb_lock_wait_timeout = 60 innodb_read_io_threads = 4 innodb_write_io_threads = 4 Innodb_max_dirty_pages_pct = 80 innodb_autoextend_increment = 512 innodb_checksum_algorithm = NONE max_connect_errors = 1000 max_connections = 500 connect_timeout = 300 wait_timeout = 86400 interactive_timeout = 86400 [mysql@localhost mysql] $/ mysql/mysql/bin/mysqld-defaults-file=/mysql/my.cnf-user=mysql-basedir=/mysql/mysql/-datadir=/mysql/data/-initialize

The default password of root is in: / mysql/data/mysqld.log log. You can open it and view it.

5. Start MySQL

[root@localhost mysql] # / mysql/mysql/bin/mysqld_safe-- defaults-file=/mysql/my.cnf-- user=mysql & [root@localhost mysql] # / mysql/mysql/bin/mysql-uroot-p-S / mysql/data/mysql.sock mysql > set password='123456';mysql > flush privileges Mysql >\ s-/mysql/mysql/bin/mysql Ver 8.0.11 for linux-glibc2.12 on x866.64 (MySQL Community Server-GPL) Connection id: 11Current database:Current user: root@localhostSSL: Not in useCurrent pager: stdoutUsing outfile:''Using delimiter: Server version: 8.0.11 MySQL Community Server-GPLProtocol version: 10Connection: Localhost via UNIX socketServer characterset: utf8mb4Db characterset: utf8mb4Client characterset: utf8mb4Conn. Characterset: utf8mb4UNIX socket: / mysql/data/mysql.sockUptime: 10 min 31 secThreads: 2 Questions: 10 Slow queries: 0 Opens: 124 Flush tables: 2 Open tables: 100 Queries per second avg: 0.015-

(note: to start the database here, you must use the client that comes with the MySQL8.0 installation package to log in, that is, you must use the command of the MySQL8.0 installation package to log in to the database, otherwise an error will be reported, such as:

ERROR 2059 (HY000): Authentication plugin 'caching_sha2_password' cannot be loaded:)

Note:

Under mysql8.0, the default is default_authentication_plugin=caching_sha2_password, including the authenticated encryption method for the root users you just initialized. As a result, you will not be able to connect to the database unless you are driven by a new protocol, such as the mysql client that comes with 8.0.

In mysql5.7 environment, although you can set default_authentication_plugin to change authentication encryption, but most people will not set it. So the default authentication encryption method is mysql_native_password.

Solution:

①: add it to the configuration file during initialization, as shown below. The authentication method of mysql_native_password will be the same as that of many clients.

Vim my.cnf

[mysqld]

Default_authentication_plugin=mysql_native_password

②: use command line mode to change the password encryption authentication method of the user:

Mysql > select Host,User,plugin,authentication_string from mysql.user See below: the authentication method of root users is different from that of other users. + -+ | Host | User | plugin | authentication_string | + -+ | localhost | mysql.infoschema | mysql_native_password | * THISISNOTAVALIDPASSWORDTHATCANBEUSEDHERE | | localhost | mysql.session | mysql_native_password | * THISISNOTAVALIDPASSWORDTHATCANBEUSEDHERE | | localhost | mysql.sys | mysql_native_password | * THISISNOTAVALIDPASSWORDTHATCANBEUSEDHERE | | localhost | root | caching_sha2_password | $T?yK {e`l {mrnZd | 0iETvMwJ197qvnDXttfzdZX98q6xvFBwXuWd3ioPfnV7 | + -+ 4 rows in set (0.00 sec) mysql > ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY' 123456' -specify the password encryption authentication method Query OK when changing the password, 0 rows affected (0.11 sec) mysql > select Host,User,plugin,authentication_string from mysql.user -check again that all users are the same Same as version 5.7 +-+ | Host | User | Plugin | authentication_string | +- -+ | localhost | mysql.infoschema | mysql_native_password | * THISISNOTAVALIDPASSWORDTHATCANBEUSEDHERE | | localhost | mysql.session | mysql_native_password | * THISISNOTAVALIDPASSWORDTHATCANBEUSEDHERE | | localhost | mysql.sys | mysql_native_password | * THISISNOTAVALIDPASSWORDTHATCANBEUSEDHERE | | localhost | root | mysql_native_password | * 6BB4837EB74329105EE4568DDA7DC67ED2CA2AD9 | +- -+-+ 4 rows in set (0.00 sec)

In addition, authorization and creation of users are more stringent in MySQL8.0, and commands can be used in MySQL5.7 as follows:

MySQL [(none)] > grant all privileges on *. * to 'test_user'@'192.168.2.%' identified by' 123123 authorization;-MySQL5.7 method for creating user authorization, an error was reported

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'identified by' 123123 at line 1

In MySQL8.0, you must create a user before authorizing:

MySQL > create user' test_user'@'%' identified by '123456customers;-- create users first

Query OK, 0 rows affected (0.03 sec)

MySQL > grant all privileges on *. * to 'test_user'@'%' with grant option;-re-authorization

Query OK, 0 rows affected (0.05 sec)

Linux7.2 system to achieve binary installation MySQL8.0.11 method to tell you here, for other related issues you want to know can continue to pay attention to our industry information. Our section will capture some industry news and professional knowledge to share with you every day.

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.