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
