MySQL Forums
Forum List  »  MySQL Administrator

Advanced Search
New Topic

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

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Written By
Posted
I can create user privilege via domain name instead of ip address?
fei lee
June 30, 2011 07:26PM
Re: I can create user privilege via domain name instead of ip address?
Wullie Eichimck
July 04, 2011 11:42PM
Re: I can create user privilege via domain name instead of ip address?
fei lee
July 20, 2011 12:33AM
Re: I can create user privilege via domain name instead of ip address?
Arpan Jindal
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.