MySQL Forums
Forum List  »  Security

Re: allowing ip address
Posted by: Javier Rodriguez Paiva
Date: June 17, 2005 09:15AM

Hi Javier, if I'm understanding well your question, I think what you need to do is to set up an account like this:

GRANT ALL ON your_database.* TO 'usuario'@'xxx.xxx.xxx.xxx' IDENTIFIED BY 'clave';

That is assuming you want to grant all privileges (this may not be the case, but you get the idea) on database your_database to a user named usuario connecting from xxx.xxx.xxx.xxx using 'clave' as password.

Hope this helps.

Options: ReplyQuote


Subject
Views
Written By
Posted
8243
June 14, 2005 10:06AM
Re: allowing ip address
4223
June 17, 2005 09:15AM


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.