Read databases with sqlyog or phpmyadmin

hi

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 ?

thanks
Bernard

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 10.0.0.4 3306
.databases
main: /etc/pihole/pihole-FTL.db

.tables
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;
10.0.0.1
10.0.0.109
10.0.0.11
10.0.0.143
10.0.0.193
10.0.0.2
10.0.0.220
10.0.0.3
10.0.0.4
10.0.0.46
10.0.0.9
127.0.0.1
::1
fe80::f9d3:c02b:a14d:3318