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: 16% [?]
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
on July 5th, 2008 at 7:31 pm
cool site 10x
on July 5th, 2008 at 11:00 pm
Gloomy tales
on July 6th, 2008 at 4:23 am
good work man
on August 21st, 2008 at 8:31 am
yeah! is nice i must say, 4real i’ve been hooked up for some while now because of this, but my way is through.
thanx ‘ll
on August 25th, 2008 at 12:28 am
Thanks for the tutorial. Big help.
on October 6th, 2008 at 4:59 pm
comment5,
on October 11th, 2008 at 10:44 am
good tutorial. will favorite this
on October 12th, 2008 at 3:31 am
Nice tutorial bro..!!
I was having some errors and your tutorials solved it in minute…
on October 13th, 2008 at 11:36 pm
Absolutely great, and it’s real slick and simple. I am using it now on my website!
Thanks
on October 19th, 2008 at 6:44 am
that great… when will you part 2 be out or how can i locate it
on November 8th, 2008 at 6:32 am
Thanks for this tutorial, i really enjoy and it really helped me alot , you guys are genious
on December 9th, 2008 at 3:17 am
It takes talent to create such an excellent tutorial with newbies in mind. This one tutorial was a great help to me. Thanks Much!!!!!!!!!!!!!!!
J.T.
on December 11th, 2008 at 4:00 am
Was a lot of help. was easy to understand
on January 19th, 2009 at 11:34 pm
great info thanks
on January 21st, 2009 at 6:17 am
Hi,
It really very helpful
Where is next level details.
regards
sameer
on February 13th, 2009 at 10:00 am
Hello
This is a great tutorial and exactly what I have been looking for,although I am having a problem.At the very start of the tutorial you say to create a HTML file that links into the search.php file just to make sure that the variable entered into the search bar is displayed,well it won`t display my variable entered -it opens a new tab which remains blank.I know that it is connecting to the search.php page beacuse when I change form action=search.php in the HTML to form action = searc.php it tells me that there is an error where as when I enter the correct file name it remains blank-any ideas?
Thanks alot
on February 22nd, 2009 at 6:21 pm
Enjoyed the read, will bookmark.
on March 4th, 2009 at 7:21 am
At first it might seem hard to work with phpmyadmin … but … it’s quite easy and you’ll agree with me once you get a little experience with it.
on March 19th, 2009 at 7:41 am
What wonderful help, Danke
on March 20th, 2009 at 3:37 pm
Suuuuuupppper!!
on March 21st, 2009 at 12:03 pm
Omg I neeeeed a part 2. =P
on March 27th, 2009 at 4:30 am
can you please give some examples how can make a tables in my website which we can access the database and retrave the data?
on April 10th, 2009 at 11:44 am
Great work…….. im a newbie and was dying for this info
on April 19th, 2009 at 10:09 am
Its really very good tutorial. It help me a lot get create a database.
on April 30th, 2009 at 2:02 pm
thanx, really it helped me lot,
great job
keep going
on May 21st, 2009 at 12:55 pm
good job man
on June 14th, 2009 at 7:52 am
Thanks a lot. I was looking for a tutorial like this for a long time. It has helped me a lot.
on June 18th, 2009 at 11:03 am
i am use phpmyadmin and launch database to the web server . any option to access the server db through the local phpmyadmin
on June 18th, 2009 at 6:33 pm
I believe you want to access a remote MySQL database locally. Unfortunately I do not know how to do this using PHP my admin. Have you tried Heidi SQL (http://www.heidisql.com/) yet? It the best GUI app I have found so far. In order to connect to a remote server using Heidi SQL you will need to be able to allow remote SQL access. If you have CPanel there is an option for remote SQL. If you do not know if you can do this ask you host if you can and how. I am also plannign to post a tutorial on how to do this if you host uses cpanel and allows remote SQL. Hope this helps.
on June 24th, 2009 at 5:26 am
We create an array and store it in the variable $array. We then open a database and
attempt to insert an element called “arraytest”, passing it the $array variable as the
value. We then test the return type from dbmfetch() when attempting to access
“arraytest” and ascertain that a string has been returned. In fact, if we printed the
value stored in the “arraytest” record, we would get the string “Array”. That would
seem to wrap up any hopes for storing arrays and objects.
Fortunately, PHP provides a feature that allows you to “freeze-dry” values of any
data type in string format. The data can then be stored in a database or file until it
is needed. You can use this technique to store arrays and even objects in a DBM