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.prab...@gmail.com>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.fai...@gmail.com> 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 >
