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.
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
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
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, cb1ebc435675187bdcfb539b370c2e37
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, d6025a37ea8687b5422f951f7288bdc5
is the username you want to create, <password> ;
is the password set for this user.
Finally, execute the following command to exit the MySQL command line:
exit
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!