[plug] MySQL setup DEBIAN

[Mark O'Shea]

On Fri, 2 Apr 2004, Craig Ringer wrote:

> On Fri, 2004-04-02 at 19:58, smclevie wrote:
>
> > OK so where is it?  This 'root with no password' thingo ...
>
> "root" == user "mysql" in the MySQL auth tables, which is "root" for the
> database's purposes. Fix it with:
>
Nope, the root mysql user is called "root", which should still not be
confused with the root linux user.  the mysql user is just another user.

See this url for how to reset the root password:
http://www.mysql.com/doc/en/Resetting_permissions.html


>
> Personally, I very strongly prefer the PostgreSQL auth model, where by
> default "local UNIX user via UNIX socket" == "local database user".
>
Well, I don't feel strongly either way but the postgresql way does seem
more sensible on a standalone system of small network.  But the database
having complete control over it's users also has it's place.  I dunno,
anyone else have stong views about this?

-- 
Mark O'Shea