{"id":2960,"date":"2024-06-24T12:09:53","date_gmt":"2024-09-08T01:43:53","guid":{"rendered":""},"modified":"2025-02-02T00:46:19","modified_gmt":"2025-02-01T23:46:19","slug":"how-to-install-and-use-mariadb-on-ubuntu-22-04","status":"publish","type":"post","link":"https:\/\/netcloud24.com\/knowledgebase\/how-to-install-and-use-mariadb-on-ubuntu-22-04\/","title":{"rendered":"Linux VPS & VPS Windows Setup Guide | NetCloud24 and Use MariaDB on Ubuntu 22.04"},"content":{"rendered":"

\u00a0<\/p>\n<\/p>\n

\n

\u00a0<\/h1>\n<\/header>\n
\n

MariaDB is a popular open-source database management system that is widely used as a drop-in replacement for MySQL. In this guide, we will walk you through the steps to install and use MariaDB on Ubuntu 22.04. Whether you are deploying it on a local server or using a , this tutorial covers all the necessary steps.<\/p>\n

\n

Step 1: Update Your System<\/h2>\n

Before installing MariaDB, ensure your system is up to date. Run the following commands:<\/p>\n

sudo apt update && sudo apt upgrade -y<\/code><\/pre>\n
Keeping your system updated is crucial for security and performance, whether you’re setting it up locally or on a VPS Windows VPS Servers<\/a> platform.<\/p>\n<\/section>\n
\n
Step 2: Install MariaDB<\/h2>\n
You can install MariaDB using the following command:<\/p>\n
sudo apt install mariadb-server -y<\/code><\/pre>\n
This command will download and install MariaDB along with its dependencies.<\/p>\n<\/section>\n
\n
Step 3: Secure MariaDB Installation<\/h2>\n
After installing MariaDB, it’s important to secure the installation. Run the following command:<\/p>\n
sudo mysql_secure_installation<\/code><\/pre>\n
Follow the prompts to set a root password, remove anonymous users, disallow root login remotely, and remove the test database.<\/p>\n<\/section>\n
\n
Step 4: Start MariaDB Service<\/h2>\n
Start the MariaDB service and enable it to run on boot:<\/p>\n
sudo systemctl start mariadb\r\nsudo systemctl enable mariadb<\/code><\/pre>\n<\/section>\n
\n
Step 5: Log into MariaDB<\/h2>\n
To access the MariaDB command-line interface, run:<\/p>\n
sudo mysql -u root -p<\/code><\/pre>\n
Enter the root password you set during the secure installation process.<\/p>\n<\/section>\n
\n
Step 6: Create a Database<\/h2>\n
To create a new database, use the following command within the MariaDB CLI:<\/p>\n
CREATE DATABASE my_database;<\/code><\/pre>\n
Replace my_database<\/code> with the name of your database.<\/p>\n<\/section>\n
\n
Step 7: Create a User<\/h2>\n
You can create a new user and grant them access to your database with the following commands:<\/p>\n
\r\nCREATE USER 'my_user'@'localhost' IDENTIFIED BY 'my_password';\r\nGRANT ALL PRIVILEGES ON my_database.* TO 'my_user'@'localhost';\r\nFLUSH PRIVILEGES;\r\n            <\/code><\/pre>\n
Replace my_user<\/code> and my_password<\/code> with your desired username and password.<\/p>\n<\/section>\n
\n
Step 8: Show Databases<\/h2>\n
To list all databases, use the following command:<\/p>\n
SHOW DATABASES;<\/code><\/pre>\n<\/section>\n
\n
Step 9: Use a Database<\/h2>\n
To select a database to use, run:<\/p>\n
USE my_database;<\/code><\/pre>\n<\/section>\n
\n
Step 10: Exit MariaDB<\/h2>\n
To exit the MariaDB command-line interface, type:<\/p>\n
EXIT;<\/code><\/pre>\n<\/section>\n