> For the complete documentation index, see [llms.txt](https://docs.uxwizz.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.uxwizz.com/guides/troubleshooting/agency/multidb.md).

# MultiDB

### Problem:

You can not add new domains when multi-database is enabled.

{% hint style="danger" %}
Failed to create multi-db database. See error log for more.
{% endhint %}

### Cause:

This usually happens because the MySQL user stored in the `multidb-list.php` file does not have privileges to create a new database.

### Solution: 

Execute this MySQL query, with your actual username (`root` in this case) and password:

{% hint style="success" %}

```sql
CREATE USER IF NOT EXISTS `root`@`%` IDENTIFIED BY 'yourpass';
GRANT ALL PRIVILEGES ON *.* TO `root`@`%` IDENTIFIED BY 'yourpass';
```

{% endhint %}

The user needs all privileges on wildcard database names, because it has to be able to create new a new database for the newly added domain.