yum mysql install linux

In recent years, due to the continuous development of the Internet industry, the application of MySQL database has become more and more widespread. Installing a MySQL database in a Linux system has always been a basic skill that developers and operation and maintenance personnel must learn. Next, let’s learn step by step how to use yum to install the MySQL database in the Linux system.

Step One: Update the yum source

Before installing the MySQL database, we need to update the yum source first. yum is a package management tool that requires downloading and installing software from the Internet. The default yum source update speed may be relatively slow or some software packages are incomplete, so we need to update the yum source to eliminate possible problems during installation.

We can update the yum source by using the following command:

yum update

Step 2: Find the MySQL package

After the first step of updating, we can use the following command Find the MySQL package:

yum search mysql

In the search results, we can see multiple versions of MySQL, the most commonly used ones are mysql-server and mysql-client.

Step 3: Install MySQL

Assuming that we want to install MySQL 5.7 in CentOS 7 system, we can use the following command to install:

yum install mysql-server mysql-client

During the installation process , the system will automatically download the dependent software packages and configure and install them accordingly.

Step 4: Start the MySQL service

After installing MySQL, we need to start the MySQL service and set it to start automatically. We can use the following command to start the MySQL service:

systemctl start mysqld

Then, we can set the self-starting of the MySQL service through the following command:

systemctl enable mysqld 

Step 5: Set the MySQL administrator password

MySQL does not have a password after installation by default, so we need to set the MySQL administrator password to ensure its security. We can use the following command to set the MySQL administrator password:

mysqladmin -u root password 'new_password'

Where, 'new_password' is the new password we want to set.

Step 6: Log in to MySQL

After we set the administrator password, we can log in to MySQL through the following command:

mysql -u root -p

Among them, the -u parameter is specified The user name is root, and the -p parameter indicates that a password is required to log in. After the command is executed, the system will prompt us to enter the administrator password.

If the password entered is correct, we can enter the MySQL command line mode and start using the MySQL database.

Step 7: Exit MySQL

After using the MySQL database, we need to exit the MySQL command line mode. We can use the following command to exit MySQL:

exit;

Summary

Through the above steps, we successfully installed the MySQL database using the yum command in the Linux system, set the password, and finally Successfully log in to MySQL and enter the MySQL command line mode.

In use, we need to pay attention to using legal parameters and correct commands to ensure the normal operation, security and stability of MySQL. At the same time, we can also optimize the performance of MySQL and improve its efficiency by configuring MySQL related parameters.

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