Included in the MariaDB package are several commands, including mysql, the interactive command-line interface to the MariaDB DBMS. Also, mysqladmin, non-interactive tool for managing the MariaDB database. mysqldump and mysqlrestore are used to back up and restore databases. Lastly, mysql_secure_installation is used to secure MariaDB.
- [Instructor] MariaDB includes several commands for administering databases. Here you can see the level of compatibility with mysql as they're the same commands that are used with that database. Mysql is an interactive command-line administration interface for managing MariaDB databases. This might include creating databases, tables and users. We can use it to query the databases and manipulate data in them. Mysqladmin is a noninteractive tool that helps you administer a database. It has a lot of the same functionality that the mysql command has but is better to run in scripts or even to run one or two commands without logging into the database like we would with a mysql command.
You could manage tables and databases, start and stop the server, manage users, check service status, among other things. Mysql_secure_installation helps improve the security of the MariaDB server and is a shell script for Linux systems that enables you and improves security by setting a password for the root database account, removing root accounts that are accessible from outside the local host, removing anonymous user accounts and removing the test database, which by default can be accessed by anonymous users.
Mysqldump allows you to easily dump MariaDB databases from creating slave servers or just database backups. And lastly, mysqlimport allows you to import database files created with mysqldump.
- Installing MariaDB server
- MariaDB commands, configuration files, and logs
- Addressing SELinux concerns
- Using the MySQL shell
- Managing databases and tables with subcommands
- Creating a database with tables
- Querying a database
- Renaming tables and updating records
- Setting and recovering the root database password
- Securing your MariaDB server installation
- Performing and restoring logical database backups