Alias /pma /srv/www/htdocs/phpMyAdmin/
<Directory "/srv/www/htdocs/phpMyAdmin">
AllowOverride All
Order allow,deny
Allow from all
</Directory>
Erstelle Verzeichnis …/phpMyAdmin/upload und setze Besitzer auf wwwrun:www
Kopiere create_tables.sql und upgrade_tables_mysql_4_1_2+.sql in das upload Verzeichnis und eventuell anpassen.
Konfigurationsdatei config.inc.php anpassen.
...
/*
* This is needed for cookie based authentication to encrypt password in
* cookie
*/
$cfg['blowfish_secret'] = '*****'; /* YOU MUST FILL IN THIS FOR COOKIE AUTH! Beliebige Passphrase verwenden. */
...
$cfg['Servers'][$i]['extension'] = 'mysqli';
...
/* User for advanced features */
$cfg['Servers'][$i]['controluser'] = 'pma_SSRS8yRAxvIc';
$cfg['Servers'][$i]['controlpass'] = '*****'; # Passwort des Controlusers
/* Advanced phpMyAdmin features */
$cfg['Servers'][$i]['pmadb'] = 'phpmyadmin';
...
/*
* Directories for saving/loading files from server
*/
$cfg['UploadDir'] = '/srv/www/htdocs/phpMyAdmin/upload';
$cfg['SaveDir'] = '/srv/www/htdocs/phpMyAdmin/upload';
$cfg['SuhosinDisableWarning'] = true;
Die Skripte nacheinander in phpMyAdmin importieren.
Kontrolluser erstellen und Rechte SELECT, INSERT, DELETE, UPDATE der Datenbank phpmyadmin erteilen.