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
GSM : 9840118673
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:
>> 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
>> Best Regards
>> Faizal S
>> GSM : 9840118673
>> Blog: http://oradbapro.blogspot.com
> Best Regards,
> Prabhat Kumar
> MySQL DBA
> Datavail-India Mumbai
> Mobile : 91-9987681929
> My Blog: http://adminlinux.blogspot.com
> My LinkedIn: http://www.linkedin.com/in/profileprabhat