[EMAIL PROTECTED] (Bernhard Schmalhofer) writes:
> 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.
Well, with Oracle SQL*Plus, there are many commands that you can do at
the sqlplus prompt that don't work through their API. I assumed the
same was true with MySQL.
I think that MySQL may have added the CREATE DATABASE command after I
already learned it (and wrote the earlier versions of the install
scripts I was referring to). If so, nevermind.
--Bill.
--
William R Ward [EMAIL PROTECTED] http://www.wards.net/~bill/
-----------------------------------------------------------------------------
If you're not part of the solution, you're part of the precipitate.
