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

Installation environment:

CAT / etc/os-release View centos system version Information

Getconf LONG_BIT acquires the number of bits of shame system

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 the mysql service

Systemctl start mysqld.service

Or

Service mysqld start

Mysql Service status:

Systemctl status mysqld

Or

Service mysqld status actually converts to systemctl status mysqld to get the state.

View mysql root temporary password

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

Reset new passwords and password policies based on temporary passwords

Mysql_secure_installation

Password Policy:

Follow the prompted steps to complete it step by step

Set to connect remotely

Firewall-cmd-add-port=3306/tcp-permanent Open Database access Port tcp Protocol

Firewall-cmd-- reload reloads firewall information

Firewall-cmd-- list-ports to view open port information

Lsof-iPUR 3306 verification

Mysql client login authentication

View the version:

Error 2059 errors may occur in some client connections

Main solutions:

Change default_authentication_plugin = mysql_native_password

Vim / etc/my.cnf

Restart the service and connect; it may not be restarted successfully. (if not, it should be 1045. Maybe the default connection of the operating system is 127.0.0.1. It is not caused by localhost. Change the user Host.

Use mysql; update user set Host='%' where User='root';windows client connection occurs, which should have nothing to do with error 2059: Authentication plugin 'caching_sha2_password' can not be loaded'--')

During installation, you can clearly feel that the security properties of the new features of MySQL8.0 have been greatly improved.

Summary

The above is the illustration of the MySQL8.0.11 installation summary tutorial introduced by the editor. I hope it will be helpful to you. If you have any questions, please leave a message for me, and the editor will reply to 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.