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:
- Go to PhpMyAdmin
- Click on Privileges
- Then click on “Add a new User”
- Enter Username and Password you want
- Select “Local” in Host
- Scroll down, under “Database for user” area, click on “Create database with same name and grant all privileges”
- Click “Check All” under “Global privileges”
- And at the end click on “Create User”
And you have Database of same name as username ready to use for your application.
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.