Connect to lamp app mysql db from outside with db client like tableplus/navicat over ssh tunnel

[andirahmat]

Hi. Is it possible to Connect to lamp app mysql db from outside with db client like tableplus/navicat over ssh tunnel? If so can anyone guide me step by step?

What i've done so far :

1. Create new connection on tableplus
2. Set the ssh tunnel to cloudron (success)
3. Set connection to lamp app db
   mysql host : mysql (failed), lampp app internal ip (failed)
   mysql user : the value of CLOUDRON_MYSQL_USERNAME
   mysql pass : the value of CLOUDRON_MYSQL_PASSWORD
   mysql port : the value of CLOUDRON_MYSQL_PORT

Still not success

[girish]

@andirahmat Try this - https://forum.cloudron.io/topic/3237/remote-sql-support-on-a-per-app-basis/2 . I haven't used tableplus/navcat but if you can post a screenshot maybe it helps debugging further. I think instead of mysql you just need to put in the IP of the mysql container using docker inspect mysql | grep IPAddress

[andirahmat]

@girish said in Connect to lamp app mysql db from outside with db client like tableplus/navicat over ssh tunnel:

@andirahmat Try this - https://forum.cloudron.io/topic/3237/remote-sql-support-on-a-per-app-basis/2 . I haven't used tableplus/navcat but if you can post a screenshot maybe it helps debugging further. I think instead of mysql you just need to put in the IP of the mysql container using docker inspect mysql | grep IPAddress

ah this is it : docker inspect mysql | grep IPAddress

Thank you @girish !