Remote connection to Xibo MySQL DB

[Cedric_REYMOND]

To be completed by the original poster:

CMS Version

4.06

Installation Method

Docker

Operating System

Ubuntu 22.04

Issue

Is it possible to remotely connect to the Mysql Xibo ?
I tried using the pwd defined in the config.env file but that did not work.
Tried on default port and 9505

Does anyone knows how to connect?
Any help appreciated.

Thanks,
Cedric

[dan]

Have you tried these instructions?

How can I run a SQL command when using a Docker Install?

While troubleshooting an issue you maybe asked to run a SQL statement on your database Docker container, or you may want to run a statement yourself for another purpose. To do either of these things there are two options. Using the command line Using the GUI called PhpMyAdmin Command Line Before you can run a statement inside the docker container you will need to find the container name. This can be done using the docker ps command. The resulting output will show a list of running docker con…

[Cedric_REYMOND]

Well that does not reply to my question…
is the default mysql instance installed by Xibo accessible remotely?
I have a mysql tool I would like to use…

[Cedric_REYMOND]

Hello,
tried your suggestion to find some info but getting access denied:

MySQL [cms]> SELECT User FROM mysql.user;
ERROR 1142 (42000): SELECT command denied to user ‘cms’@‘172.19.0.2’ for table ‘user’