Unable to relocate database

Support
1

Hello everyone,

Recently, I had to relocate the Invoiceplane database to another IP. I changed the hostname in application/config/database.php:
$db['default']['hostname']
But it still throws a database error:

Unable to connect to your database server using the provided settings.
Filename: third_party/MX/Loader.php
Line Number: 99

Invoiceplane and the database are on separate servers, but I can connect to the database from the Invoiceplane server.
How can I solve this? Changing the hostname doesn’t seem to work.

2

Sounds like the MySQL server is not allowing connections from other hosts either for the whole server or the single user. Please check both configurations.

3

Yep, that solved it. I missed a setting on the database server which prevented connecting from the new Invoiceplane IP. Thanks!