enter image description here

As the title reads, I want to add more than one host into the Host field in phpMyAdmin's user privileges, to allow a user to login from a number of different hostnames.

How can I accomplish this?

2 Answers 2


You just add the same user multiple times under different hosts, like so:

Sample PMA users table

You can also just create one wildcard host user.

Another image of creating the user.

  • Thanks, this is what I am currently doing, but I would like to have just the one user entry. :)
    – loklaan
    Commented Jun 10, 2012 at 8:31

Under "Host", try a %. like 192.168.0.% will do the whole network.

  • What if I want to add a range of hosts? like - Commented Aug 30, 2015 at 13:20
  • 1
    @MaxKielland you can also use _ as a wildcard like to match 100 -199 but for 200 you need to create a seperate account or use the % wildcard and include 0-99 and 201-255 too.
    – Daan
    Commented Jun 7, 2016 at 13:54

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.