4

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?

Improve this question

2 Answers 2

Reset to default
5

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.

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

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

Improve this answer
2
  • What if I want to add a range of hosts? like 192.168.0.100 - 192.168.0.200?
    – Max Kielland
    Aug 30, 2015 at 13:20
  • 1
    @MaxKielland you can also use _ as a wildcard like 192.168.0.1__ 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, 2016 at 13:54

Your Answer

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

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