centos yum install mysql

In CentOS systems, Yum is a powerful package manager that can be used to easily install and upgrade various software. Mysql is one of the most popular relational databases. This article will introduce how to use yum to install Mysql.

1. Install Yum

If Yum is not installed on your CentOS system, please use the following command to install it:

sudo yum install yum

2. Add Mysql Yum source

There is no Mysql package in the CentOS official repository, so you need to add the Mysql Yum source for installation. Mysql officially provides a configuration file for the Yum source, so you only need to add it to the system.

Use the following command to download the configuration file of the Mysql Yum source:

sudo wget https://dev.mysql.com/get/mysql57-community-release-el7-10.noarch.rpm

Install the configuration file:

sudo rpm -ivh mysql57-community-release-el7-10.noarch.rpm

3. Install Mysql

Installation Mysql software package:

sudo yum install mysql-server

During the installation, the system may prompt you whether you want to install dependent packages. Enteryand press Enter.

4. Start Mysql

After the installation is completed, we need to start the Mysql service:

sudo systemctl start mysqld.service

Auto-start at boot:

sudo systemctl enable mysqld.service

5. Configuring Mysql

After starting Mysql, you need to perform some basic configuration, such as setting the password of the Mysql root user.

Use the following command for initial configuration:

sudo mysql_secure_installation

At this time, the system will prompt you to enter the password of the Mysql root user. If this is the first installation, the password is blank by default, just press the Enter key. After that, you will be prompted whether you want to change the password of the Mysql root user. If you want to change the password, please follow the system prompts.

Next, the system will prompt you whether you want to prohibit the Mysql root user from using remote login. For security reasons, it is recommended that you disable remote login to prevent hacker attacks.

The system will also prompt you whether you want to automatically delete anonymous users and test databases. These users and databases are usually unnecessary and it is recommended that you delete them.

6. Test Mysql

After installing and configuring Mysql, you can use the following command to connect to Mysql:

sudo mysql -u root -p

Enter the password of the Mysql root user, that is Can log in to Mysql. At this point, you can start operating and managing the Mysql database.

7. Summary

Through the introduction of this article, you already know how to use yum to install Mysql, as well as some basic configuration and operations. Mysql is a very practical database tool, and mastering this knowledge will help you better manage and process data.

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