List:General Discussion« Previous MessageNext Message »
From:prabhat kumar Date:October 1 2009 6:58am
Subject:Re: login issue..pls help
View as plain text  
a. INFORMATION_SCHEMA is the information database ie metadata, the place
that stores information about all the other databases that the MySQL server
maintains. Inside INFORMATION_SCHEMA there are several read-only tables.
They are actually views, not base tables, so there are no files associated
with them.

Each MySQL user has the right to access these tables, but can see only the
rows in the tables that correspond to objects for which the user has the
proper access privileges.

http://dev.mysql.com/doc/refman/5.0/en/information-schema.html

b. Its depend on your requirement like your user will perform only DML query
or also want DDL operations.

http://dev.mysql.com/doc/refman/5.1/en/privileges-provided.html

On Thu, Oct 1, 2009 at 12:08 PM, F.A.I.Z.A.L <sac.faizal@stripped> wrote:

> thanks kumar..
>
> now its working
>
> i have another doubt
>
> i created an user with limited privilege on particular schema.
> schema name: test
>
> *mysql> create user 'test'@'%' identified by 'test';
> mysql> grant select,insert,update,delete,create,drop on test.* to 'test'@
> '%';*
>
> after that i login with 'test' user using mysql query browser. but i can
> able to see other schemas like 'information_Schema' and 'test_schema'
> created by other.
>
> how can i avoid this. i want to see only my default schema..
>
> 2. for created new mysql database or schema what are the privileges are
> required..
>
> please help..
>
> Best Regards
> Faizal S
> GSM : 9840118673
> Blog: http://oradbapro.blogspot.com
>
>
> On Thu, Oct 1, 2009 at 11:09 AM, prabhat kumar <aim.prabhat@stripped>wrote:
>
>> Use : mysql -u root -p (it will prompt for password) and if its not a
>> local host also add -h ipaddress
>>
>>
>> On Thu, Oct 1, 2009 at 11:01 AM, F.A.I.Z.A.L <sac.faizal@stripped>wrote:
>>
>>> Hi
>>>
>>> iam getting the following error while login into mysql server.
>>>
>>> andd141# mysql -u root
>>> ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using
>>> password: NO)
>>>
>>>
>>> Can someone please help me understand why I am not able to login from
>>> root?
>>>
>>>
>>> Best Regards
>>> Faizal S
>>> GSM : 9840118673
>>> Blog: http://oradbapro.blogspot.com
>>>
>>
>>
>>
>> --
>> Best Regards,
>>
>> Prabhat Kumar
>> MySQL DBA
>> Datavail-India Mumbai
>> Mobile     : 91-9987681929
>> www.datavail.com
>>
>> My Blog: http://adminlinux.blogspot.com
>> My LinkedIn: http://www.linkedin.com/in/profileprabhat
>>
>
>


-- 
Best Regards,

Prabhat Kumar
MySQL DBA
Datavail-India Mumbai
Mobile     : 91-9987681929
www.datavail.com

My Blog: http://adminlinux.blogspot.com
My LinkedIn: http://www.linkedin.com/in/profileprabhat

Thread
login issue..pls helpF.A.I.Z.A.L1 Oct
  • Re: login issue..pls helpprabhat kumar1 Oct
    • Re: login issue..pls helpF.A.I.Z.A.L1 Oct
      • Re: login issue..pls helpprabhat kumar1 Oct
        • Re: login issue..pls helpF.A.I.Z.A.L1 Oct
          • Re: login issue..pls helpprabhat kumar1 Oct
            • Re: login issue..pls helpF.A.I.Z.A.L1 Oct
              • Re: login issue..pls helpF.A.I.Z.A.L1 Oct
                • Re: login issue..pls helpprabhat kumar1 Oct
                  • Re: login issue..pls helpF.A.I.Z.A.L1 Oct
                    • Re: login issue..pls helpF.A.I.Z.A.L1 Oct
                    • RE: login issue..pls helpLIU YAN3 Oct
                      • Re: login issue..pls helpMichael Dykman3 Oct
              • Re: login issue..pls helpprabhat kumar1 Oct
  • Transations? (was: Re: login issue..pls help)Martijn Tonies3 Oct
  • GRANT USAGE (was: Re: login issue..pls help)Martijn Tonies3 Oct