Moritz Von Schweinitz wrote:
>
> AFAIK the mysqladmin tool doesn't really do anything else than alter the
> predefined database called mysql that's in charge of all the
> configuraton of the other databases - why not simply alter that DB with
> the DBI? i think the mysql docs describe the db-structure in more
> detail...
>
> just my two cents (ha! finally us europeans can say that, too! :-)
Another two cents worth.
When only root or an admin-user can create databases, then why don't you
have a second connection with the
admin user. The admin user can than say for example:
$dbh->do( qq{ CREATE DATABASE new_db } ).
I think that for almost all tasks that mysqladmin can do, there are
equivalent SQL-commands.
With SQL-commands I mean stuff that do something when you type them into
mysql.
CU, Bernhard
--
*************************************************
Bernhard Schmalhofer
Senior Developer
Biomax Informatics AG
Lochhamer Str. 11
82152 Martinsried, Germany
Tel: +49 89 89 55 74 - 839
Fax: +49 89 89 55 74 - 25
PGP: https://ssl.biomax.de/pgp/
Email: mailto:[EMAIL PROTECTED]
Web: http://www.biomax.de
*************************************************
