MySQL installation tutorial under Centos7

MySQL installation tutorial, for your reference, the specific content is as follows

1. Download

Go to the official website to download the Yum source: Address

2. Installation

rpm -ivh mysql57-community-release-el7-11.noarch.rpm
yum install MySQL-community-server

3. Connection Settings

• No password for initial installation
mysql -u root

• Set password
set password for 'root'@'localhost' =password('password');

#If the following error is reported

#Exit mysql connection and run the following command
mysql_upgrade -uroot -p

#Update the password prompt successfully again

• Set up remote connection

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

The above is the full content of this article. I hope it will be helpful for everyone’s study. I also hope that everyone will support 123WORDPRESS.COM.