MariaDB administration commands for beginners
Earlier we have learned to install & secure MariaDB server on Centos/RHEL 7, which is now the default database of RHEL/CentOS 7 onwards.We will now discuss some useful MariaDB administration commands. These are some very basic commands that will get you started with using MariaDB & these can also be used with MySQL, since Mariadb is forked out version of MySQL only.
(Recommended Read: MongoDB installation & configuration on RHEL/CentOS)
MariaDB Administration Commands
- Checking version of your MariaDB installation
To check the current version of your DB installation, type following command in your terminal
This command provide you with the current version of DB. Alternatively you can also run below mentioned command for detailed view on version,
- Logging into mariadb
To log into the mariadb server, run
& then enter password to login to the session.
- Showing all database
To show all the databases that your maridb currently has, run
after you are logged into mariadb.
- Creating new databases
To create a new database in mariadb, run
when logged into mariabdb. To create a database directly from terminal, run
Here, dan is the name of the new database.
- Deleting a database
To delete a database, run
from the logged in session of mariadb. Alternatively you can also use,
Note:- If you are getting an ‘access denied’ error while running the mysqladmin commands, that might be because we have not given rights to root. To do so, run the command mentioned in point 7, replacing name of the user with root.
- Creating new user
To create a new user for database, run
- Granting access to user for a database
For providing access to user for a single database, run
This will provide user dan complete access over database named test. We can also grant SELECT, INSERT , DELETE permissions to user.
To provide access to all database, replace test with * i.e.
- Creating backup/dump of database
To create of a single database, run the following command from your terminal window,
To create backup of multiple databases in single command,
To create dump of all databases in single command,
- Restoring database from the dump
To restore database from a dump, run
But this command will work only when there is no previous database by the same name. if you want to restore database data to any already created database, we need to use ‘mysqlimport ’ command,
- Changing password for a user in mariadb
We are going to change password of ‘root’ for this example but you can use the below process to change password of any user,
Login into mariadb& select ‘mysql’ database ,
& then run the following ,
Next, reload the privileges,
& then exit the session.
This was our tutorial on some useful MariaDB administration commands. Please do leave your comments or suggestions in the comment box below.