myPHPAdmin

https://www.phpmyadmin.net/

This application is used to manage your database for WordPress.

sudo wget https://files.phpmyadmin.net/phpMyAdmin/5.2.1/phpMyAdmin-5.2.1-english.tar.gz 

sudo tar xvzf phpMyAdmin-5.1.1-english.tar.gz 

sudo cp -avr ./phpMyAdmin-5.2.1-english/. /usr/share/phpmyadmin

The configuration file now needs a secret passphrase (blowfish_secret).

phpMyAdmin blowfish secret generator

In /usr/share/phpMyAdmin rename config.sample.inc.php to config.inc.php.  Use the link above to generate the line of code to add to this file. Change this line with the code that link gives you. 

$cfg[‘blowfish_secret’] = ”; /* YOU MUST FILL IN THIS FOR COOKIE AUTH! */

The $cfg[‘TempDir’] (./tmp/) is not accessible

create tmp under /usr/share/phpMyAdmin.  

I use chmod 755 and chown www-data:www-data so Apache can use it.  I am not a big fan of 777 for it.

The phpmyadmin.conf file to load the phpMyAdmin web site.

Listen <your port>
<VirtualHost *:<your port>>

        ServerName www.scsiraidguru.com:<your port>
        <Directory /usr/share/phpmyadmin>
                Options Indexes FollowSymLinks
        AllowOverride All
        </Directory>

        SSLEngine On
        SSLHonorCipherOrder on
        SSLProtocol -all +TLSv1.3 +TLSv1.2
        Protocols h2 h2c
        # SSLOpenSSLConfCmd Curves X25519:secp521r1:secp384r1:prime256v1
        # SSLOpenSSLConfCmd Curves secp521r1:brainpoolP512r1:brainpoolP384r1:brainpoolP256r1:secp384r1:prime256v1:secp256k1:secp224k1:secp224r1:prime192v1
        SSLOpenSSLConfCmd Groups sect571r1:sect571k1:secp521r1:sect409k1:sect409r1:secp384r1:brainpoolP512r1:brainpoolP384r1
        SSLCipherSuite EECDH+AESGCM:EDH+AESGCM:AES256+EECDH:AES256+EDH:+HIGH:!MEDIUM:!LOW:!CAMELLIA:!aNULL:!eNULL:!EXPORT:!DES:!MD5:!PSK:!RC4:!DES:!RC4:!MD5:!RSA:!3DES:!SRP:!DSS:!SHA1:!SHA256:!SHA384
        SSLCACertificateFile /etc/letsencrypt/live/patrickmckenneylandscaping.com/chain.pem
        Include /etc/letsencrypt/options-ssl-apache.conf
        SSLCertificateFile /etc/letsencrypt/live/patrickmckenneylandscaping.com/fullchain.pem
        SSLCertificateKeyFile /etc/letsencrypt/live/patrickmckenneylandscaping.com/privkey.pem

        DocumentRoot /usr/share/phpmyadmin

        Include /etc/phpmyadmin/apache.conf

        ErrorLog /var/log/apache2/phpmyadmin.com/error.log
        CustomLog /var/log/apache2/phpmyadmin.com/access.log combined

</VirtualHost>
~