5 Most Common Errors in PhpMyAdmin and Wordpress

Posted By :Shubham Sachdeva |28th January 2021

1. Error (near “ON” at position 25) while importing Table for WORDPRESS


The Solution to this problem is:

Go to opt/lampp/etc/my.cnf or from xampp panel of mysql and edit max_allowed_packet.

max_allowed_packet = 1024M


2. Wordpress 500 Internal Server Error


The Solution to this problem is:

Solution 1. Rename the plugins folder which is in directory wp-contect/plugins, This will disable all the plugins.

If the problem still exists, rename the .htaccess file...

Solution 2. Rename the .htaccess file to .htaccess_whatever_you_like, This will create a new .htaccess file as sometimes the .htaccess file gets corrupted while moving from one server to another.

If the problem still exists, give permission to your directory...

Solution 3. Your directory might not have permission to access...

sudo chmod -R 777 /opt/lampp/htdocs/insuropedia


3. Increase the Import file sizelimit in PhpMyAdmin


The Solution to this problem is:

Step1: To increase the size of uploading file go to php.ini which is found in directory /opt/lampp/etc/php.ini

Step2: Give permission first to php.ini in order to edit the file

sudo chmod -R 777 /opt/lampp/etc/php.ini

Step3: Search for post_max_size and upload_max_filesize using (Ctrl+F)

Step4: Replace the size to 256m.

Step5: Restart xampp Server in order for phpmyadmin to refresh.


4. Error Establishing a database connection


The Solution to this problem is:

Go to wp-config file and check for credentials if they are correct.

define('DB_NAME', 'database_name');

define('DB_USER', 'database_username');

define('DB_PASSWORD', 'database_password');

define('DB_HOST', 'server_name');


5. The requested URL was not found on this server


Solution to this problem is,


There are 2 ways to update the homeUrl and SiteUrl ....

1. Go to phpmyadmin -> Select your database -> Search for wp_options table.

In wp_options table update the siteURl and homeUrl.

2. Login to wordpress dashboard-> Go to General -> Settings

Update the two fieldWordPress Address (URL)” and “Site Address (URL)

If the problem still exists, then edit the apache2.confg file



Step1: Open the terminal: Change the directory to

cd /etc/apache2

Step2: Open the apache.confg file using command

sudo gedit apache2.conf

Step3:  In apache2.cong, search for <Directory var/www/>

Step4: Change the AllowOverride None to AllowOverride All.

Step5: Restart the Xampp and refresh the browser.



About Author

Shubham Sachdeva

Shubham has strong knowledge of PHP and wordpress framework. He has very good understanding of OOPS concepts, MVC and javascript. His approach towards problem solving is commendable moreover he is very competent in coding.

Request For Proposal

[contact-form-7 404 "Not Found"]

Ready to innovate ? Let's get in touch

Chat With Us