I have 2 unrelated questions:
1) Is there any way to get the hostname that the server is
running on from within mysql?
All I can come up with is (pseudo coded):
mysql system echo insert mysql.hostname `hostname` ... hostname.sql
mysql
the user from being able to access additional
databases matching the wildcard pattern; for example,
GRANT ... ON 'foo\_bar'.* TO
Then you would need
GRANT SELECT ON 'dev\_%'.* TO [EMAIL PROTECTED]
Michael
Brian C. Hill wrote:
I have about 20 DB's with the same prefix
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
Has anyone gotten this to work?
I tried to compile and install the Berkeley DB that comes with
mysql, but it has at least 2 errors, the second of which I cannot get
past.
The first error I got by by creating a symbolic in rpc_server
to ../include/db_server.h.
The