PhpMyAdmin database creation and user privileges setup

PhpMyAdmin database creation and user privileges

In this post I’ll briefly explain how to use PhpMyAdmin tool to create a database and assign privileges (rights) to database users. Within other posts I’ve already explained how it is done using other tools:

If you are using one of the above mentioned control panels, they contain an icon for starting PhpMyAdmin. Though you can install it manually within a subdirectory, or as a part of WAMP, or LAMP installation, on your local (home) computer. Separate posts explain this part:

Either way, if you need to use a database (for installing WordPress for example), you will need to create it, and a user, with needed access rights / privileges. The explanation is simple, brief, pictures speak for themselves:

If it is being done on a local computer, open a browser and type this address:
http://localhost/phpmyadmin/

Login to PhpMyAdmin on localhost
Login to PhpMyAdmin on localhost
Picture 1

Now a database should be created:

PhpMyAdmin database creation
Click on “Databases” and enter a database name (1), then click on “Create” (2)
Picture 2

User you logged in with and created the database usually automatically gets all the privileges. If you wish to give the privileges to another user (you had created), this is the procedure:

PhpMyAdmin adding user privileges
Select the database you wish (1)
Click on “Privileges” (2)
Click on “Edit privileges” for the user you wish (3)
Or add another user by clicking on “Add user account” (4)
Picture 3

Now you will get a menu for adding privileges:

Adding desired user privileges in PhpMyAdmin
Check the privileges you wish (1) and click on “Go” (2)
Picture 4

That’s about it, put briefly. I made a long tutorial video on website migration, where I also show working within PhpMyAdmin. I’ll provide a link, that should take you to the video’s time of 7:48 where PhpMyAdmin use is shown briefly. Video: WordPress website migration – manually.

Share...

Leave a Comment

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.