Hi! On Jul 14, Andreas Reuleaux wrote: > What works for me with mysql 3.23.49 of Debian GNU/Linux (Woody), > does not any more with mysql 3.23.56 of fink (current-stable, > for fink cf. fink.sf.net) - I am not sure, if this problem is caused > by the mysql version (some security changes between .49 and .56) > or by the fink configuration - I might ask at the fink-users list > later. > > Works fine in Debian (.49) but not in fink (.56): > > [mac:~] reuleaux% mysql -u abc -pabcpass myFineDb > ERROR 1044: Access denied for user: '[EMAIL PROTECTED]' to database 'myfinedb' > [mac:~] reuleaux%
You could've noticed that it tries to access different database. You granted access to 'myFineDb', but you weren't able to access 'myfinedb'. So, it's case sensitivity issue. On Debian everything is ok, of course, on Mac OS X MySQL converts all table/db names to lowercase, as file names there are case-insensitive. The bug was that table name was not converted to lowercase in the GRANT command (check SHOW GRANTS, for example). Please, upgrade to the recent stable version - 4.0.x - it does not have this bug. Regards, Sergei -- __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Sergei Golubchik <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Senior Software Developer /_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]