Tim Cutts <[EMAIL PROTECTED]> wrote: > > Server version: MySQL 4.0.18, running on Red Hat Linux 8.0 > > Symptoms: All our machines except for one can connect to the database. > That one machine gets 'access denied'. > > All users are affected, even root. > > SHOW GRANTS for an example user: > > Grants for [EMAIL PROTECTED]: GRANT ALL PRIVILEGES ON *.* TO 'ensadmin'@'%' > IDENTIFIED > BY PASSWORD 'xxxxxxxxxxxxx' > > And yet any attempt to connect to that database from one particular > machine results in failure. For example, here are the logs for two > successive connections, one from machine bc-1-1-03 and one from > bc-1-1-02: > > Time Id Command Argument > 040315 10:44:00 1 Connect [EMAIL PROTECTED] on > 1 Query select USER() > 040315 10:44:09 1 Quit > 040315 10:44:21 2 Connect Access denied for user: > '[EMAIL PROTECTED]' (Us > ing password: YES) > > I've tried re-starting the database, to no effect (fortunately this is > just a test instance). > > Am I missing something ridiculously simple, or is this a bug? >
Probably you specified wrong password in the option file on 'bc-1-1-02' box. Check the output of mysql --print-defaults. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]