Содержание

phpMyAdmin

Nginx

Добавляем в /etc/nginx/sites-available/default в секцию server{}:

	location /phpmyadmin {
	    root /usr/share/;
	    index index.php index.html index.htm;
	    location ~ ^/phpmyadmin/(.+\.php)$ {
		    try_files $uri =404;
		    root /usr/share/;
		    fastcgi_pass unix:/run/php/php7.0-fpm.sock;
		    fastcgi_index index.php;
		    fastcgi_param SCRIPT_FILENAME $request_filename;
		    include /etc/nginx/fastcgi_params;
		}
	    location ~* ^/phpmyadmin/(.+\.(jpg|jpeg|gif|css|png|js|ico|html|xml|txt))$ {
		    root /usr/share/;
	    }
	}
	location /phpMyAdmin {
	    rewrite ^/* /phpmyadmin last;
	}

Перегружаем nginx:

sudo service nginx reload

Apache

В Ubuntu 16.06 ошибка:

The mbstring extension is missing. Please check your PHP configuration

Доустанавливаем:

sudo apt-get install php-mbstring php7.0-mbstring php-gettext
sudo phpenmod mcrypt
sudo phpenmod mbstring
sudo service apache2 restart

http://askubuntu.com/questions/772397/mbstring-is-missing-for-phpmyadmin-in-ubuntu-16-04

Ошибки

#1698 - Access denied for user 'root'@'localhost'

По умолчанию root в базе создан на аутентификацию из системы:

GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' IDENTIFIED via unix_socket;

Необходимо поменять на:

GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' IDENTIFIED BY 'пароль';
FLUSH PRIVILEGES;