[plug] MySQL setup DEBIAN
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".
More information about the plug