Limited access to the database in bedrock-ansible provisioned VM


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.


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.