Re: 1045 Error accessing mysql db

[wagnerbianchi.com]

FYI

WB

2014-09-04 21:27 GMT-03:00 정천기 jeongcheo...@gmail.com:

 Hi~~
 I think this trouble because change OS and MySQL grant Initialization..

 Could you please follow my step...

 First.. check your (foo) grant

 root#] mysql -u root -p
 mysql  select * from mysql.user where 'foo';

 there is HOST column.
 HOST column values is '%'..  Must..

 if there is not, you must grant to 'foo'.

 mysql  grant all privileges on *.* to foo@% identified by '';
 mysql  flush privileges;

 Try Login~~

 Second.. Recreate user..

 root#] mysql -u root -p
 mysql  drop user foo;
 mysql  create user 'foo'@'%' IDENTIFIED by '';
 mysql  grant all privileges on *.* to foo@% identified by '';
 mysql  flush privileges;


 Try again Login~~

 My List is Here..

 Have a good day





 2014-09-05 0:54 GMT+09:00 wagnerbianchi.com m...@wagnerbianchi.com:

 Do you know if the Python version has changed? Do you know what was the
 Python version you used to develop your script on CentOS 5? So, If
 anything
 has changed in mysql.user table or even in `foo` user credentials, it
 seems
 that your script must be reviewed and even the Python version in use
 currently must be checked as well...could you let us now if you can log to
 MySQL using the mysql client?

 Something like:

 $ mysql -u foo -p

 Let us know, cheers!!



 --
 *Wagner Bianchi, MySQL Database Specialist*
 Mobile:  +55.31.8654.9510
 E-mail:  m...@wagnerbianchi.com
 Twitter: @wagnerbianchijr


 2014-09-04 11:05 GMT-03:00 Divesh Kamra kamra.div...@gmail.com:

  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!
  
 




 --
 
 정천기  차장, Jeong Cheon Ki , 鄭 天 基
 Home : Seoul
 Mobile : 82(0)10.6261.5356
 E-mail : jeongcheo...@gmail.com
  MSN : jeongcheo...@hotmail.com
 

Re: 1045 Error accessing mysql db

[Divesh Kamra]

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!

Re: 1045 Error accessing mysql db

[wagnerbianchi.com]

Do you know if the Python version has changed? Do you know what was the
Python version you used to develop your script on CentOS 5? So, If anything
has changed in mysql.user table or even in `foo` user credentials, it seems
that your script must be reviewed and even the Python version in use
currently must be checked as well...could you let us now if you can log to
MySQL using the mysql client?

Something like:

$ mysql -u foo -p

Let us know, cheers!!



--
*Wagner Bianchi, MySQL Database Specialist*
Mobile:  +55.31.8654.9510
E-mail:  m...@wagnerbianchi.com
Twitter: @wagnerbianchijr


2014-09-04 11:05 GMT-03:00 Divesh Kamra kamra.div...@gmail.com:

 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!