MySQL User / Host Table Questions
Posted on 2006-10-23
1.) Should I have to restart MySQL every time I change the “user” table? (Windows 2003, MySQL 5.0) It seems I have to for the changes to take effect.
2.) What about using a subnet or wildcard in the host column? I’ve been unsuccessful with using 192.168.1.*
3.) How do I grant a user access from multiple hosts? Do I put all hosts into the Host field, like “localhost,192.168.1.100”? Do I have to create a new user row for every user / host combination I want to allow? This seems counter productive to me because now I have multiple users with the same names, and potentially different passwords.
Thanks for the help and pointers here.