Creating a Database Tutorial
Most of you go "I want this!" When you see something related to MySQL and PHP, such as customized tagboards or logging in systems. Even though it's a bit hard at the beginning, you can learn the basics! Please bear with me as I like to write long tutorials to explain every detail so that you would understand.
What you need
In this tutorial, I'm going to use PHPmyAdmin which is available in most hosts including Dreamhost.
What you need:
- A good Knowledge of HTML and PHP
- A Host that Supports PHP
- Concentration on this tutorial =]
Have the Requirements? Good, then follow the steps!
Setting Up Your Database
A database is like any database, and it stores information after it is inserted to it's tables. MySQL databases are important for
many things including setting up login systems, customized tagboards, forums, Oekakis, and much more!
Ok, to create your MySQL database, click Manage databases after you have logged into your Control Panel (It's located in
Overview if you use Dreamhost). Next, scroll down and fill your information, and here is what to fill (using Dreamhost and
most hosts).
Database Name
This is one of the most important steps into creating your database, your database names I advise you to do it in this
format:
yoursitename_databasename
For example, let's say your site is called turtwig and your database is oekaki, you'll do this:
turtwig_oekaki
Get it? Good!
Use Hostname / New Hostname
For this tutorial, I recommend typing a new host name. For example:
mysql.yoursite.com
Great? Continue!
First User / New Username / Pass
Again, I advise you to use a new Username. Then write your pass.
Done? Click Create!
Congratulations!
You have created your first database! To set up tables inside the database, check out our creating tables tutorial!