Getting started with phpmyadmin – How to create a database and grant privileges for database user.

  1. Navigate to phpMyAdmin by URL http://your_ip/phpmyadmin or http://localhost/phpmyadmin
  2. Login using username root and root password. login
  3. Click on Databases tab.database tab
  4. Enter database name, select collation (you may leave it to default) and click create.mydb creation
  5. Click on Privileges tab and select "Add user account".users add user
  6. You can select localhost if the connection is made only form local. Select "any host" if you are planing to connect from different hosts.
  7. Enter new username and password. enter image description here
  8. Select the privileges you need for that user.
  9. Click on Database tab and select the database for which you need to give access(in our case the newly created database in step 4). Click Go.

if you want to reproduce, please indicate the source:
Getting started with phpmyadmin – How to create a database and grant privileges for database user. - CodeDay