Home >Database >Mysql Tutorial >How to install mysql in linux rpm
How to install mysql in linux rpm
- PHPzOriginal
- 2023-04-21 11:22:302748browse
There are many ways to install MySQL on a Linux system, one of which is to use rpm installation. This article will introduce how to install MySQL through rpm.
1. Preparation
Before starting, first confirm whether MySQL and MariaDB already exist in the system. You can check it by running the following command:
rpm -qa | grep mysql rpm -qa | grep mariadb
If they already exist, you need to Uninstall it through the command first.
2. Download the MySQL software package
Go to the MySQL official website to download the required rpm software package and choose the version that suits you. After the download is completed, upload the rpm package to the server. It can be uploaded to any directory.
3. Install MySQL
Use the following command to install MySQL:
rpm -ivh mysql-community-common-8.0.22-1.el7.x86_64.rpm rpm -ivh mysql-community-libs-8.0.22-1.el7.x86_64.rpm rpm -ivh mysql-community-client-8.0.22-1.el7.x86_64.rpm rpm -ivh mysql-community-server-8.0.22-1.el7.x86_64.rpm
Dependency errors may occur during the installation process, and missing dependencies need to be installed.
4. Start and configure MySQL
After the installation is completed, you need to perform some configuration and startup operations on MySQL. Execute the following command to start MySQL:
systemctl start mysqld
Check the status of MySQL:
systemctl status mysqld
After the startup is completed, you can check the initial password of MySQL through the following command:
grep 'temporary password' /var/log/mysqld.log
Log in to MySQL
Use the following command to log in to MySQL and change the password:
mysql -uroot -p ALTER USER 'root'@'localhost' IDENTIFIED BY 'new_password';
5. Firewall configuration
If the system has a firewall enabled and you need to open the MySQL service port, use the following command to open port 3306 ：
firewall-cmd --add-port=3306/tcp --permanent firewall-cmd --reload
At this point, the process of rpm installation of MySQL is completed.
Summary
Installing MySQL through rpm may cause dependency errors, so you need to pay attention to installing missing dependencies. After the installation is complete, some configuration and startup operations are required for MySQL before it can be used normally. At the same time, if the system uses a firewall, the port of the MySQL service also needs to be opened, otherwise remote connection cannot be made.
The above is the detailed content of How to install mysql in linux rpm. For more information, please follow other related articles on the PHP Chinese website!