# phpMyAdmin

# plugin\_interface.lib.php error

sudo vim /usr/share/phpmyadmin/libraries/plugin\_interface.lib.php

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

[http://localhost/db/index.php](http://localhost/db/index.php)

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

sudo vim /usr/share/phpmyadmin/libraries/sql.lib.php

 || (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**