centos mysql yum installation

CentOS is a very popular Linux operating system that can be used in a variety of computer environments. MySQL is one of the most popular open source databases that can be used as the basis for a variety of web applications and other business software. Installing MySQL on CentOS is very simple, just use Yum (Yellowdog Updater, Modified) package manager. In this article, we will explain how to install MySQL using Yum on CentOS.

Step 1: Update the source of Yum first

Before installing MySQL, we need to ensure that our CentOS system is up to date. Update the Yum source using the following command:

sudo yum update

This will update all available packages in the system. This may take a few minutes, depending on your server speed and the number of packages available. After the update is complete, we can proceed with installing the MySQL package.

Step 2: Install MySQL using Yum

After the update operation is completed, we can use the following command to install MySQL on CentOS:

sudo yum install mysql-server

This command will automatically download the MySQL software package and install it. During the installation process, you may need to enter y to confirm the installation. This process may take a few minutes, depending on your server speed and the size of the downloaded package.

Step 3: Start the MySQL service

After the installation is complete, we need to start the MySQL service. On CentOS, we can start it with the following command:

sudo service mysqld start

This command will start the MySQL service and make it always running, even if the server is restarted.

Step 4: Set the root user password of MySQL

By default, MySQL does not set a password for the root user, so we need to set a secure password to ensure the security of our database. On CentOS, we can use the following command to set the root user password:

sudo /usr/bin/mysql_secure_installation

This command will prompt you to set a password for the root user. This password should be a strong password and only those who know the password can access your database.

Step 5: Test MySQL connection

After installing MySQL and setting a password, you can test whether you can connect to the database. On CentOS, you can test using the following command:

mysql -u root -p

This command will ask you to enter the MySQL root user password. If you enter the correct password, you will see the MySQL prompt (mysql>). This indicates that you have successfully connected to the database.

Conclusion

Installing MySQL on CentOS is very simple and only requires a few simple commands. Use the Yum package manager to make the entire process easier. Keep your database secure by establishing a strong password. It is worth noting that before installing MySQL, please update the system to the latest version.

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