This is an old revision of the document!
Table of Contents
Quick Reference: Creating a New MariaDB Database and User
1. Log into MariaDB
First, log into the MariaDB server using the root user:
mysql -u root -p
2. Create a New Database
Create a new database named `exampleDatabase`:
CREATE DATABASE exampleDatabase;
3. Create a New User and Grant Permissions
Create a new user `exampleUser` with the password `examplePass` and grant them access to the new database. This user should be able to connect both from localhost and from other network devices.
CREATE USER 'exampleUser'@'localhost' IDENTIFIED BY 'examplePass'; CREATE USER 'exampleUser'@'%' IDENTIFIED BY 'examplePass'; GRANT ALL PRIVILEGES ON exampleDatabase.* TO 'exampleUser'@'localhost'; GRANT ALL PRIVILEGES ON exampleDatabase.* TO 'exampleUser'@'%';
4. Apply Changes
Flush the privileges to ensure that the changes take effect:
FLUSH PRIVILEGES;
5. Exit MariaDB
Exit the MariaDB shell:
EXIT;
Additional Notes
- Ensure that MariaDB is configured to accept remote connections. This typically involves editing the
/etc/mysql/my.cnf
or
/etc/mysql/mariadb.conf.d/50-server.cnf
file and commenting out the line
bind-address = 127.0.0.1
. - Restart the MariaDB service after making configuration changes:
sudo systemctl restart mariadb
Summary
This guide walks you through the steps to create a new database and user in MariaDB, allowing access both locally and from remote network devices.