[plug] MySQL setup DEBIAN

Craig Ringer craig at postnewspapers.com.au
Fri Apr 2 20:37:00 WST 2004

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

More information about the plug mailing list