Help: phpMyAdmin how to access the DB

General Discussion
1

Hello,

I am trying to make a DB accessible outside the network. I have already opened port3306 for access, however its still closed.

I used an application before that worked, It’s called XAMPP. It was on windows and it had an all in one installer with FTP, DB and phpMyadmin on it.

I’d like to ask a simple instruction to setup a remote database using resources from dietpi.

2

Due to security, by default MariaDB is configured to accept connection from localhost only. You should be able to check LISTEN ports like this.

ss -tulpn | grep LISTEN

You need to adjust MariaDB configuration to have it LISTEN to all network interface (0.0.0.0)

3

The config is /etc/mysql/mariadb.conf.d/50-server.cfg and you can adjust the related bind-address setting at best via custom config, e.g. /etc/mysql/mariadb.conf.d/99-local.cfg. Set the value to 0.0.0.0 to allow all remote connections.