grants to multiple DBs at once

[Brian C. Hill]

        I have about 20 DB's with the same prefix.

        How can I do something like

        GRANT SELECT ON dev_*.* ....

        I have seen examples for the _other_ DB software, like msql,
that does something like:

        SELECT 'GRANT SELECT ON '+name+' TO webuser;'
                from sysobjects
                where type = 'U'

        (which generates the grant statements to run)

        Is this possible in mysql? Maybe something like:

        SELECT 'GRANT SELECT ON '+name+' TO webuser;'
                from `show databases like 'dev_%'`

        I know that sub-queries aren't possible, but does anyone have
any suggestions that don't involve weighty shell scripts?

        Is there anyway to write show databases to file
without the bordering box?

Brian

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]