Ddev: How to give user privileges to create more databases in phpMyAdmin?

[Gonzalo2683]

Hello, I have accessed phpMyAdmin, but I have not been able to create additional databases in this instance, as I must configure the container or somewhere to have the privileges to create more databases.

regards

[rfay]

I don't know how to do it in phpmyadmin, but https://stackoverflow.com/questions/49785023/how-can-i-create-and-load-a-second-database-in-ddev tells how to do it (and links to how to do it automatically)

[rfay]

It may be that giving full privs to the 'db' user (using the 'root') user would accomplish that.

[rfay]

You can accomplish what you want this way:

ddev ssh -s db
mysql 
GRANT ALL on *.*  to 'db'@'%';

Then the "Create" button will appear in phpmyadmin.

Added that detail to https://stackoverflow.com/questions/49785023/how-can-i-create-and-load-a-second-database-in-ddev/49785024#49785024

[rfay]

Marking this resolved, follow up if there's more we can do, thanks!

[Gonzalo2683]

Yes, thanks, this solve my problem.