PhpMyadmin with PHP7

Note: this might be outdated as of 2018.

Start

		sudo apt-get install phpmyadmin

Link PhpMyAdmin

		sudo ln -s /usr/share/phpmyadmin /var/www

Php.ini

Make sure MuSQLi is loaded as a module in PHP

		sudo vi /etc/php/7.0/apache2/php.ini

Add this line to the bottom of the config (press the G key while in command mode)

		extension=mysqli.so

Setup PhpMyAdmin password

With PHP 7 you cannot run any processes as root which is also applied to the MySQL root user. For security you should create your own PhpMyAdmin account

1. Connect to mysql

sudo mysql --user=root mysql

2. Create a user for phpMyAdmin

Run the following commands (replacing some_pass by the desired password):

CREATE USER 'phpmyadmin'@'localhost' IDENTIFIED BY 'some_pass';
GRANT ALL PRIVILEGES ON *.* TO 'phpmyadmin'@'localhost' WITH GRANT OPTION;
FLUSH PRIVILEGES;

If your phpMyAdmin is connecting to localhost, this should be enough.

3. Optional: allow remote connections

If you want an user with same privileges + remote connection privileges (be aware of security concerns), additionally run:

CREATE USER 'phpmyadmin'@'%' IDENTIFIED BY 'some_pass';
GRANT ALL PRIVILEGES ON *.* TO 'phpmyadmin'@'%' WITH GRANT OPTION;
FLUSH PRIVILEGES;

4. Update phpMyAdmin

Edit /etc/dbconfig-common/phpmyadmin.conf file updating user/password values in the following sections:

# dbc_dbuser: database user
#       the name of the user who we will use to connect to the database.
dbc_dbuser='phpmyadmin'

# dbc_dbpass: database user password
#       the password to use with the above username when connecting
#       to a database, if one is required
dbc_dbpass='some_pass'

Fin!