Birmingham mumbai

Managing MariaDB databases
Now that our MariaDB
 server is up and running, we can finally look into managing 
it. In this section, I'll demonstrate how to connect to a database server using the 
mariadb
 command, which will allow us to create databases, remove (drop) them, and 
also manage users and permissions.
To begin, we'll need to create an administrative user for MariaDB. The 
root
 account 
already exists as the default administrative user, but it's not a good idea to allow 
others to use that account. Instead, it makes more sense to create an administrative 
account separate from 
root
 for managing our databases. Therefore, we'll begin our 
discussion on managing databases with user management. The users we'll manage 
within MariaDB are specific to MariaDB; these are separate from the user accounts 
on the actual system.
To manage and interact with databases, we'll need to enter the MariaDB shell, and 
the same goes when it comes to creating database users. Right now, since we only 
have the 
root
 account, we'll need to access the current MariaDB implementation 
as 
root
 in order to set up our administrative user. If you've set up standard 
authentication, as we discussed earlier in this chapter, you can access the prompt 
using the standard means:
mariadb -u root -p
If you haven't switched the 
root
 account to standard authentication, you can simply 
access 
mariadb
 with 
sudo
:
sudo mariadb

---

Chapter 13