Re: mysql Access denied error

2014-05-05 Thread Manuel Arostegui
2014-05-05 4:17 GMT+02:00 EdwardKing zhan...@neusoft.com: I use mysql to create a database and grant rights to a user hadooptest,then I use hadooptest to login mysql and use the database,but it failed. Why raise error after I grant rights? How to solve it? Thanks. My operation is follows:

Re: mysql Access denied error

2014-05-05 Thread Reindl Harald
Am 05.05.2014 08:34, schrieb Manuel Arostegui: % doesn't match localhost so if you don't specify it you will be attempting to connect via Unix Socket. If you don't want to specify -hlocalhost all the time, just do the grant with @localhost instead of @% nonsense % matches *any host*

Re: mysql Access denied error

2014-05-05 Thread Manuel Arostegui
2014-05-05 10:00 GMT+02:00 Reindl Harald h.rei...@thelounge.net: Am 05.05.2014 08:34, schrieb Manuel Arostegui: % doesn't match localhost so if you don't specify it you will be attempting to connect via Unix Socket. If you don't want to specify -hlocalhost all the time, just do the grant

Re: mysql Access denied error

2014-05-05 Thread Reindl Harald
Am 05.05.2014 10:19, schrieb Manuel Arostegui: 2014-05-05 10:00 GMT+02:00 Reindl Harald h.rei...@thelounge.net mailto:h.rei...@thelounge.net: Am 05.05.2014 08:34, schrieb Manuel Arostegui: % doesn't match localhost so if you don't specify it you will be attempting to

Re: mysql Access denied error

2014-05-05 Thread Manuel Arostegui
2014-05-05 10:57 GMT+02:00 Reindl Harald h.rei...@thelounge.net: Am 05.05.2014 10:19, schrieb Manuel Arostegui: 2014-05-05 10:00 GMT+02:00 Reindl Harald h.rei...@thelounge.netmailto: h.rei...@thelounge.net: Am 05.05.2014 08:34, schrieb Manuel Arostegui: % doesn't match

Re: mysql Access denied error

2014-05-05 Thread Jigal van Hemert
Hi, On 5-5-2014 10:57, Reindl Harald wrote: Am 05.05.2014 10:19, schrieb Manuel Arostegui: 2014-05-05 10:00 GMT+02:00 Reindl Harald h.rei...@thelounge.net mailto:h.rei...@thelounge.net: Am 05.05.2014 08:34, schrieb Manuel Arostegui: % doesn't match localhost so if you don't

Re: mysql Access denied error

2014-05-05 Thread Reindl Harald
Am 05.05.2014 11:12, schrieb Jigal van Hemert: On 5-5-2014 10:57, Reindl Harald wrote: Am 05.05.2014 10:19, schrieb Manuel Arostegui: 2014-05-05 10:00 GMT+02:00 Reindl Harald h.rei...@thelounge.net mailto:h.rei...@thelounge.net: Am 05.05.2014 08:34, schrieb Manuel Arostegui:

Re: mysql Access denied error

2014-05-05 Thread Johan De Meersman
- Original Message - From: Reindl Harald h.rei...@thelounge.net i know that, but it does not change the fact that here Either you didn't know that but have trouble admitting it; or you did but conciously chose to be rude and condescending instead of helpful. Your choice. In the

Re: mysql Access denied error

2014-05-05 Thread Reindl Harald
Am 05.05.2014 15:26, schrieb Johan De Meersman: - Original Message - From: Reindl Harald h.rei...@thelounge.net i know that, but it does not change the fact that here Either you didn't know that but have trouble admitting it; or you did but conciously chose to be rude and

Re: mysql Access denied error

2014-05-05 Thread Peter Brawley
On 2014-05-04 9:17 PM, EdwardKing wrote: I use mysql to create a database and grant rights to a user hadooptest,then I use hadooptest to login mysql and use the database,but it failed. Why raise error after I grant rights? How to solve it? Thanks. The command sequence ... mysql create