I occered this trouble when used mysql-connector of python. but I could solve it. so I inturoduce how to solve the trouble shoot. ProgrammingError: **** (*****): Access denied for user ...

mysql> GRANT ALL PRIVILEGES ON *.* TO root@localhost IDENTIFIED BY ' your current password ' WITH GRANT Insert the host and password This section will allow to insert the host's name and user account ...

Have you recently upgraded MySQL from a 4.0x version ? Then you should try setting your password again using the function OLD_PASSWORD ().<BR><BR>This also might be a result of an incorrect hosts file ...