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:
Now a database should be created:
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:
Now you will get a menu for adding privileges:
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.