check weather there any space in localhost 'localhost ' Also check permission for 'foo' user though command
select * from mysql.user where 'foo'; On Thu, Aug 21, 2014 at 6:53 AM, Augori <aug...@gmail.com> wrote: > After an operating system change (CentOS 5 to CentOS 6), my Python script > could no longer connect with mysql database. I get the following error... > > mysql_exceptions.OperationalError: (1045, "Access denied for user 'foo'@ > 'localhost > ' (using password: YES)") > > I have granted all on all databases to this user. > I attempted to run mysql_upgrade. > > I am stymied because according to another guy, he is successfully accessing > the same database with the same credentials as I am (but in a PHP script). > > Can any of you suggest an explanation for this? > > Thanks in advance! >