linux installation rpm installation mysql

Linux is a widely used and loved operating system that is more flexible and customizable than other operating systems. MySQL is a popular open source relational database management system that runs on Linux, so installing MySQL on Linux is a very common task. This article will introduce the steps to install MySQL through rpm.

Step 1: Download MySQL

Before starting to install MySQL, you need to download the MySQL installation file from the official website. Visit the official website (https://dev.mysql.com/downloads/mysql/) and download the installation file for your Linux version and architecture. For CentOS 7 operating system, you can download the MySQL installation file through the following command:

wget https://dev.mysql.com/get/mysql80-community-release-el7-3.noarch.rpm

Step 2: Install the rpm package

The downloaded MySQL installation file is an rpm package. Install using the following command:

sudo rpm -Uvh mysql80-community-release-el7-3.noarch.rpm

This command will download and install the MySQL Yum repository. These repositories will enable you to install MySQL as well as other MySQL components using Yum commands.

Step 3: Install MySQL

Now, you can install MySQL using the following command:

sudo yum install mysql-community-server

This command Will run the Yum package manager and download and install the MySQL server. During the installation process, you will be asked to accept the MySQL license agreement. If you agree, type "y" and press Enter.

Step 4: Start MySQL

When the installation is complete, use the following command to start MySQL:

sudo systemctl start mysqld

This command will start MySQL server. You can check if MySQL is running using the following command:

sudo systemctl status mysqld

If MySQL is running, this command will display "active (running)". If MySQL is not running, "inactive" will appear here.

Step 5: Set MySQL to start automatically at boot

If you want MySQL to start automatically every time the system starts, you can use the following command:

sudo systemctl enable mysqld

This command will register the MySQL service as a system service so that it can be started automatically when the system starts.

Step 6: Reset the root password

By default, the MySQL root user does not have a password, so you need to follow the following steps to reset the root password:

1. Use the following command to log in to MySQL:

sudo mysql -u root

2. After logging in, use the following command to set a password for the root user:

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

This command will set the password for the root user. Make sure to replace "yourpassword" with your own password.

Step 7: Using MySQL

Now, you have completed the installation and setup of MySQL. You can use the following command to log in to MySQL:

mysql -u root -p

This command will prompt you to enter the password of the root user. After entering, you will enter the MySQL command line. From here, you can create, manage and query databases.

Conclusion

Through this article, you should have learned how to install MySQL using rpm on Linux. This is a simple and quick way to install MySQL, because as long as you master these steps, you can install MySQL on any Linux system that supports rpm package management.

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