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 localhost .
JH> But i can not get it to work that way :(
JH> My users have to have access from localhost and remote hosts to this DB.
'%' means that you can connect via TCP/IP;
'localhost' means connection via Unix socket.
You should add into 'user' table:
GRANT ALL ON username.* TO 'username'@'localhost' IDENTIFIED
BY 'password';
JH> GRANT creates the user in mysql.user if it does not exist, but REVOKE
JH> like in
JH> REVOKE ALL ON username.* FROM username@"%";
JH> does not deletes it.
It deletes it from the 'db' table, not from the 'user' table.
JH> Do i have to use DELTE for that ?
You may use DELETE if it is necessary.
JH> regards
JH> Joerg
--
For technical support contracts, goto https://order.mysql.com/
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Victoria Reznichenko
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net
<___/ www.mysql.com
---------------------------------------------------------------------
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
