>Description:
"mysqladmin -f -u bugs drop gdr_bugs" fails with
"error: 'Access denied for user: '@localhost' to database 'gdr_bugs''
even though user "bugs" has access. Omitting the "-f" option makes it
work. Somehow, the "-f" option is making mysqladmin forget the user.
This occurs on Mac OS X 10.2.1, but not on FreeBSD 4.7 with 3.23.52.
>How-To-Repeat:
Grant user "bugs" access to "gdr_bugs.*", then
mysqladmin -f -u bugs drop gdr_bugs
>Fix:
>Submitter-Id: [EMAIL PROTECTED]
>Originator: [EMAIL PROTECTED]
>Organization:
Ravenbrook Limited
>MySQL support: none
>Synopsis: "mysqladmin -f" forgets "-u user" on Mac OS X 10.2
>Severity: serious
>Priority: medium
>Category: mysql
>Class: sw-bug
>Release: mysql-3.23.53 (Official MySQL binary)
>Server: /usr/local/bin/mysqladmin Ver 8.23 Distrib 3.23.53, for apple-darwin6.1 on
>powerpc
Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL license
Server version 3.23.53
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /tmp/mysql.sock
Uptime: 1 hour 16 min 56 sec
Threads: 2 Questions: 135 Slow queries: 0 Opens: 9 Flush tables: 1 Open tables: 4
Queries per second avg: 0.029
>Environment:
I can send full "Apple System Profiler" output if desired -- please ask.
System: Darwin skylark.ravenbrook.com 6.1 Darwin Kernel Version 6.1: Fri Sep 6
23:24:34 PDT 2002; root:xnu/xnu-344.2.obj~2/RELEASE_PPC Power Macintosh powerpc
Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gcc /usr/bin/cc
GCC: Reading specs from /usr/libexec/gcc/darwin/ppc/3.1/specs
Thread model: posix
Apple Computer, Inc. GCC version 1151, based on gcc version 3.1 20020420 (prerelease)
Compilation info: CC='gcc' CFLAGS='-O3 -fno-omit-frame-pointer' CXX='gcc'
CXXFLAGS='-O3 -fno-omit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti'
LDFLAGS=''
LIBC:
lrwxr-xr-x 1 root wheel 15 Sep 23 13:15 /usr/lib/libc.dylib -> libSystem.dylib
Configure command: ./configure --prefix=/usr/local/mysql '--with-comment=Official
MySQL binary' --with-extra-charsets=complex --with-server-suffix=
--enable-thread-safe-client --enable-local-infile --disable-shared --without-innodb
CC=gcc 'CFLAGS=-O3 -fno-omit-frame-pointer' 'CXXFLAGS=-O3 -fno-omit-frame-pointer
-felide-constructors -fno-exceptions -fno-rtti' CXX=gcc
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php