How to create a new user in PhpMyAdmin

Go to your PhpMyAdmin main page and you should see a list like this:

  • Show MySQL runtime information
  • Show MySQL system variables
  • Processes
  • Character Sets and Collations
  • Storage Engines
  • Reload privileges
  • Privileges
  • Binary log
  • Databases
  • Export
  • Import
  • Log out

Click on Privileges.

After that, just under the list of users (if any) you will find a link that says “Add New User.”

Do that. The only permissions necessary are at the check boxes under data. You don’t need to give the user permissions under Structure or Administration. Also, you don’t need to change the resource limits unless you are hosting websites for many people.