Creating a MySQL Database

Page One: But First, a Database -->
Page Two: Data Types-->
Page Three: Using phpMyAdmin to create the simple database-->
Page Four: Defining our Database Fields-->
Page Five: Inserting some Data into our Table-->

Using phpMyAdmin

Fire up phpMyAdmin in your browser. You should see the welcome screen and a text field where you can enter the name of a database. Let’s enter in the name rescued_pets, then select the "create" button.

phpMyAdmin home page

If all goes well, you should see a new page with the message "Database rescued_pets running on localhost." No tables are in the database yet, though. You can choose to run an SQL query in the text area field to create one and all of its fields. Alternatively, you can let phpMyAdmin make it easier by using the "Create new table on database rescued_pets:" text field. I vote for that, so lets do it. Enter in the name "adoption_list" (without the quotes) and enter 8 as the number of fields. Click the "Go" button.

Create a table in phpMyAdmin

The next screen is a thing of beauty. Rather than type in data types and other attributes in the SQL statement (and making typos, and forgetting quotes and semicolons at the end of statements), customizing our fields is as easy as using some drop down menus and text fields. Are you dying from the suspense? Next-->

Back to Unix Tips Page-->