START here

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.

2 thoughts on “PhpMyAdmin database creation and user privileges”

  1. LAMP installed OK but phpmyadmin does not load the log in screen as depicted above, just get a mass of text like this “addJSON( ‘list’, RecentFavoriteTable::getInstance(‘recent’)->getHtmlList() ); exit; } if ($GLOBALS[‘PMA_Config’]->isGitRevision()) { if (isset($_REQUEST[‘git_revision’]) && $GLOBALS[‘is_ajax_request’] == true) { PMA_printGitRevision(); exit; } echo ‘
    ‘; } // Handles some variables that may have been sent by the calling script $GLOBALS[‘db’] = ”; $GLOBALS[‘table’] = ”; $show_query = ‘1’; // Any message to display? if (! empty($message)) { echo PMA\libraries\Util::getMessage($message); unset($message); } $common_url_query = PMA_URL_getCommon(); ”
    Any help much appreciated

Comments are closed.


Please use the BikeGremlin.net forum for any comments or questions.

If you've found any errors or lacking information in the article(s) - please let me know by commenting on the BikeGremlin forum.
You can comment anonymously (by registering with any name/nickname), but I think it is good to publicly document all the article additions (and especially corrections) - even if their author chooses to remain anonymous.

Skip to content