List:General Discussion« Previous MessageNext Message »
From:F.A.I.Z.A.L Date:October 1 2009 6:38am
Subject:Re: login issue..pls help
View as plain text  
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
>

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