MySQL Root Account

[A. Khattri]

On Tue, 8 Feb 2005, Roger Oberholtzer wrote:

> And which user/password is needed each time a new database is added?

Assuming you created a separate "MySQL superuser" account, you can use
that account to create databases and "normal" users.

> Say
> I add an app that wants a database installed. Apps seldom do this direct
> as they need a user/password to add the database.

Normally I would set this up in advance using my "MySQL superuser"
account, and then create a new login + passwd for this new application.

> I think MySQL is polluted with admin passwords beyond those needed by
> each individual application. If my whole computer can get by with one
> clear top level (root) password, why does MySQL insist on letting there
> be multiple 'root's?

Actually, the permissions in MySQL are more fine-grained than for Unix so
there's a big difference. Users can be limited in what database they can
use, and/or what host they can connect from, and/or what type of MySQL
query they can run, whether they can grant privileges to others, etc.

On my servers there's only ONE "MySQL superuser" account (usually me) but
if you had a team of administrators (or maybe just a junior admin even)
you could create a separate privileged login for them.


-- 
let the smoke out v.

 To fry hardware (see fried).  See
   magic smoke for a discussion of the underlying mythology.