phpMyAdmin
plugin_interface.lib.php error
if ($options != null && count($options) > 0) {
if ($options != null && count((array)$options) > 0) {
Secure PhpMyAdmin Login Interface
1. Change Default PhpMyAdmin Login URL
2. Enable HTTPS on PhpMyAdmin
3. Password Protect on PhpMyAdmin
4. Disable root Login to PhpMyAdmin
# vim /opt/lampp/etc/extra/httpd-xampp.conf
Alias /db "/opt/lampp/phpmyadmin"
/opt/lampp/lampp restart
vim /etc/php/7.2/cli/php.ini -> for database upload limit
vim /opt/lampp/phpmyadmin/config.inc.php -> for set root password
vim /opt/lampp/etc/extra/httpd-ssl.conf -> for ssl entry
vim /opt/lampp/etc/original/httpd.conf -> for apache configure
error phpmyadmin
|| (count($analyzed_sql_results[‘select_expr’] == 1)
|| (count($analyzed_sql_results[‘select_expr’]) == 1
root access denied phpMyAdmin
sudo nano /opt/lampp/etc/my.cnf
Skip-grant-tables
How to increase phpMyAdmin upload file size
Step - 1: open php.ini of the appropriate PHP version(s).
For PHP v5.0
sudo vim /etc/php5/apache2/php.ini
For PHP v7.2
sudo vim /etc/php/7.2/apache2/php.ini
Step - 2: Now need to increase below parameters in the php.ini file.
memory_limit = 1500M
post_max_size = 1500M
upload_max_filesize = 1500M
Step - 3: Now you need to restart your apache server to effect changes.
sudo service apache2 restart
increase import database size
nano /etc/php/7.2/apache2/php.ini
memorylimit 128M
postmaxsize 12M
uploadmaxfilesize 10M
No Comments