phpmyadmin error during installation “Empty value

Question

I have been trying to install phpmyadmin on my digitalocean droplet using ubuntu 14.04 / mysql 5.7.12 . I have a LAMP stack with apache as the web server.

During installation I keep getting the error shown here. E

I am pretty new to phpmyadmin and wondering why I keep getting this. Previously installing phpmyadmin with an older version of mysql was error free. I am trying to install it as a non-root sudo user.

Any direction or suggestions will be greatly appreciated.

Answer 1

None of the above helped in my case - because, somehow, mysql was not running / was not installed (check by sudo systemctl status mysql).

1. Skip the error in Phpmyadmin installation.
2. Reinstall mysql by sudo apt-get install mysql-server mysql-client.
3. Reconfigure with sudo dpkg-reconfigure phpmyadmin and accept the defaults - they will be a bit different this time (but you may want to set the passwords).
4. Say yes to overwrite the config file with maintainer's version.

By the way, the port in phpmyadmin.conf remained dbc_dbport=''.

Answer 2

Our server config - Debian 8.x Mysql 5.7 PHP 5+7 Apache 2.4

This should work :

unistall phpmyadmin (--purge) reinstall phpmyadmin (ignore errors) check for existence of phpmyadmin user and/or database in mysql using mysql console or whatever means. If they don't exist, manually create them and GRANT phpmyadmin user all privileges on phpmyadmin table.

manually edit /etc/dbconfig-common/phpmyadmin.conf so as it reflects current server setup (YOUR mysql settings - dbc_dbserver = 'your_server' dbc_dbport = 'your_mysql_port' and any dbc_ fields that you feel need completion at this time)

manually edit /etc/phpmyadmin/config-db.php so as it reflects current server setup (YOUR mysql settings $dbserver = same_as_above $dbport = your_mysql_listening_port etc. - any other fields that you feel needs completing.

run dpkg-reconfigure phpmyadmin from console with root or administrative privileges

choose Reinstall database for phpmyadmin - YES !! when configuration window asks what you want to do with existing configuration file, choose - "Keep the local version currently installed".

In the console output you shouldn't have any mysql empty port errors anymore. That worked for me.