Installing MariaDB on a CentOS VPS
Welcome! Today we’ll show you how to install MariaDB on a virtual server running CentOS. MariaDB is a powerful relational database management system, perfectly suited for web applications and other projects.
To begin, you’ll need SSH access to your server. Open your terminal and connect to the server using the command:
ssh user@ip_address
Next, we’ll install the MariaDB repository using these commands:
sudo yum install https://downloads.mariadb.com/MariaDB/mariadb_repo_setup
sudo mariadb_repo_setup
Now, let’s install MariaDB itself using this command:
sudo yum install MariaDB-server MariaDB-client
After installation, let’s start MariaDB and enable it to start on boot:
sudo systemctl start mariadb
sudo systemctl enable mariadb
Now, let’s secure MariaDB using this command:
sudo mysql_secure_installation
Follow the instructions to set the root user password and configure other security settings.
Congratulations! You now have MariaDB installed on your CentOS server. Enjoy using this powerful database for your projects!