Re: Problems with GRANT and REVOKE

2002-02-28 Thread Victoria Reznichenko
Joerg, Thursday, February 28, 2002, 2:28:27 PM, you wrote: JH> Hello Victoria Reznichenko, JH> thanks for your answer, but i think this is not absolutly true [skip] JH> But now there is the next question : JH> This entry ""@localhost was made my mysql_install_db . JH> Do i need it ? What was is

Re: Problems with GRANT and REVOKE

2002-02-28 Thread Victoria Reznichenko
John, Thursday, February 28, 2002, 1:56:29 PM, you wrote: >>JH> i like to have a DB per user so i do >> >>JH> GRANT ALL ON username.* TO username@"%" IDENTIFIED BY 'password'; >> >>JH> This is fine, until the user tries to connect from localhost :( >>JH> As i read the manual i think the %-wildcar

Re: Problems with GRANT and REVOKE

2002-02-28 Thread Joerg Hartmann
On Thursday, 28. February 2002 12:02, you wrote: Hello Victoria Reznichenko, thanks for your answer, but i think this is not absolutly true > JH> As i read the manual i think the %-wildcard includes localhost . > JH> But i can not get it to work that way :( > JH> My users have to have access fr

Re: Problems with GRANT and REVOKE

2002-02-28 Thread John Dean
And if we where talking about MySQL on Windows At 13:02 28/02/2002 +0200, Victoria Reznichenko wrote: >Joerg, >Thursday, February 28, 2002, 12:03:18 PM, you wrote: > >JH> i like to have a DB per user so i do > >JH> GRANT ALL ON username.* TO username@"%" IDENTIFIED BY 'password'; > >JH> This is f

Problems with GRANT and REVOKE

2002-02-28 Thread Victoria Reznichenko
Joerg, Thursday, February 28, 2002, 12:03:18 PM, you wrote: JH> i like to have a DB per user so i do JH> GRANT ALL ON username.* TO username@"%" IDENTIFIED BY 'password'; JH> This is fine, until the user tries to connect from localhost :( JH> As i read the manual i think the %-wildcard includes

Problems with GRANT and REVOKE

2002-02-28 Thread Joerg Hartmann
Hi all, i like to have a DB per user so i do GRANT ALL ON username.* TO username@"%" IDENTIFIED BY 'password'; This is fine, until the user tries to connect from localhost :( As i read the manual i think the %-wildcard includes localhost . But i can not get it to work that way :( My users have