Question

http error 500 after installing phpmyadmin. Digitalocean

  • Posted January 19, 2022
  • LEMP

Hi! I need help accessing /phpmyadmin. Have not installed it before on an IP adress, since I’m new at DO and have only been playing around in localhost. I just deployed my site and where supposed to access my database through phpmyadmin, but got stuck at a http 500 error. Thankfull for all the help I can get.

We did a new systemlink: sudo ln -s /usr/share/phpmyadmin/ /var/www/html/phpmyadmin

We restarted nginx: sudo service nginx restart

ipadress/phpmyadmin: “This page isnt working” http 500 error”

Search for error: tail -f /var/log/nginx/error.log

Error we got:
#0 /usr/share/phpmyadmin/libraries/classes/Url.php(206): PhpMyAdmin\Url::getArgSeparator()
#1 /usr/share/phpmyadmin/libraries/classes/Url.php(169): PhpMyAdmin\Url::getCommonRaw()
#2 /usr/share/phpmyadmin/libraries/classes/Core.php(749): PhpMyAdmin\Url::getCommon()
#3 /usr/share/phpmyadmin/libraries/classes/Core.php(330): PhpMyAdmin\Core::linkURL()
#4 /usr/share/phpmyadmin/libraries/classes/Core.php(353): PhpMyAdmin\Core::getPHPDocLink()
#5 /usr/share/phpmyadmin/libraries/classes/Core.php(973): PhpMyAdmin\Core::warnMissingExtension()
#6 /usr/share/phpmyadmin/libraries/common.inc.php(106): PhpMyAdmin\Core::checkExtensions()
#7 /usr/share/phpmyadmin/index.php(27): require_once('...')
#8 {main}
  thrown in /usr/share/phpmyadmin/libraries/classes/Url.php on line 253" while reading response header from upstream, client: 62.84.204.10, server: localhost, request: "GET /phpmyadmin/ HTTP/1.1", upstream: "fastcgi://unix:/run/php/php8.0-fpm.sock:", host: "164.92.226.35"

We have gave this phpmyadmin folders these permissions: chmod 755 -R /usr/share/phpmyadmin chmod 644 /etc/phpmyadmin/config.inc.php

Subscribe
Share

Making the error message clearer here:

#0 /usr/share/phpmyadmin/libraries/classes/Url.php(206): PhpMyAdmin\Url::getArgSeparator()
#1 /usr/share/phpmyadmin/libraries/classes/Url.php(169): PhpMyAdmin\Url::getCommonRaw()
#2 /usr/share/phpmyadmin/libraries/classes/Core.php(749): PhpMyAdmin\Url::getCommon()
#3 /usr/share/phpmyadmin/libraries/classes/Core.php(330): PhpMyAdmin\Core::linkURL()
#4 /usr/share/phpmyadmin/libraries/classes/Core.php(353): PhpMyAdmin\Core::getPHPDocLink()
#5 /usr/share/phpmyadmin/libraries/classes/Core.php(973): PhpMyAdmin\Core::warnMissingExtension()
#6 /usr/share/phpmyadmin/libraries/common.inc.php(106): PhpMyAdmin\Core::checkExtensions()
#7 /usr/share/phpmyadmin/index.php(27): require_once('...')
#8 {main}
  thrown in /usr/share/phpmyadmin/libraries/classes/Url.php on line 253" while reading response header from upstream, client: 62.84.204.10, server: localhost, request: "GET /phpmyadmin/ HTTP/1.1", upstream: "fastcgi://unix:/run/php/php8.0-fpm.sock:", host: "164.92.226.35"

[I’ve also tried Kenboye’s solution but did not find any missing ‘;’

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

$cfg[‘TempDir’] = ’/usr/share/phpmyadmin/tmp’; <– ;](https://www.digitalocean.com/community/questions/phpmyadmin-suddently-gives-http-error-500)


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

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.

I struggled with this problem for an entire week. Fortunately, I was able to find the solution.

First Install MBSTRTING exension for your PHP Version. eg

Do

sudo apt install php8.0-mbstring

It will tell you to install MYSQLI extension for your PHP Version

Do

sudo apt-get install php8.0-mysql

Have a great day!

Hi @Civalero,

It seems like there is a PHP error in the code which is very strange. What I’ll suggest you to do is delete PHPMYADMIN and re-install it. If there are any PHP errors you might need a developer to look at them otherwise you might end up in a rabbit hole resolving one error after another.

I’ll recommend giving the following tutorial a read:

https://www.digitalocean.com/community/tutorials/how-to-install-and-secure-phpmyadmin-on-ubuntu-20-04