Work Space

This is a view of the phpMyAdmin web based interface on a Xammp windows operating system.

Default location address of phpMyAdmin.
http://localhost/phpMyAdmin

If you get a login screen just enter the username a password.

Both phpMyAdmin work spaces are the same for Xammp and MAMP.
So I'll add the fast and quick basics all here.

The list of installed databases are on the left.
The numbers in on the left next to them are the number of tables in the database.

On the right of the workspace is information about the Mysql server.
A  keyword to know is "Collation" this is what's the database default language is
and the sorting order the safest "Collation" is "utf_unicode_ci" because its uses all known language character sets.
That way you store any known language without any issues.
See: http://www.unicode.org/

To make a new database for one of your new data driven web sites.
Enter the database name inside the "Create new database" input field".
Please note: do not start database name with a number or special characters or spaces in the database name.
Select the "Collation" language this can also just be left to the default  "Collation"and press the "Create" button.

You have made your first database.





MAMP