centos 7 install mysql

CentOS 7 is a powerful server operating system that is widely used in enterprise and personal server configurations. In the use of the server, the MySQL database is an essential component. This article will introduce how to install MySQL database on CentOS 7.

1. Installing MySQL

In CentOS 7, the MySQL database can be installed in two ways: through the official yum library installation or manual download and installation. In this article, we will use the official yum repository for installation.

To install the MySQL database, you first need to add the MySQL official yum library. Execute the following command to add the CentOS official yum library to the MySQL official yum library:

sudo rpm -Uvh https://dev.mysql.com/get/mysql80-community-release-el7-3.noarch.rpm

Then, update yum:

sudo yum -y update

Then, install MySQL:

sudo yum -y install mysql-community-server

2. Start MySQL

After the installation is complete, start the MySQL service through the following command:

sudo systemctl start mysqld

After the service is started, you also need to set MySQL to start at boot:

sudo systemctl enable mysqld

3. Set up MySQL

After starting the MySQL service, MySQL needs to be configured. First, execute the following command to enter the MySQL command line:

sudo mysql -u root

After entering the MySQL command line, set the MySQL root user password:

ALTER USER 'root'@'localhost' IDENTIFIED BY '<password>';

Among them, <password></password> is the password you set for the root user.

Next, create a new MySQL user and authorize it:

CREATE USER '<username>'@'localhost' IDENTIFIED BY '<password>';
GRANT ALL ON *.* TO '<username>'@'localhost' WITH GRANT OPTION;

Where, <username></username> is the username you want to create, <password> is the password set for this user. </password>

Finally, execute the following command to exit the MySQL command line:

exit

4. Firewall settings

In CentOS 7, the firewall is enabled by default. Therefore, if you want to use the MySQL service, you need to ensure that the firewall allows MySQL connection requests. You can enable firewall access to MySQL through the following command:

sudo firewall-cmd --add-service=mysql --permanent
sudo firewall-cmd --reload

Now, the entire process of installing the MySQL database on CentOS 7 has been completed. You can check whether the MySQL service is running normally by using the following command:

sudo systemctl status mysqld

If the MySQL service is running, the installation is successful.

Summary

MySQL is a powerful database management system that can play an important role in server configuration. Installing MySQL on CentOS 7 can be achieved by adding the official MySQL yum library, updating yum, installing MySQL, and modifying MySQL settings and firewall settings. With the above simple steps, you can easily install MySQL on CentOS 7.

The above is the detailed content of centos 7 install mysql. For more information, please follow other related articles on the PHP Chinese website!