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 11:05] – [Configuration] Bernard Condrau | deb11:phpmyadmin [2024/04/22 15:29] – [Links] Bernard Condrau | ||
---|---|---|---|
Line 7: | Line 7: | ||
sudo mv phpMyAdmin-5.2.0-english/ | sudo mv phpMyAdmin-5.2.0-english/ | ||
$ sudo chown -R www-data: | $ sudo chown -R www-data: | ||
- | * Up to Debian 9, and in other distributions, | + | |
+ | | ||
===== 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 80: | Line 81: | ||
- 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, | + | - Create a regular MariaDB user for the purpose of managing databases through phpMyAdmin, |
- | GRANT ALL PRIVILEGES ON *.* TO ' | + | MariaDB [(none)]> |
- | exit</ | + | MariaDB [(none)]> |
+ | MariaDB [(none)]> | ||
+ | |||
+ | ===== Run phpMyAdmin ===== | ||
- Access phpMyAdmin by appending ''/ | - Access phpMyAdmin by appending ''/ | ||
- | ==== 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:// | ||
+ | * [[https:// |