Browser-based database administration needs a working database connection. On openSUSE or supported SLES systems, packaged phpMyAdmin with Apache provides local access to an existing MySQL or MariaDB server. A successful database-account login confirms the installation can reach that server.

The standard openSUSE Leap repositories provide the phpMyAdmin and phpMyAdmin-apache packages. A registered SLES 15 SP7 host on x86-64 obtains the same package names from SUSE Package Hub, whose community packages are not covered by the base SLES support entitlement.

The Apache integration package creates the /phpMyAdmin URL alias and installs the required PHP modules. The packaged Apache rule permits clients that can already reach the web server, so a localhost check does not make the endpoint private. Remote access requires firewall or private-network restrictions and HTTPS.

Steps to install phpMyAdmin on openSUSE and SLES:

  1. Confirm that a local MySQL or MariaDB server is running with a non-root password account authorized for your database.

    phpMyAdmin does not install a database server or create a database login. The account needs privileges on the database you intend to open; a Linux login or a socket-only root account is not a substitute for a database password account.
    Related: How to configure cookie authentication in phpMyAdmin
    Related: How to create a user in MySQL or MariaDB
    Related: How to grant privileges to a MySQL or MariaDB user

  2. Activate SUSE Package Hub on an x86-64 SLES 15 SP7 host.
    $ sudo SUSEConnect -p PackageHub/15.7/x86_64

    Skip this step on openSUSE, where the standard repositories already provide the packages.

  3. Refresh the enabled software repositories.
    $ sudo zypper refresh
    Refreshing service 'openSUSE'.
    Repository 'repo-openh264 (16.1)' is up to date.
    Repository 'repo-oss (16.1)' is up to date.
    All repositories have been refreshed.
  4. Install phpMyAdmin with its packaged Apache integration.
    $ sudo zypper install phpMyAdmin phpMyAdmin-apache

    The phpMyAdmin-apache package installs Apache, the matching PHP module, and the /etc/apache2/conf.d/phpMyAdmin.conf alias configuration.

  5. Start Apache now and at every boot.
    $ sudo systemctl enable --now apache2
    Created symlink '/etc/systemd/system/httpd.service' → '/usr/lib/systemd/system/apache2.service'.
    Created symlink '/etc/systemd/system/apache.service' → '/usr/lib/systemd/system/apache2.service'.
    Created symlink '/etc/systemd/system/multi-user.target.wants/apache2.service' → '/usr/lib/systemd/system/apache2.service'.
  6. Open http://127.0.0.1/phpMyAdmin/ in a browser on the SUSE machine.

    The URL is case-sensitive and points to the machine running the browser. Plain HTTP is suitable only for this local address; a remote login needs HTTPS and restricted network access.

  7. Log in with your database account name and password.

    An access-denied error points to the account's password, authentication method or allowed connection host. A connection error means the database service or its configured socket needs attention.
    Related: How to configure cookie authentication in phpMyAdmin
    Related: How to find phpMyAdmin configuration files

  8. Open a database granted to your account from the left navigation.
  9. Confirm that the database page lists the database's tables.

    An empty database shows an empty list. Here, app_database contains sample_items; your database and table names will differ.

Share this guide