MySQL Forums
Forum List  »  Newbie

Advanced Search
New Topic

Re: help wih mysql grant % "host "syntax
Posted by: Ramalingam Chelliah
Date: August 10, 2004 11:15PM

Hi,
Include wildcard in double quotes... "%"

If you want to allow 'userx' from any host

mysql> GRANT ALL ON *.* TO userx@"%" [ IDENTIFIED BY 'password' ]
[WITH GRANT OPTION] ;
Note :
within [ ] - optional argument

Regards,
Ram.

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


Subject
Written By
Posted
help wih mysql grant % "host "syntax
Mitch Taylor
August 10, 2004 05:32PM
Re: help wih mysql grant % "host "syntax
Ramalingam Chelliah
August 10, 2004 11:15PM


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.