Limited access to the database in bedrock-ansible provisioned VM

Hello,

I’ve provisioned a local VM with the default bedrock-ansible configuration.

Having ssh’ed into the VM, I am able to connect to the database with mysql -u XXX -pXXX. However, I do not have permission to create a new database from the shell. This is the output that I get:

MariaDB [(none)]> create database test_local;
ERROR 1044 (42000): Access denied for user ‘luqo33’@‘localhost’ to database ‘test_local’

Is this the default behaviour or I am missing something here?

I appreciate your help, as always.

Yes

You can create your own tasks for another DB, or from the box itself you can login to MySQL as the root user and create a new database. See mysql_root_password at the top of your development group_vars.