* 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. -- Roger -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]