Am Donnerstag, den 04.05.2006, 01:39 +0200 schrieb Christian Hammers:
> On 2006-05-04 Daniel Leidert wrote:
> > Am Donnerstag, den 04.05.2006, 01:22 +0200 schrieb Christian Hammers:
[..]
> > > The line in mysql_fix_privilege_tables is, as far as I figured out until
> > > now: cmd="$bindir/mysql --no-defaults --force --user=$user --host=$host"
> > > so user and password should be debian-sys-maint
> >
> > No. This seems to be the problem: For me --user=root
> >
> > You can see it in my boot.log I sent you at the beginning:
> >
> > Got a failure from command:
> > cat /usr/share/mysql/mysql_fix_privilege_tables.sql | /usr/bin/mysql
> > --no-defaults --force --user=root --host=localhost --database=mysql
> > ^^^^^^^^^^^
>
> Ok, so where does it come from?
>
> * What does your /etc/mysql/debian.cnf contain?
> (you can XXXX the password, of course)
Attached. Seems to be ok for me.
> * What gives
> "my_print_defaults --defaults-file=/etc/mysql/debian.cnf mysqld
> mysql_upgrade"
I ran it as root, but it doesn't output anything. The last lines of a
strace show:
stat64("/etc/mysql/debian.cnf", {st_mode=S_IFREG|0600, st_size=146, ...}) = 0
open("/etc/mysql/debian.cnf", O_RDONLY|O_LARGEFILE) = 3
fstat64(3, {st_mode=S_IFREG|0600, st_size=146, ...}) = 0
mmap2(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) =
0xb7f50000
read(3, "# Automatically generated for De"..., 4096) = 146
read(3, "", 4096) = 0
close(3) = 0
munmap(0xb7f50000, 4096) = 0
exit_group(0) = ?
Regards, Daniel
# Automatically generated for Debian scripts. DO NOT TOUCH!
[client]
host = localhost
user = debian-sys-maint
password = xxxx
