docs.facundoitest.space

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.
===== Quick Reference: Creating a New MariaDB Database and User =====

==== 1. Log into MariaDB ====
First, log into the MariaDB server using the root user:

<code>
mariadb -u root -p
</code>

==== 2. Create a New Database ====
Create a new database named `exampleDatabase`:

<code>
CREATE DATABASE exampleDatabase;
</code>

==== 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.

<code>
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'@'%';
</code>

==== 4. Apply Changes ====
Flush the privileges to ensure that the changes take effect:

<code>
FLUSH PRIVILEGES;
</code>

==== 5. Exit MariaDB ====
Exit the MariaDB shell:

<code>
EXIT;
</code>

===== Additional Notes =====
- Ensure that MariaDB is configured to accept remote connections. This typically involves editing the <code>/etc/mysql/my.cnf</code> or <code>/etc/mysql/mariadb.conf.d/50-server.cnf</code> file and commenting out the line <code>bind-address = 127.0.0.1</code>.
- Restart the MariaDB service after making configuration changes:

<code>
sudo systemctl restart mariadb
</code>

===== 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.