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?


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
    Jun 10 '12 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 - Aug 30 '15 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
    Jun 7 '16 at 13:54

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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