Cacher is the code snippet organizer for pro developers

Using phpMyAdmin with Homestead box

Once the Homestead vagrant box is installed successfully, we can add phpMyAdmin and config it to run with Nginx.

Install phpMyAdmin

• SSH into Homestead vagrant box with vagrant ssh and type the following command:

    sudo apt-get install phpmyadmin

• when prompted to select the Web server, select apache2 and press Enter, just to get pass it.
• when prompted to config database for phpmyadmin with dbconfig-common, select Yes and press Enter.
• when prompted for Password of the database's administrative user, enter secret and press Enter.
• when prompted for MySQL application password for phpmyadmin, enter secret and press Enter.
• when prompted for Password confirmation, enter secret again and press Enter.

Create and config site for Nginx

sudo ln -s /usr/share/phpmyadmin/ /usr/share/nginx/html/phpmyadmin

serve phpmyadmin.app /usr/share/nginx/html/phpmyadmin

Adding phpMyAdmin.app to hosts file

• Run Notepad as Administrator, then open navigate to C:\Windows\System32\drivers\etc.
• You may need to type *.* and press Enter in File name box to see it.
• Select file hosts and click Open button.
• Add phpmyadmin.app at the bottom of the file like so,

    127.0.0.1   phpmyadmin.app

• Save the file and close Notepad.
• Now use Chrome or any Web browser to navigate to http://phpmyadmin.app:8000 and you should now see phpMyAdmin login page.

Creating new User

• Login to phpMyAdmin as root using password secret
• Goto tab Users and create a user for your app and set privileges as you see fit.