Access MariaDB

MauricioOnetto

Hello
I would like to access MariaDB (installed by Mailcow) using Adminer or phpMyAdmin, to avoid installing MariaDB again on the same VPS.
Is it possible?
Thank you

accolon

I’ve used Adminer a few times for debugging things, but I don’t recommend running it on production systems longer than necessary.

Simply put the adminer.php file into ./data/web in your mailcow folder. You can then access it at https://mail.yourdomain.com/adminer.php.

The server name is simply mysql. Passwords can be found in your mailcow.conf file, either in DBPASS for the mailcow user or DBROOT for the database user root.

I guess phpMyAdmin could work as well, unless it has special requirements, e.g. for PHP extensions.

MauricioOnetto

Thanks accolon
The information you provided is very accurate.
Thank you

DocFraggle

I suggest installing a SQL client software (i.e. HeidiSQL for Windows) on your local machine, configure port forwarding via SSH to your mailcow host and access the database this way. Works great.