How to create additional databases in my domain?

[marcoandrei]

Dear friends of EasyEngine:

I created a virtual host for my domain foo.bar in EE4 with a WP installation. Everything is correct, running well.

Inside this domain, I created two PHP apps, each one installed in its own folder (foo.bar/app1 and foo.bar/app2). Now I need to create a DB for each of them.

Is there an easy way to do this? How can I create an extra db not tied to WordPress installation?

Thanks in advance!

[marcoandrei]

I got the solution by myself.

First of all, I must warning that my solution could be insecure for some scenarios, because I granted ALL PRIVILEGES to a DB user. Anyway you can use it as a path to find your own safer solution.

This solution uses global-db. If you created a specific db for your site (using --local-db parameter), you may change global-db to the name of your "local-db".

1. Access your server via SSH.
2. Log in as root in MariaDB / MySQL: cd /opt/easyengine/services && docker-compose exec global-db bash -c 'mysql -uroot -p${MYSQL_ROOT_PASSWORD}'.
3. Create an user: CREATE USER 'username'@'%' IDENTIFIED WITH mysql_native_password BY 'password'; (I used the older, though still secure and more compatible, mysql_native_password method).
4. Grant privileges to the user: GRANT ALL PRIVILEGES ON *.* TO 'username'@'%' WITH GRANT OPTION;.
5. Exit MariaDB / MySQL monitor with: exit;.

Now the user username has all privileges in global-db, including create additional databases, so you can use phpMyAdmin in Admin Tools (or other method) to create and import data to the new databases.

Saúde!