Re: Granting privileges

[Todd Cary]

Roger - Thank you for taking the time to clarify that for me.  I was using "PHP with MySQL" and they are not clear on the differences I found and you explained. Thanks again.... Todd Roger Baklund wrote: * Todd Cary I did some experimenting and here is what I found: [...] The "%" in the Host column does not appear to work for me, and there is something different about "*" and "*.*". The manual is a usefull source of information... ;) <URL: http://www.mysql.com/doc/en/Adding_users.html > <URL: http://www.mysql.com/doc/en/Privileges.html > <URL: http://www.mysql.com/doc/en/GRANT.html > The difference between using * and *.* in a GRANT statement, is that * means "all tables in the current database", while *.* means "all tables in all databases". This is usefull when you set table/column specific privileges. Using special characters like "%" in user/host names requires a special quoting, like the examples in the manual shows: mysql> GRANT ALL PRIVILEGES ON *.* TO monty@'%' -> IDENTIFIED BY 'some_pass' WITH GRANT OPTION; Yes, this could have been more clear in the documentation, but it _is_ mentioned under a "Please note" section on the GRANT page. --

<<inline: NewLogo.gif>>