Take the 2-minute tour ×
Webmasters Stack Exchange is a question and answer site for pro webmasters. It's 100% free, no registration required.

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

2 Answers 2

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

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.