Create MariaDB database, user, and grants

Create a new database and grant a dedicated user full privileges on it. Run inside sudo mysql -u root -p.

Creates an isolated database and a dedicated user with GRANT permissions limited to that database. Using per-application users limits blast radius if credentials are compromised.

When you need this: When deploying a new application that needs its own database credentials.

Variables

Database name *

Database user *

Database password (strong) *

Host the user connects from

Command

11 views 2 copies

Related in this category

Install MariaDB server MariaDB secure installation Backup MariaDB database to .sql file Restore MariaDB database from .sql file

Free account — save snippets into your own collections.