In previous post I’ve talked about installing MySQL in Mac OS X.

Today I want to talk about PhpMyAdmin. Tool which help work with MySQL databases.

Here steps how to install it and configure under Nginx webserver.

1. Create virtualhost for PhpMyAdmin.

Create /usr/local/etc/nginx/sites-available/phpmyadmin file with next content

Edit hosts for PhpMyAdmin

Open /etc/hosts file and add next line

/etc/hosts file should looks like this:

Make symbolic link to sites-avalable/phpmyadmin into sites-enabled

Save files and restart Nginx

2. Download PhpMyAdmin

Link for downloading https://www.phpmyadmin.net/downloads/

3. Put PhpMyAdmin into Nginx document root

Unzip phpmyadmin archive into /var/www directory

Rename /var/www/phpMyAdmin-4.7.5-all-languages into /var/www/phpmyadmin

4. Launch/restart nginx and start php-fpm

5. Test phpmyadmin VirtualHost

Output should be like this:

6. Test PhpMyAdmin in browser

Open http://phpmyadmin in your browser. You should see next page:

7. Login into PhpMyAdmin.

Username: root
Password: Which you have created for ROOT MySQL user during MySQL installation process.
You will see next page:

 

PhpMyAdmin installed. Happy codding!


1 Comment

Sameer · 23 September, 2018 at 09:50

Hi done all steps correctly but after if i got to http://phpmyadmin url still the welcome page of nginx only showing.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.