How to create database and username using PhpMyAdmin ?

PhpMyAdmin is a GUI for people who are not aware of command line interface to manage MySQL. Here I’m going to explain how to create Database and its Username using PhpMyAdmin.

Procedure:

  1. Go to PhpMyAdmin
  2. Click on Privileges

privileges phpmyadmin

  1. Then click on “Add a new User”

phpmyadmin add new user

  1. Enter Username and Password you want

enter information for new database username password

  1. Select “Local” in Host
  2. Scroll down, under “Database for user” area, click on “Create database with same name and grant all privileges”
  3. Click “Check All” under “Global privileges”

create database in phpmyadmin

  1. And at the end click on “Create User”

create user phpmyadmin

 

And you have Database of same name as username ready to use for your application.

Please follow and like us:
About shk

shk is a DevOps engineer with more than 12 years of experience in different organizations. He enthusiastic about learning new technologies and shares his knowledge through his blogs.

Comment Policy:

Your words are your own, so be nice and helpful if you can. Please, only use your real name, not your business name or keywords. Using business name or keywords instead of your real name will lead to the comment being deleted. Anonymous commenting is not allowed either. Limit the amount of links submitted in your comment. We accept clean XHTML in comments, but don't overdo it please.

Tell us what you're thinking...

All comments are moderated.

* Denotes required field.

*

*

Previous Post:
Next Post: