Hello Everyone !

I am really excited ! Its been 18 days since the blog started and the response is amazing. I really hope these tutorials are helpful. Anyways I have seen a lot of people having problem setting up phpmyadmin and Lot more have no idea how to use it. So this tutorial is dedicated to you folks. I`ll teach you the basics of how to play with phpMyAdmin. Frankly I have not seen much tutorials on how to use phpmyadmin, and I don`t know how well you guys will like it.
Anyways

phpMyAdmin 2.11.x Front Page

The Front page shows you something similar to the above image. As you can see, On the left we have the existing databases. If there are none available its fine, and on the right we have the page which has a lot of text in it . You can see that I have marked the area from where you can create your database.
For more information about your mysql server, its configurations etc you can check the many links on this page. Exploring more links is the key to master it

Lets create a database called ‘test’

Now lets create a database called test. Put the name test in the Create New database box and click on create.

You`ll see something similar to the above when you create your first database. Cool ! Now you might notice that I have boxed an area in the above image.

• Structure – Shows you the structure of the database (Schema)
• SQL – You can use the query language to modify your database
• Search – Search for a particular item
• Query – Right now don`t worry about this much.
• Export/Import – You can export your database in SQL or import an equivalent
• Operations – Operations you can perform on your database
• Privileges – Shows you the user who can use this database and his privileges.
• Drop – Delete the database

Phew that was quite a bunch ! Lets move on. Now we have created our database test. Lets create tables in it. Click on SQL from the area I had marked in the image, and goto the next step.

Create table ‘user’

You will see a page similar to the above image. Write a SQL query to create a table.

CREATE TABLE user (
id INT AUTO_INCREMENT NOT NULL,
user VARCHAR(50),
pass VARCHAR(50),
PRIMARY KEY(id) )

If the code was executed successfully you`ll see something similar to the above image. I think the image is self explainatory. On the left the table you just created under database test. Click on ‘test’. you will be taken to the ‘Table Info Page’.

phpMyAdmin Database Info page

This page is where all your tables of a particular database are shown. As shown in the above figure, in the database test, we currently have only 1 table i.e user.

phpMyAdmin Table Info page

Ok ! So you clicked on test and something similar to the above image will be displayed. This page shows you the structure of your table. As you can see, the table we had created has 3 attributes

• id -int (Primary key)
• user -VARCHAR of size 50
• pass – VARCHAR of size 50

You can see in the above image, I have marked an area “edit the attributes”. Those little icons help to modify your attributes. From the Left -

• Browse – Browse values of a particular attribute
• edit – Edit structure of attribute, (example: change particular attribute’s datatype from VARCHAR to text)
• delete – delete particular attribute
• Primary, Unique, Index. (It is pretty self explainatory, if you know anything about DBMS)

Insert values inside table

Ok, Now you know how to create a database, create table inside a database. Lets learn how to insert values inside our table. First goto the ‘user’ ‘table info page’. then Click on Insert in the top.

You`ll see a page similar to the above image. As you can see, its pretty neatly laid out, I hope its not that tough for you to decide where to type your data *There is no need to type anything in id, since if you notice this line
id INT AUTO_INCREMENT NOT NULL which we had typed earlier to create a table ,you`ll see that id is a primary key & it auto increments as you go on inserting records.*

The above image will be displayed once you have inserted your values successfully. Now since you have inserted values, you can double check or see what all values your table contains by clicking on the Browse link on the top. It`ll browse the table for all the records. The following image is what it`ll look like.

phpMyAdmin Table browse page

You can see all the values for every record. You can edit, delete the records as well. The small Icons are very obvious and not hard to miss. PhpMyAdmin also gives the ability to see results for particular queries. Suppose you want to execute a query on a particular table then click on SQL on the top of the ‘Table Info/Browse Page’

Execute SQL queries on your table

The above page is how it`ll look like, you can type in any query to check.

Well, that was very basics of phpMyAdmin. If you guys want any help regarding other functions of phpmyadmin feel free to ask.

If the response for this tutorial is well, then I`ll move to the advanced phpmyadmin stuffz . Enjoy Guys