Create MySQL Databse with cPanel and phpMyAdmin
This tutorial will show how to create and populate a basic database using cPanel and phpMyAdmin.
First log in to your cPanel account and click on the icon that says MYSQL Databases
You should now see a screen showing your mySQL information.
We will need to create the database. I will call my database test. Under current Databases in the New Database field type the name of your database, test.
Then select create database, you will be forwarded to a screen that tells you the database was added. Click the go back button to return to management screen.
Now you should see your new database listed under current databases. Notice the naming convention of my database teamc42_Test. This is the (cpanel user)_(database name). The reason that my databases are named that way is because we are using shared hosting for our test site. If you are using a shared hosting package your databases will be named in a similar manor, to keep you ‘test’ database separate from another users ‘test’ database. If you are on a dedicated host the database name will probably just be ‘test’.
In order to access the data we need to add a user and give the user a password. I will call me user ‘testuser’ instead of just ‘test’ to avoid confusion with the actual database. Enter the username and password and then click the ‘Create User’ button.
You will be forwarded to a page telling that the user was added. Click the go back button to return to the previous page.
You will now see that you have a user and a database listed under ‘Add users to your database’. Now we will do just that, add the user to the database. Select the user select your test user and your database. We will give the user all permissions, so check the all permissions box. When you are finished click add user to database. You will be forwarded again and cPanel will let you know that a user was added to the database, click the go back button.
When you return to the Account Maintenance Screen you will now see that you have a user added to your database, and you will also see that cPanel gives you the connection strings for Perl and PHP.
Our database has been created successfully, but now we need to add some sample data. To do this, scroll down to the bottom of the Account Maintenance Screen and click the phpMyAdmin Link. You should be redirected to the phpMyAdmin screen.
On the left you will notice that is says “No tables found in the database”. We need to add a table so that we can add some data. Click on the link for your test database on the left (teamc42_Test in my case).
We can now create a table in our database. I will call my table ‘TestTable’ and give the table 4 fields and then hit the go button.
Now we can add the information for our table fields. For the first line we will create an ID field. We will make this field the primary key. The primary key must be a unique value so we will make the ID field an auto generated integer. Enter the following information:
Field: ID
Type: Integer
Length/Values: 4
Collation: (blank)
Attributes: (blank)
Null: Not Null
Default: (blank)
Extra: auto_increment
Then we will select the option button for primary key (pictured below).
Then enter the following information for the other 3 fields.
Field 2
Field: FName
Type: Varchar
Length/Values: 30
Collation: (blank)
Attributes: (blank)
Null: Null
Default: (blank)
Extra: (blank)
Field 3
Field: LName
Type: Varchar
Length/Values: 30
Collation: (blank)
Attributes: (blank)
Null: Not Null (this tells mySQL that you must enter a last name)
Default: (blank)
Extra: (blank)
Field 4
Field: PHON
Type: Varchar
Length/Values: 12
Collation: (blank)
Attributes: (blank)
Null: Null
Default: (blank)
Extra: (blank)
When you are finished hit the save button. You should see the following information:
We can now add data to the table. Click TestTable on the left menu.
Now click the insert button located at the top of the screen.
You can now enter your test data. Remember to leave the ID field blank because it will be auto generated.
I will enter two records and then click the go button. MySQL will tell you that the data was inserted.
To view the data in your table click the browse button at the top. The data should be displayed like below.
You have successfully populated your table. You can now close the window. The next step would be to build to access the data through a web application (I prefer PHP). If you return to the Account Maintenance screen you will see that cPanel has given yout he connection string if you would like to get started. I will continue this tutorial to show you how to access the data later on. Look for a part 2 to this tutorial soon.
Popularity: unranked [?]
on May 24th, 2007 at 12:38 am
Thanks! This helped me a lot tonight.
on May 24th, 2007 at 10:46 pm
Thank you sooooooooooooooooooo much. I was looking for something like this for a while now. Now I will look for your part 2. Mirian
on May 27th, 2007 at 1:28 pm
i get a lot knowledge from here
it a excellent site
thanks
on June 25th, 2007 at 9:43 am
this is what ive been waiting for, this has helped me a lot, I just wish there was part 2, because im a little stuck now, Im starting to understand the hole thing a little better now, my email is damiencurtis@hotmail.com, can anyone tell me how to add the tables in to my website and then add a search bar.
on June 25th, 2007 at 10:49 am
I will try write part 2 of the tutorial soon. It will cover reading data from the database use php.
on June 26th, 2007 at 4:15 pm
Thanks for the great tutorial John. I’m looking forward to “part 2″… Please hurry : )
If you could give us an idea when you will post it, I would be thankful.
Josh
on July 11th, 2007 at 8:04 am
still waiting
on July 24th, 2007 at 7:16 pm
Really, It is very interesting
on July 27th, 2007 at 2:05 am
Just checking …when is the next or the 2 part of the tutorial.I thank you for the last one,,,,very gooooooooooooooooood ….
C’ yah….
on July 27th, 2007 at 6:32 am
Sorry, it has been a little hectic around here lately. I am starting a new job. I will try to get part two up as soon as I can.
on September 17th, 2007 at 1:06 pm
Hi
Very interesting information! Thanks!
G’night
on October 17th, 2007 at 9:44 pm
Thanks so much,
I am only starting for the database for my site, this really help me so much
God Bless
on November 12th, 2007 at 6:25 am
Good article on the databases. I was using the non-gui version but it helped me a lot. Further I would like to do is to send my users data from a html form to mysql database using the php script.
thx.
on November 13th, 2007 at 4:25 pm
hi thank you so much for your partisipation can you please give some examples how can make a tables in my website which we can access the database and retrave the data? thanking your efforts
isam al hassan
on February 6th, 2008 at 5:02 am
this was a great!!! help
thanks alot!!
on March 20th, 2008 at 9:49 pm
Great tips. In another lesson, I was doing everything through notepad and uploading via FTP each tme a change was made. It was taking awhile Good suggestions.
Do you know of any good GUI applications I could use to enter my data into the database.? I downloaded one called Navicat, and run it locally on my machine, but it didn’t seem to able to connect to my dbase on the web.
on March 24th, 2008 at 6:11 am
Its provide good database help with pictures and coding method.
on March 25th, 2008 at 11:02 pm
[...] MyAdmin Database Construction Access Database with PHP Creating Data for Database in PHP [...]
on March 27th, 2008 at 5:32 pm
GnPHFd great site man thanks http://peace.com
on April 24th, 2008 at 7:00 pm
great panel options
on April 26th, 2008 at 2:11 pm
thanks for the great directions