Shulou(Shulou.com)05/31 Report--

This article shows you how to install MySQL8.0 in CentOS. The content is concise and easy to understand. It will definitely brighten your eyes. I hope you can get something through the detailed introduction of this article.

Download the installation package for the yum source

Yum localinstall https://repo.mysql.com//mysql80-community-release-el7-1.noarch.rpm

Installation

Yum install mysql-community-server

Start the service

Service mysqld start

View statu

Service mysqld status

View initial password

Grep 'temporary password' / var/log/mysqld.log

Log in to change your password

Mysql-uroot-p

Use the password found above.

Then enter the command flush privileges

Enter the mysql database use mysql

Modify the password

ALTER USER 'root'@'localhost' IDENTIFIED BY' your password

At this point, the installation and configuration on the server has been completed, and then when connecting remotely, it is found that the connection cannot be successful, which may be due to the fact that the server port 3306 is not open to the public; the database user does not have remote connection login permission

Configure MySQL to allow external access

Enter the mysql database use mysql

Modify the user table of the mysql library to change the host entry from localhost to%. % indicates that arbitrary host access is allowed. If only one ip access is allowed, it can be changed to the corresponding ip.

GRANT ALL PRIVILEGES ON *. * TO 'root'@'%' IDENTIFIED BY' password 'WITH GRANT OPTION;FLUSH PRIVILEGES

The remote connection was tested again and the connection was successful.

The above is how to install MySQL8.0 in CentOS. Have you learned any knowledge or skills? If you want to learn more skills or enrich your knowledge reserve, you are welcome to follow the industry information channel.

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.