This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revisionNext revisionBoth sides next revision | ||
deb11:phpmyadmin [2022/09/26 10:57] – Bernard Condrau | deb11:phpmyadmin [2022/09/26 11:15] – Bernard Condrau | ||
---|---|---|---|
Line 11: | Line 11: | ||
===== Configuration ===== | ===== Configuration ===== | ||
- We will not use any of the standard path used in Debian versions up to 9 or in other distributions. All files related to phpMyAdmin will remain in the custom path where we moved the downloaded files which is the easiest way for maintenance and later version upgrades (''/ | - We will not use any of the standard path used in Debian versions up to 9 or in other distributions. All files related to phpMyAdmin will remain in the custom path where we moved the downloaded files which is the easiest way for maintenance and later version upgrades (''/ | ||
- | - Make a new directory for phpMyAdmin to store its temporary files:< | + | - Make a new directory for phpMyAdmin to store its temporary files:< |
- Copy '' | - Copy '' | ||
- Use the [[https:// | - Use the [[https:// | ||
Line 67: | Line 67: | ||
< | < | ||
Require all denied | Require all denied | ||
- | </ | + | </ |
+ | |||
+ | # Secure access to phpMyAdmin by restricting access to it's parent, for example by IP address or domain name, local or external | ||
+ | < | ||
+ | < | ||
+ | Require ip 127.0.0.1 | ||
+ | Require forward-dns ddns.domain.name | ||
+ | </ | ||
+ | </ | ||
+ | </ | ||
- You can replace the directives for the setup directory with '' | - You can replace the directives for the setup directory with '' | ||
- Symlink the configuration file for Apache and restart the service:< | - Symlink the configuration file for Apache and restart the service:< | ||
$ sudo service apache2 restart</ | $ sudo service apache2 restart</ | ||
+ | - Create a regular MariaDB user for the purpose of managing databases through phpMyAdmin, if you haven' | ||
+ | MariaDB [(none)]> | ||
+ | MariaDB [(none)]> | ||
+ | MariaDB [(none)]> | ||
- | * Create a regular MariaDB user for the purpose of managing databases through | + | ===== Run phpMyAdmin |
- | GRANT ALL PRIVILEGES ON *.* TO 'user'@'localhost' | + | - Access phpMyAdmin by appending |
- | exit</ | + | |
- | * [[https:// | + | |
- | ==== Manual Upgrade on Debian 9 ==== | ||
- | * Check latest version of [[https:// | ||
- | * Download and install< | ||
- | sudo wget https:// | ||
- | tar xzf phpMyAdmin-5.1.0-english.tar.gz | ||
- | sudo mv phpMyAdmin-5.1.0-english phpmyadmin</ | ||
- | * Modify the following lines in / | ||
- | define(' | ||
- | * See [[https:// | ||
- | |||
- | ===== Securing Your phpMyAdmin Instance ===== | ||
- | Edit / | ||
- | Alias /phpmyadmin / | ||
- | < | ||
- | Options FollowSymLinks | ||
- | DirectoryIndex index.php | ||
- | | ||
- | # Allow user to access without password | ||
- | Include conf-available/ | ||
- | | ||
- | < | ||
- | < | ||
- | AddType application/ | ||
- | </ | ||
- | < | ||
- | SetHandler application/ | ||
- | </ | ||
- | | ||
- | php_flag magic_quotes_gpc Off | ||
- | php_flag track_vars On | ||
- | php_flag register_globals Off | ||
- | php_admin_flag allow_url_fopen Off | ||
- | php_value include_path . | ||
- | php_admin_value upload_tmp_dir / | ||
- | php_admin_value open_basedir / | ||
- | </ | ||
- | </ | ||
- | conf-available/ | ||
- | # Allow user to access without password | ||
- | Require ip www.xx.yyy.zzz | ||
===== Links ===== | ===== Links ===== | ||
* [[https:// | * [[https:// | ||
* [[https:// | * [[https:// |