Dear Patrick, I have tried but same error occur
ERROR 1044 (42000): Access denied for user 'root' to schema 'DATA_DICTIONARY' Thanks, -- Umair Muhammad Electrical Engineering Master Student, Specialization in Wireless Systems, School of Electrical Engineering, Royal Institute of Technology (KTH), SE 100-44 Stockholm, SWEDEN. Email: mum...@kth.se Cell: +46 764 097 574 ________________________________________ From: pcrews [glee...@gmail.com] Sent: Tuesday, August 28, 2012 10:19 PM To: Muhammad Umair Cc: drizzle-discuss@lists.launchpad.net Subject: Re: [Drizzle-discuss] Access Denied Interesting. Try ./drizzle -uroot and you should be able to run any queries you need. On 08/28/2012 03:57 PM, Muhammad Umair wrote: > Dear Patrick, > > Thanks for the reply. > > I have started Drizzle server like > > umair@ubuntu:~/trunk_drizzle/drizzle_trunk/bin/sbin$ ./drizzled > > and Drizzle client like > > umair@ubuntu:~/trunk_drizzle/drizzle_trunk/bin/bin$ ./drizzle > > Thanks. > > -- > Umair Muhammad > Electrical Engineering Master Student, > Specialization in Wireless Systems, > School of Electrical Engineering, > Royal Institute of Technology (KTH), > SE 100-44 Stockholm, SWEDEN. > Email: mum...@kth.se > Cell: +46 764 097 574 > ________________________________________ > From: drizzle-discuss-bounces+mumair=kth...@lists.launchpad.net > [drizzle-discuss-bounces+mumair=kth...@lists.launchpad.net] on behalf of > pcrews [glee...@gmail.com] > Sent: Tuesday, August 28, 2012 8:46 PM > To: drizzle-discuss@lists.launchpad.net > Subject: Re: [Drizzle-discuss] Access Denied > > Hi. > > Could you provide the following: > 1) How you started Drizzle (options, etc) + any setup you did for ldap > / auth > 2) How you connected to Drizzle with options, etc > > If you try using the user as 'root', you might find better success in > querying the server, should this be blocking something important. > > Thanks, > Patrick > > On 08/28/2012 02:41 PM, Muhammad Umair wrote: >> Dear Drizzle Team, >> >> I am using Ubuntu on the mac by using Vmware Fusion. >> >> Drizzle server and client connect successfully, After selecting the schema >> when I execute the following command, >> >> show tables; >> >> client terminal throws the error >> >> ERROR 1044 (42000): Access denied for user 'umair' to schema >> 'DATA_DICTIONARY' >> >> My ubuntu account details are >> >> Account Name # Muhammad Umair >> Type # Administrator >> >> I have even try the authorization plugin, but still getting the same error. >> Any one can help me ? >> >> For authorization plugin , I follow the >> http://docs.drizzle.org/administration/authorization.html >> >> Thanks in advance! >> >> Kind Regards, >> >> Umair Muhammad >> Electrical Engineering Master Student, >> Specialization in Wireless Systems, >> School of Electrical Engineering, >> Royal Institute of Technology (KTH), >> SE 100-44 Stockholm, SWEDEN. >> Email: mum...@kth.se >> Cell: +46 764 097 574 >> _______________________________________________ >> Mailing list: https://launchpad.net/~drizzle-discuss >> Post to : drizzle-discuss@lists.launchpad.net >> Unsubscribe : https://launchpad.net/~drizzle-discuss >> More help : https://help.launchpad.net/ListHelp >> > > > _______________________________________________ > Mailing list: https://launchpad.net/~drizzle-discuss > Post to : drizzle-discuss@lists.launchpad.net > Unsubscribe : https://launchpad.net/~drizzle-discuss > More help : https://help.launchpad.net/ListHelp > _______________________________________________ Mailing list: https://launchpad.net/~drizzle-discuss Post to : drizzle-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~drizzle-discuss More help : https://help.launchpad.net/ListHelp
