Cloudron makes it easy to run web apps like WordPress, Nextcloud, GitLab on your server. Find out more or install now.


Direct Access to App's mysql database

Invoice Ninja
Log in to reply
  • T

    Hello! I am having some issues with the underlying data in one of my InvoiceNinja installation. After talking with InvoiceNinja's team, they are telling me that I need to modify some records in the mysql database directly. Is there a way that I can access a Cloudron's apps database from a UI like phpmyadmin that I have running remotely? If so, can someone point in a direction on how to connect?

    1
  • girish
    Staff

    The MySQL server is not exposed. Are you OK to be able to use the mysql CLI?

    You can access the database either
    a) Web terminal -> Click the mysql button on the top -> Press enter. This drops you into mysql shell. You can then do 'show tables' etc.

    b) Install Cloudron CLI (npm install -g cloudron) on your laptop/PC. Then:

    cloudron exec --app ninja.example.com -- bash -c 'mysql --user=${CLOUDRON_MYSQL_USERNAME} --password=${CLOUDRON_MYSQL_PASSWORD} --host=${CLOUDRON_MYSQL_HOST} ${CLOUDRON_MYSQL_DATABASE} -e "SHOW TABLES"';

    (If you remove the -e "SHOW TABLES" part, you will get a shell).

    0