From the course: Linux System Engineer: Database Servers Using MariaDB
MariaDB commands
From the course: Linux System Engineer: Database Servers Using MariaDB
MariaDB commands
- [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.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.