Question

phpmyadmin suddently gives http error 500

Hi,

I have 3 Droplets all with ubuntu 18.04, Php 7.2.24, phpmyadmin ver. 4.6.6. Until yesterday phpmyadmin worked fine, but now it gives me HTTP Error 500. Otherwise there is nothing wrong with the servers - (not that i know of). Has anyone experienced the same?.

I have no problem using heidisql

Is there a safe solution to fix the problem. One of the servers is in production, and vulnerale to downtime.

Show comments

Submit an answer


This textbox defaults to using Markdown to format your answer.

You can type !ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!

Sign In or Sign Up to Answer

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

Accepted Answer

SOLVED!!

After many hours i finally found what was wrong.

In /etc/phpmyadmin/config.inc.php last line there was a “;” missing

$cfg[‘TempDir’] = ‘/usr/share/phpmyadmin/tmp’; <-- ;

Can anyone tell why is this so that the phpMyAdmin server working perfectly fine yesterday suddenly misses a semicolon in the code? Would be great to know the reason.

Hello there! I am totally new in this world but everything can be done if you are able to search in the web.

I followed the tutorial given here in DO “How To Install phpMyAdmin From Source on Debian 10”, my mistake was to copy the code

" . . . $cfg[‘blowfish_secret’] = ‘STRINGOFTHIRTYTWORANDOMCHARACTERS’; /* YOU MUST FILL IN THIS FOR COOKIE AUTH! */ . . . "

First I got an error that xml extension was needed, so I installed it. #sudo apt install php-sml

then I restarted with: #sudo systemctl reload apache2

Then I got the error 500 described in this topic, so I found when I edited the config.inc.php file that the three dots (after " IN THIS FOR COOKE AUTH! */ " were copied too. I deleted them and worked right away.

I wish could help others

Kind regards to all!

and happy coding

Try DigitalOcean for free

Click below to sign up and get $200 of credit to try our products over 60 days!

Sign up

Get our biweekly newsletter

Sign up for Infrastructure as a Newsletter.

Hollie's Hub for Good

Working on improving health and education, reducing inequality, and spurring economic growth? We'd like to help.

Become a contributor

Get paid to write technical tutorials and select a tech-focused charity to receive a matching donation.

Welcome to the developer cloud

DigitalOcean makes it simple to launch in the cloud and scale up as you grow — whether you're running one virtual machine or ten thousand.

Learn more
DigitalOcean Cloud Control Panel