>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