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> s
t;
> If dev_ is your prefix, the next line from the manual is relevant:
>
> This means, for example, that if you want to use a '_' character as
> part of a database name, you should specify it as '\_' in the GRANT
> statement, to prevent the user from being able t
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 s
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
