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
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:
Making the error message clearer here:
[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)