search

Home >Database >Mysql Tutorial >MySQL installation tutorial under Centos7_Mysql

MySQL installation tutorial under Centos7_Mysql

微波
微波Original
2017-06-28 15:45:341656browse

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!

Statement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article：Detailed explanation of IFNULL() and COALESCE() functions that replace null in mysql_MysqlNext article：Detailed explanation of IFNULL() and COALESCE() functions that replace null in mysql_Mysql

Related articles

See more