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 to have access from localhost and remote hosts to this DB.
GRANT creates the user in mysql.user if it does not exist, but REVOKE
like in
REVOKE ALL ON username.* FROM username@"%";
does not deletes it.
Do i have to use DELTE for that ?
Could anyone help out with that ?
regards
Joerg
--
Joerg Hartmann
mediadesign akademie Phone: +49 340 253 20 23
[EMAIL PROTECTED] Fax: +49 340 253 20 10
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
