MySQL 8.0.11 installation summary tutorial diagram

Installation environment:

CAT /etc/os-release View the centos system version information;

getconf LONG_BIT Get the system bit number

The system is 64-bit centos 7

Configure the installation source:

rpm -Uvh https://repo.mysql.com/mysql57-community-release-el7-11.noarch.rpm 
yum --enablerepo=mysql80-community install mysql-community-server

Start mysql service

systemctl start mysqld.service

or

service mysqld start

mysql service status:

systemctl status mysqld

or

service mysqld status will actually be converted to systemctl status mysqld to obtain the status

View mysql root temporary password

grep "A temporary password" /var/log/mysqld.log

Reset new password and password policy based on temporary password

mysql_secure_installation;

Password Policy:

Follow the prompts step by step;

Set up remote connection

firewall-cmd --add-port=3306/tcp --permanent Open database access port tcp protocol

firewall-cmd --reload Reload firewall information

firewall-cmd --list-ports View open port information

lsof -i:3306 verification

mysql client login verification

View version:

Some client connections will have error 2059

Main solutions:

Change default_authentication_plugin = mysql_native_password

vim /etc/my.cnf

Restart the service and you can connect; it is possible that the restart failed; (If it does not work, it should be 1045. The operating system may connect to 127.0.0.1 by default, not localhost, which causes the connection failure. Change the user Host

use mysql; update user set Host='%' where User='root'; This occurs when the windows client connects. This should be unrelated to error 2059: Authentication plugin 'caching_sha2_password' can not be loaded '----');

During the installation, you can clearly feel that the security attributes of MySQL 8.0's new features have been greatly improved;

Summarize

The above is the MySQL8.0.11 installation summary tutorial illustrated by the editor. I hope it will be helpful to everyone. If you have any questions, please leave me a message and the editor will reply to you in time. I would also like to thank everyone for their support of the 123WORDPRESS.COM website!