* 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]

Reply via email to