[prev in list] [next in list] [prev in thread] [next in thread] 

List:       mysql
Subject:    Re: 1045 Error accessing mysql db
From:       "wagnerbianchi.com" <me () wagnerbianchi ! com>
Date:       2014-09-05 12:34:29
Message-ID: CADtYh6H5rTDq=J_LZqRiNbuNdaau1D838vN8HN8SGoxt_k=+xg () mail ! gmail ! com
[Download RAW message or body]


FYI

WB

2014-09-04 21:27 GMT-03:00 ì •ì²œê¸° <jeongcheonki@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 <me@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:  me@wagnerbianchi.com
>> Twitter: @wagnerbianchijr
>>
>>
>> 2014-09-04 11:05 GMT-03:00 Divesh Kamra <kamra.divesh@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 <augori@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 : jeongcheonki@gmail.com
>  MSN : jeongcheonki@hotmail.com
> ============================================
>


[prev in list] [next in list] [prev in thread] [next in thread]