MariaDB is a popular open-source relational database management system that can be easily installed on Oracle Linux 7. In this step-by-step tutorial, we will guide you through the process of installing MariaDB on your Oracle Linux 7 system.
Before you begin, make sure you have:
- An Oracle Linux 7 system.
- Root or sudo access.
- An active internet connection.
Step 1: Update Your System
First, ensure your Oracle Linux 7 system is up to date with the latest software and security updates. Open a terminal and run the following commands:
sudo yum update
This command will update your system’s package repository.
Step 2: Install MariaDB
Oracle Linux 7 includes MariaDB in its default repositories, making installation simple. Use the following command to install MariaDB:
sudo yum install mariadb-server
During the installation, you’ll be prompted to confirm the package installation. Type ‘y’ and press Enter.
Step 3: Start and Enable MariaDB
After installation, start the MariaDB service and enable it to start at boot with the following commands:
sudo systemctl start mariadb
sudo systemctl enable mariadb
You can verify that MariaDB is running with this command:
sudo systemctl status mariadb
Step 4: Secure Your MariaDB Installation
MariaDB comes with a script that helps you secure your database installation. Run the following command:
You’ll be prompted to set a root password, remove anonymous users, disallow root login remotely, and remove the test database. Follow the prompts and answer ‘Y’ or ‘N’ as needed.
Step 5: Log In to MariaDB
Now that your MariaDB installation is secure, you can log in to the database server using the following command:
mysql -u root -p
Enter the root password you set during the installation when prompted.
Step 6: Create a New Database and User
To create a new database and user, follow these steps:
Log in to MariaDB as the root user.
Create a new database (replace
mydatabasewith your preferred name):
CREATE DATABASE mydatabase;
Create a new user and grant privileges (replace
mypasswordwith your desired username and password):
CREATE USER 'myuser'@'localhost' IDENTIFIED BY 'mypassword'; GRANT ALL PRIVILEGES ON mydatabase.* TO 'myuser'@'localhost'; FLUSH PRIVILEGES;
Exit the MariaDB prompt:
Step 7: Test Your MariaDB Installation
You can test your new database and user by logging in with the created credentials:
mysql -u myuser -p
Enter the password when prompted, and you should now have access to the database you created.
You’ve successfully installed MariaDB on your Oracle Linux 7 system, secured the installation, and created a new database and user. MariaDB is a powerful and reliable database system that can serve as the foundation for various web applications and services. You are now ready to build and manage your databases with MariaDB on Oracle Linux 7.