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!