Read databases with sqlyog or phpmyadmin


is it possible to connect and read pi hole databases with a gui soft like sqlyog ou phpmyadmin.
it would be very useful
what are the name of the user and the passwords of the databases ?
Bee cool if it is a stupid question. I am a newbee ?


First part sure:

pi@ph5:~ $ rm -f /tmp/f; mkfifo /tmp/f
pi@ph5:~ $

pi@ph5:~ $ cat /tmp/f | sqlite3 /etc/pihole/pihole-FTL.db 2>&1 | nc -l -p 3306 > /tmp/f

dehakkelaar@laptop:~$ nc 3306
main: /etc/pihole/pihole-FTL.db

counters           message            network_addresses
ftl                network            queries

.schema network_addresses
CREATE TABLE IF NOT EXISTS "network_addresses" ( network_id INTEGER NOT NULL, ip TEXT UNIQUE NOT NULL, lastSeen INTEGER NOT NULL DEFAULT (cast(strftime('%s', 'now') as int)), name TEXT, nameUpdated INTEGER, FOREIGN KEY(network_id) REFERENCES network(id));

SELECT ip FROM network_addresses;