How to Install Databases on RHEL226

Databases are an essential part of many modern applications. They provide a structured way to store and manage data, and they can be used to improve the performance and scalability of your applications. In this tutorial, we will show you how to install and configure the most popular databases on RHEL, including MySQL, PostgreSQL, and MariaDB.

Prerequisites

Before you begin, you will need to have a running RHEL server. You will also need to have root access to your server, or be able to use sudo to run commands as root.

Installing MySQL

MySQL is one of the most popular databases in the world. It is a powerful and versatile database that can be used for a wide variety of applications. To install MySQL on RHEL, you can use the following steps:1. Update your system:
```
sudo yum update
```
2. Install the MySQL server:
```
sudo yum install mysql-server
```
3. Start the MySQL server:
```
sudo systemctl start mysqld
```
4. Secure the MySQL server:
```
sudo mysql_secure_installation
```
5. Create a database:
```
sudo mysql -u root -p
CREATE DATABASE my_database;
```
6. Grant privileges to a user:
```
GRANT ALL PRIVILEGES ON my_database.* TO 'my_user'@'localhost' IDENTIFIED BY 'my_password';
```

Installing PostgreSQL

PostgreSQL is another popular database that is known for its reliability and scalability. It is a good choice for applications that require high performance and data integrity. To install PostgreSQL on RHEL, you can use the following steps:1. Update your system:
```
sudo yum update
```
2. Install the PostgreSQL server:
```
sudo yum install postgresql-server
```
3. Start the PostgreSQL server:
```
sudo systemctl start postgresql
```
4. Initialize the PostgreSQL database:
```
sudo postgresql-setup initdb
```
5. Create a database:
```
sudo -u postgres createdb my_database
```
6. Grant privileges to a user:
```
sudo -u postgres psql
GRANT ALL PRIVILEGES ON DATABASE my_database TO my_user;
```

Installing MariaDB

MariaDB is a fork of MySQL that is known for its performance and scalability. It is a good choice for applications that require high throughput and low latency. To install MariaDB on RHEL, you can use the following steps:1. Update your system:
```
sudo yum update
```
2. Install the MariaDB server:
```
sudo yum install mariadb-server
```
3. Start the MariaDB server:
```
sudo systemctl start mariadb
```
4. Secure the MariaDB server:
```
sudo mysql_secure_installation
```
5. Create a database:
```
sudo mysql -u root -p
CREATE DATABASE my_database;
```
6. Grant privileges to a user:
```
GRANT ALL PRIVILEGES ON my_database.* TO 'my_user'@'localhost' IDENTIFIED BY 'my_password';
```

Conclusion

In this tutorial, we have shown you how to install and configure the most popular databases on RHEL. By following these steps, you can quickly and easily get started with using databases in your applications.

2025-01-25

Previous：Yaki Programming Tutorial: A Comprehensive Guide

Next：Linux Command Programming Tutorial: Automating Your Tasks