MySQL installation tutorial under Centos7_Mysql

This article mainly introduces the MySQL installation tutorial under Centos7 in detail. It has certain reference value and interested friends can refer to it. Here is the

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 runs the following command
mysql_upgrade -uroot -p

Updatepassword again Prompt successful

•Set up remote connection

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

The above is the detailed content of MySQL installation tutorial under Centos7_Mysql. For more information, please follow other related articles on the PHP Chinese website!