12/30/2014 - 4:38 AM

#Laravel #Homestead #phpmyadmin

#Laravel #Homestead #phpmyadmin

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,   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.