How to Create and Manage MySQL Databases

Posted at March 5, 2016 at 9:30 pm by Manoj Kumar

Create Database

Just name the database you wish to create and click on the Create button to the create the database.This is how it will look when your database is created.

CreatedDatabase

Create and Add Database User

Now create a user for the database. Name user and set password for Database soft_Smith and click on Create button to create user.

Databaseuser

After creating the database user Add your user to the database.

DB5

Here is a Video

Set Privileges for the Database and Host

  • After adding user you will be directed to the page where you can set Privileges for the Database.This page helps you in setting the permission for your database.i.e you can Create temporary tables,Execute,Drop,Lock tables in your Database.

You can also set the Host for the Database User for that Particular Database

Privilges

Delete Database

You can delete your database anytime. Just click on the icon show to you in the below image and delete your database.

DB1

Delete Database User

You can delete your database user just like you deleted your database.To delete your database user just click on icon shown to you in the below image.

NewD

Here is a Video

5.00 avg. rating (88% score) - 1 vote

You can skip to the end and leave a response. Pinging is currently not allowed.

Leave a Reply