Llamasery.com Home  
 
Server-side Starter Tutorial: MySQL 101 - Part 2 of 8
Alfie the alpha_geek: Llamasery guru-in-waiting Tutorials Purpose

Starter Tutorials

Tell-a-Friend
Tell-a-Friend +
The 'Contact Form'
php Includes
Simple Themes
MySQL database 101
Comments System
Text Files

Intermediate Material

Articles/Tutorials

And now - the database

Databases are created using your web site Control Panel (typically at http://www.yourdomain.tld/cpanel), and beginning by choosing the MySQL Databases option. Your Control Panel may not look exactly like the view below, depending on the version (or theme/skin) your web host has provided. Some use simple text links, others use image links.

Using the MySQL database 'management' tools is straightforward. You create a (new) database, giving it any name you want. Remember that for this tutorial we want a database named members. Since the database actually resides on your web host's space (shared by all users of that server), the database name will have your choice of name prepended with the hosting account username provided by your web host. The 'real' name of your new database will be your-accountname_members.

There's an excellent tutorial already in place at the Llamasery Forum which you should read as it explains in simple steps all you need to do to create a database.

The really important thing to do is write down the database name, the database user name, and the database password. And make sure you give that database user access to that database! If you omit either of those steps, you're going to have trouble later.

Now what?

Don't lose the piece of paper on which you wrote your database name, your database username, and your database password - you'll need those (often).

«  previous  |  next  »