Webmasters Stack Exchange is a question and answer site for pro webmasters. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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?

share|improve this question
up vote 4 down vote accepted

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.

share|improve this answer
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.

share|improve this answer
What if I want to add a range of hosts? like - – Max Kielland Aug 30 '15 at 13:20
@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 at 13:54

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

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