Thomas, Wednesday, May 01, 2002, 9:39:24 PM, you wrote: TS> I am having some trubble understanding, how permissions work with MySQL:
TS> I've set up user, database, and host permissions: TS> User: Hosts: PW: Permissions: TS> tps Any pw All TS> Anonymous 192.168.107.204 '' None TS> Database: User: Hosts: Permissions: TS> duwt Anonymous Any All TS> Databases: Hosts: Permissions: TS> Any 192.168.107.0/24 All TS> Now, if I understand correctly I might connect to database "duwt" as user TS> "tps" from any host. But trying this I can't connect to database "duwt". TS> Why? Yes, it should work, I tested. Check if there are any other conflicting entries in privilege tables. Seems, you gave incomplete info. If you set up privileges directly editing privileges tables don't forget to execute FLUSH PRIVILEGES. -- 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
