Detailed steps for installing and configuring MySQL 8.0 on CentOS

Preface

Here are the steps to install and configure MySQL on CentOS;

text

Download the installation package from the yum source

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

Install

yum install mysql-community-server

Start the service

service mysqld start

View Status

service mysqld status 

View initial password

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

Login Change Password

mysql -uroot -p

The password is the one found above.

Then enter the command flush privileges

Enter the mysql database use mysql;

Change Password

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

At this point, the installation and configuration on the server has been completed. However, when you connect remotely, you find that the connection is not successful. The reason may be that the server port 3306 is not open to the outside world; the database user does not have remote connection login permissions;

Configure MySQL to allow external access

Enter the mysql database use mysql

Modify the user table of the mysql database and change the host item from localhost to %. %This means that any host is allowed to access. If only a certain IP is allowed to access, you can change it to the corresponding IP.

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

Test the remote connection again and the connection is successful.

Summarize

The above are the steps for installing and configuring MySQL 8.0 on CentOS introduced 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!