# Limited access to the database in bedrock-ansible provisioned VM

**URL:** https://discourse.roots.io/t/limited-access-to-the-database-in-bedrock-ansible-provisioned-vm/3387
**Category:** trellis
**Created:** 2015-04-01T23:19:39Z
**Posts:** 2

## Post 1 by @luqo33 — 2015-04-01T23:19:39Z

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.

---

## Post 2 by @ben — 2015-04-01T23:23:06Z

> [@luqo33](#):
>
> Is this the default behaviour or I am missing something here?

Yes

> <https://github.com/roots/trellis/blob/f5ce855b8daca909aeaf4acde01a4bfd5ac58bce/roles/wordpress-sites/tasks/database.yml>

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.