Am Donnerstag, den 04.05.2006, 01:14 +0200 schrieb Daniel Leidert: > Am Donnerstag, den 04.05.2006, 00:55 +0200 schrieb Christian Hammers: > > tags 365433 - unreproducible moreinfo > > thanks > > > > On 2006-05-04 Daniel Leidert wrote: > > > # cat /usr/share/mysql/mysql_fix_privilege_tables.sql | /usr/bin/mysql > > > --verbose --no-defaults --force --user=root --host=localhost > > > --database=mysql /usr/bin/mysql: unknown option '--no-defaults' > > > > Ah, yes, --no-defaults must be the very first parameter so putting > > the --verbose after it fixes the problem! > > It fixes the "unknown option" issue. But using the --no-defaults option > still results in the issue I described, that every start & restart of > mysqld produces this error. Without the --no-defaults option, everything > works and I guess, the password for root is read from ~root/.my.cnf. So > can I "deactivate" the usage of the --no-defaults option? Or did I miss > something (I read /usr/share/doc/mysql-server-5.0 without getting an > answer to this question).
Hmm. It seems, that debian-start runs mysql_upgrade with '--defaults-file=/etc/mysql/debian.cnf' and sets 'user' automatically to 'root'. But debian.cnf is created by debconf and the user configured there may be not 'root' (e.g. for me, the user-name is completely different). Regards, Daniel -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]