Create new database
in mysql:
After installed “phpmyadmin”
Open link http://localhost/phpmyadmin in any browser
In home page you will get an option i.e, “create new database”
In that text box type your database name and then click on “create”
Here I taken “university” is my database name
now your database created, add privileges to your database.
click on “privileges”
click on “add new user”
type your username and password as I showed in figure
click on “check all” and click on “go”
now you added privileges to your database
create a table in your database
you get option that “create new table on database”
type table name and number of fields
click on “go”
fill the field as I showed in figure and I taken that “student _id” is “primary
key”
and click on “save”
now your table is created in your database
if you want add one more field to same table, you have a option that
below table
I showed in figure
Click on “go” and add field to the same table
Now one more field added to your table
