'How To Create A New Database For Each Tenant on Laravel Sail, Docker

I'm developing a multi-tenant app first time by using Laravel 8, Tenancy For Laravel on Docker and WSL2. My issue occures when I try to create a tenant. I want to create a new database for each tenant, but creating database trows the following error:

SQLSTATE[42000]:
Syntax error or access violation:
1044 Access denied for user 'sail'@'%' to database 'tenant-a6d0813b-a546-428d-859a-15095724fb73'
(SQL: CREATE DATABASE `tenant-a6d0813b-a546-428d-859a-15095724fb73` CHARACTER SET `utf8mb4` COLLATE `utf8mb4_unicode_ci`)

I don't even know where should I start from because I'm pretty new on Docker, WLS and Laravel Sail. Before I moved this project to Docker, I was able to create databases on Xammp, but not anymore.

docker-compose.yml file is as it's shipped by Laravel exept the part that phpmyadmin is included:

phpmyadmin:
   image: phpmyadmin
   restart: always
   ports:
       - 8080:80
   environment:
       - PMA_HOST=mysql
   depends_on:
       - mysql
   networks:
       - sail

Solution 1:^[1]

I ran into the exact same problem today.

The problem seems to be the db user 'sail' set in the .env file. It doesn't have the required privileges to create a database.

Opening the mysql console with the sail mysql command and trying to create a database with CREATE DATABASE test; causes the same error.

Changing the paramater in the .env file to:

DB_USERNAME=root

and rebuilding the docker container caused an error in the docker creation log and therefore mysql not running at all.

Logging into docker mysql as root and trying to set new privileges to the 'sail' user didn't help either.

What worked for me in the end was building the application with the standard

DB_USERNAME=sail

starting the application with sail up -d and then changing the .env file to

DB_USERNAME=root

After that I reset the config with sail artisan config:clear.

Solution 2:^[2]

Ran into the same problem, what worked for me was creating an init.sql file

GRANT ALL PRIVILEGES ON *.* TO 'sail'@'%';
FLUSH PRIVILEGES;

And adding this to the mysql entry:

volumes:
            - ./path/to/init.sql:/docker-entrypoint-initdb.d/init.sql

Solution 3:^[3]

What worked for me:

I have PhpMyAdmin installed in my container and I able to login to to it using,

server: mysql
username: root
password: secret

After successful login, I navigated to the User Accounts page, selected sail and granted all the permission that was appropriate for my work and save.

This will resolve the issue of SQLSTATE[HY000] [1045] Access denied

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution	Source
Solution 1	Tritol
Solution 2	Mike
Solution 3	BlackPearl

'How To Create A New Database For Each Tenant on Laravel Sail, Docker

Solution 1:[1]

Solution 2:[2]

Solution 3:[3]

Sources

Related Questions

Solution 1:^[1]

Solution 2:^[2]

Solution 3:^[3]