MariaDB is a widely used database in Linux systems.
In the end, you will also see a command to uninstall the database from Ubuntu.
What Is MariaDB?
MariaDB is a popular, free, and open-source database released as a replacement for MySQL.
Here’s aguide to set up MySQL on Ubuntuif you’d like to try it out.
MariaDB is a fast, scalable, top-notch performing database, with support for more storage engines.
MariaDB is mostly used to maintain inventories, and manage transactions and customer information.
This is one way to verify the installation.
you’re free to also check the active status of the installed database for verification.
Provide a secure password and hitEnter.
Then, it’ll ask you to reconfirm the password.
Once the password is saved, you will get a Success message as shown below.
After that, it will ask if you want to remove the anonymous user or not.
It is recommended that you remove it.
It will also confirm if you want to disallow remote root login.
If you disallow it, you’re free to only get in as a root user from localhost.
By default, MariaDB installs a test database.
The script will ask if you want to remove the database or keep it.
It is better to delete it and create a new database.
However, if you want to keep it for testing purposes, selectno.
To load them, enterY.
After you have made the changes, you will see a success message on the terminal.
How to see if MariaDB Is Running
MariaDB begins to run as soon as it is installed.
Here you’ve got the option to run MariaDB queries to interact with the database.
To create the admin account with root privileges, use the command below.
confirm to use your password when issuing the command.
Next, flush the privileges to update the new changes in MariaDB.
you’ve got the option to now exit the MariaDB command line by typing:
3.
This command will completely remove all MariaDB folders and dependencies from your system in a few minutes.
SelectYesto continue uninstalling MariaDB.
Many big names such as Facebook and Google use MariaDB for its unique benefits over other databases.
