Phpmyadmin mamp for windows
You may get a permissions error when you try to open MAMP the first time. Now you are on the main phpMyAdmin page that you will use for this lesson's studio. Enter the username: "root" and the password: "root" to login.Select the dropdown menu under Tools and click on phpMyAdmin.
In your browser you should now be at localhost:8888/MAMP/.Reopen MAMP, ignore it if there is a message about the ports, and click Open start page.Open MAMP and go to Preferences., then click the Ports tab and click the "Set MAMP ports to default" button.Keep the default option to let it create desktop icon.Keep the default option to let it create a shortcut.Keep the default destination of C:\MAMP.Uncheck the MAMP PRO box (do NOT download it).We highly recommend using a 3.x version at the current time. Note: Recent 4.x versions of MAMP have had issues on some Windows installs. Double click to install and allow it to make changes on the hard drive. Go to and download a 3.x version of the Windows installer for MAMP.
#PHPMYADMIN MAMP FOR WINDOWS HOW TO#
For further help on LAMP installation (LAMP is the Linux equivalent of MAMP), check out How To Ubuntu or Bitnami. You might also install phpMyAdmin or another MySQL management application. If you use Linux, you should install, at a minimum, the MySQL 5.x package for your system. The first step in this lesson is to install MAMP onto your computer by following the instructions below for Windows or Mac. While we won't use Apache and PHP directly, they'll provide us with an interface to work with our MySQL server, called phpMyAdmin.
#PHPMYADMIN MAMP FOR WINDOWS FOR MAC#
The acronym MAMP stands for Mac / Apache / MySQL / PHP, and despite the first term, there is a version for Windows as well. MAMP is a suite of tools useful for developers. Make sure you remember to use " " to end all of your statements. Note that the UI is not wonderful, and the syntax checker can be finicky. Some of this content will overlap with what you learned in the w3schools tutorial above that's okay - the added explanations and practice should help. Note that you will have already covered the lessons on Drop Table, Create Table, and Foreign Keys in the Class 7 Prep.Ĭomplete all the lessons in: Modifying databases with SQL. Taskĭo all the lessons under SQL Database from "SQL Create DB" through "SQL Hosting". We'll also expand our knowledge of SQL by working through some additional exercises at w3schools. In this lesson, we'll install MAMP and learn how to use a real database on your computer through phpMyAdmin. Now you should have a good grasp on basic SQL syntax and commands, as well as an understanding of how relational databases work.