[plug] MySQL setup DEBIAN

[Craig Ringer]

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:

# mysqladmin password <new-password>

(and REMEMBER that password).

> mysqladmin -u root password <password>

Try it without a password, eg

# mysqladmin -u mysql

and it'll probably work. If there's no password set, I'm pretty sure
mysql rejects connections that try to use a password.

Just to clear up any misunderstandings, the UNIX users are /entirely/
separate to the mysql users. MySql users are stored in the 'user' table
of the 'mysql' database in MySQL.

Personally, I very strongly prefer the PostgreSQL auth model, where by
default "local UNIX user via UNIX socket" == "local database user".

Craig Ringer