MySQL Forums
Forum List  »  MySQL Administrator

Re: I can create user privilege via domain name instead of ip address?
Posted by: Arpan Jindal
Date: September 14, 2011 08:48AM

Yes you can do that

u can create a user with domain name as well as ip address.

Also one can have both the entries at same time.

like

GRANT USAGE ON * . * TO 'user1'@'db.host.com' IDENTIFIED BY '***' .....

and

GRANT USAGE ON * . * TO 'user1'@'211.133.145.123' IDENTIFIED BY '***' ...

both can be provided at same time

Options: ReplyQuote


Subject
Written By
Posted
Re: I can create user privilege via domain name instead of ip address?
September 14, 2011 08:48AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.