Janik von Rotz

1 min read

Install phpMyAdmin website

This post is part of my Your own Virtual Private Server hosting solution project.
Get the latest version of this article here: https://gist.github.com/9392925.


phpMyAdmin is a free software tool written in PHP, intended to handle the administration of MySQL over the Web.



Start the installation phpMyAdmin.

sudo apt-get install phpmyadmin

As we use nginx for this installation, hit Tab and Enter on the first prompt.

Chose and enter the MySQL root password on the second prompt.

Create a secure password for phpMyAdmin. Don’t use the MySQL root password!

Add the phpMyAdmin Nginx configuration to one of your websites.

    root /usr/share;

    location ~ .php$ {
        # change the php root for phpMyAdmin
        if ($request_uri ~* /phpmyadmin) {
            set $php_root /usr/share;

Test config and reload Nginx service.

sudo nginx -t && sudo service nginx reload

Open your browser on //[host]/phpmyadmin.

Categories: Web server
Tags: application , mysql , nginx , php , php5 , phpmyadmin , ubuntu
Improve this page
Show statistic for this page