Rob's web

phpMyAdmin

phpMyAdmin is a free software tool written in PHP, intended to handle the administration of MySQL over the Web. phpMyAdmin supports a wide range of operations on MySQL and MariaDB. Frequently used operations (managing databases, tables, columns, relations, indexes, users, permissions, etc) can be performed via the user interface, while you still have the ability to directly execute any SQL statement.

Security

Mariadb must have passwords with all users.

Installation

# dnf install phpmyadmin

Adding to the vhosts config

Add to the <VirtualHost *:443> section:

# vi /etc/httpd/conf/vhosts.d/private.example.com.conf

Alias /managedb /usr/share/phpMyAdmin
        <Location "/managedb">
                Require all denied
                Require ip 192.168.1.0/24
                Require ip 2a02:xxxx:xxxx::/48
        </Location>

# httpd -t
# systemctl restart httpd

Access

You can access phpMyAdmin by entering: https://private.example.com/managedb and login with the db credentials.

You also must be on the same LAN segment as the SQL-server.

Links