centos 7 install mysql-Mysql Tutorial-php.cn

centos 7 install mysql

WBOY

Release： 2023-05-12 09:10:07

Original

680 people have browsed it

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.

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

Copy after login

Then, update yum:

sudo yum -y update

Copy after login

Then, install MySQL:

sudo yum -y install mysql-community-server

Copy after login

Start MySQL

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

sudo systemctl start mysqld

Copy after login

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

sudo systemctl enable mysqld

Copy after login

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

Copy after login

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

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

Copy after login

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

Next, create a new MySQL user and authorize it:

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

Copy after login

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

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

exit

Copy after login

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

Copy after login

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

Copy after login

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!