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


Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • Bookmarks
  • Search
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse
Brand Logo

Cloudron Forum

Apps | Demo | Docs | Install
  1. Cloudron Forum
  2. Invoice Ninja
  3. Direct Access to App's mysql database

Direct Access to App's mysql database

Scheduled Pinned Locked Moved Invoice Ninja
invoiceninja
4 Posts 4 Posters 1.4k Views 5 Watching
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • T Offline
      T Offline
      tamayers
      wrote on last edited by girish
      #1

      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 Reply Last reply
      1
      • girishG Offline
        girishG Offline
        girish
        Staff
        wrote on last edited by
        #2

        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).

        1 Reply Last reply
        1
        • mdreiraM Offline
          mdreiraM Offline
          mdreira
          translator
          wrote on last edited by
          #3

          Hi!

          I have to migrate from a mautic app (outside of cloudron) to the Mautic cloudron app.

          In order to do the migration I need to know database name, user and password (I suppose this will be Cloudron's) of the Mautic app in Cloudron.

          How can I get the name and user of the database?

          Thank you!

          doodlemania2D 1 Reply Last reply
          0
          • mdreiraM mdreira

            Hi!

            I have to migrate from a mautic app (outside of cloudron) to the Mautic cloudron app.

            In order to do the migration I need to know database name, user and password (I suppose this will be Cloudron's) of the Mautic app in Cloudron.

            How can I get the name and user of the database?

            Thank you!

            doodlemania2D Offline
            doodlemania2D Offline
            doodlemania2
            App Dev
            wrote on last edited by
            #4

            @mdreira it's in the environment variables of each installation - just go to the cli of the app and you'll see them there!

            1 Reply Last reply
            1
            Reply
            • Reply as topic
            Log in to reply
            • Oldest to Newest
            • Newest to Oldest
            • Most Votes


              • Login

              • Don't have an account? Register

              • Login or register to search.
              • First post
                Last post
              0
              • Categories
              • Recent
              • Tags
              • Popular
              • Bookmarks
              • Search