PhpMyAdmin

phpMyAdmin is a web interface for MySQL and/or MariaDB databases.

---

Installation

Some Linux distributions offer a phpmyadmin package.

Manual

Fetch the latest version of the software package.

wget https://files.phpmyadmin.net/phpMyAdmin/5.0.1/phpMyAdmin-5.0.1-english.zip

Create an installation directory that can be owned by the web server's user (typically www-data).

mkdir /var/www/phpmyadmin
unzip phpMyAdmin-5.0.1-english.zip
cp phpMyAdmin-5.0.1-english/* /var/www/phpmyadmin/ -r
chown www-data:www-data /var/www/phpmyadmin -R
chmod 775 /var/www/phpmyadmin -R

Update

Move the deployment to /var/www/phpmyadmin-temp and repeat the installation process for the new version. Copy the config.inc.php configuration file from the old to the new deployment. Test and, if successful, remove the old deployment.

---

Configuration

Nginx

For details on configuring nginx(8) for FastCGI, see here.

server {              
  listen 80;                                   
  server_name pma.my-domain.tld;                     

  root /var/www/phpmyadmin;
  index index.php;
                          
  location / {                                                
    try_files $uri $uri/ =404;       
  }                                      
  error_page 404 /index.php;

  location ~ \.php$ {
    fastcgi_split_path_info ^(.+\.php)(/.*)$;
    try_files $uri $document_root$fastcgi_script_name =404;
    fastcgi_index index.php;

    include fastcgi_params;
    fastcgi_param SCRIPT_FILENAME $document_root$fastcgi_script_name;

    fastcgi_pass unix:/run/php-fpm/php-fpm.sock;
  }                         
}

Database

See MySQL or MariaDB for help with installing a database.

On first installation, the phpMyAdmin back-end tables must be configured.

mysql -u root -p < /var/www/phpmyadmin/sql/create_tables.sql

The phpMyAdmin user must be given permissions to many structural tables.

The recommended setup is:

GRANT USAGE ON mysql.* TO 'pma'@'localhost' IDENTIFIED BY 'pmapass';
GRANT SELECT (
    Host, User, Select_priv, Insert_priv, Update_priv, Delete_priv,
    Create_priv, Drop_priv, Reload_priv, Shutdown_priv, Process_priv,
    File_priv, Grant_priv, References_priv, Index_priv, Alter_priv,
    Show_db_priv, Super_priv, Create_tmp_table_priv, Lock_tables_priv,
    Execute_priv, Repl_slave_priv, Repl_client_priv
    ) ON mysql.user TO 'pma'@'localhost';
GRANT SELECT ON mysql.db TO 'pma'@'localhost';
GRANT SELECT (Host, Db, User, Table_name, Table_priv, Column_priv)
    ON mysql.tables_priv TO 'pma'@'localhost';

Some tutorials will also advise granting permissions to the mysql.host table... which as of MariaDB version 10.1 no longer exists.

The nuclear option is always valid:

GRANT USAGE ON *.* TO 'pma'@'localhost' IDENTIFIED BY 'pmapass';

---

CategoryRicottone