Re: mysql Access denied error

Edward , use following way mysql -uroot -p -h{host ip } else give grant privileges to localhost On Mon, May 5, 2014 at 7:47 AM, 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 > fa

Re: mysql Access denied error

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 data

Re: mysql Access denied error

Am 05.05.2014 15:26, schrieb Johan De Meersman: > - Original Message - >> From: "Reindl Harald" >> >> 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 in

Re: mysql Access denied error

- Original Message - > From: "Reindl Harald" > > 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 second scenario, I

Re: mysql Access denied error

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 >> >: >>> >>> Am 05.05.2014 08:34, schrieb Manuel Arostegui: >>> >

Re: mysql Access denied error

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

Re: mysql Access denied error

2014-05-05 10:57 GMT+02:00 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>>: > > > > Am 05.05.2014 08:34, schrieb Manuel Arostegui: > > > "%" doesn't match localhost so if you don't specify it you wi

Re: mysql Access denied error

Am 05.05.2014 10:19, schrieb Manuel Arostegui: > 2014-05-05 10:00 GMT+02:00 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 So

Re: mysql Access denied error

2014-05-05 10:00 GMT+02:00 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 "@

Re: mysql Access denied error

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 hos

Re: mysql Access denied error

2014-05-05 4:17 GMT+02:00 EdwardKing : > 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: > > [hadoop@maste

mysql Access denied error

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: [hadoop@master ~]$ mysql -h localhost -u root -p Enter password