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 > ============================================ >