Create new database in mysql

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