How can I use phpPgAdmin or phpMyAdmin? Should I install it?

We’ve selected Adminer as our web-based DB admin tool.

You can access it at https://opalN.opalstacked.com/adminer/ replacing opalN with your Opalstack server name.

    4 days later

    Adminer , like oplastack, is a great minimalist approach

    21 days later

    Is there a way to install a single instance of phpMyAdmin that can be used to connect to all/any of the databases in our control panel ? Say at, http://username.opalstacked.com/phpMyAdmin
    Or do we have to install separate phpMyAdmins for each app ?

    • sean replied to this.

      anjanesh Our per-server Adminer install at https://opalN.opalstacked.com/adminer/ (or https://vpsN.opalstacked.com/adminer/ if you are on VPS) can be used with any of your MariaDB and PostgreSQL databases.

      If you want to install your own phpMyAdmin instead of using the Adminer software that we provide then something like this should get you started:

      1. Create an Apache+PHP-FPM app (I'll call it "pma") and attach it whatever site and URI you want (I'll use "domain.com/pma").
      2. Download and extract phpMyAdmin into the app directory, eg: 
        cd ~/apps/pma
wget https://files.phpmyadmin.net/phpMyAdmin/5.0.1/phpMyAdmin-5.0.1-all-languages.zip
unzip phpMyAdmin-5.0.1-all-languages.zip
rm -rf phpMyAdmin-5.0.1-all-languages*
      3. Visit domain.com/pma/setup to complete the installation.
      4. Secure the installation when you've finished setting it up.

      This single installation will allow you to log in to any of your MariaDB databases (unless you configure it otherwise).

          yoonserk the installation steps for phpPgAdmin are nearly identical to those for phpMyAdmin:

          1. Create a PHP app and attach it to the site in the panel.
          2. Download the software and extract it into the app directory: 
            cd ~/apps/appname
wget https://github.com/phppgadmin/phppgadmin/releases/download/REL_5-6-0/phpPgAdmin-5.6.0.tar.bz2
tar jxf phpPgAdmin-5.6.0.tar.bz2 --strip 1
rm phpPgAdmin-5.6.0.tar.bz2
          3. Complete the installation. In this case a couple of lines of config need to be tweaked by running the following commands: 
            # this forces TCP connections
sed -i -e "s/conf\['servers'\]\[0\]\['host'\] = ''/conf\['servers'\]\[0\]\['host'\] = 'localhost'/" conf/config.inc.php
# this restricts the DB list to only the DBs that you own:
sed -i -e "s/conf\['owned_only'\] = false/conf\['owned_only'\] = true/" conf/config.inc.php

          At that point you should be able to log in to your PostgreSQL databases via the site you created in step 1.

            2 years later

            I am trying to install phpmyadmin but after I setup the installation, phpmyadmin is giving 500 error
            Do I need to install phpmyadmin package separately?

            • sean replied to this.

              deatul you shouldn't need to install anything else.

              Please check your logs (under /home/SHELLUSER/logs) for possible clues and feel free to email support if you'd like us to take a look at your setup.

                2 years later

                sean how do we login here? I tried using the just my username, and also my username@opal12.opalstack.com. I tried resetting the password for this shell user. I don't know what I am supposed to put in the field "database". Everything was denied. I am trying to disable a WP plugin that is bringing down all my sites including the WP admin.

                    abunur Since you're using WordPress, you can easily find the correct database login credentials by looking at the wp-config.php file in your WordPress app's root directory.

                      Mastodon