FRIENDS,
I was getting error ( ERROR 1045 (28000): Access denied for user ‘root’@’localhost’ (using password: NO) while I was trying to login in Mysql :
Finally got the Solution , going to share with you , please have a look:-
[root@sylesh ~]# mysql -u root
ERROR 1045 (28000): Access denied for user ‘root’@’localhost’ (using password: NO)
>>disabling password authentication
service mysql stop
wait until MySQL shuts down. Then run
mysqld_safe –skip-grant-tables &
then you will be able to login as root with no password.
mysql -uroot mysql
In MySQL command line prompt issue the following command:
use databasename;
mysql>UPDATE user SET password=PASSWORD(“sahil”) WHERE user=”root”;
FLUSH PRIVILEGES;
EXIT
#/etc/init.d/mysqld restart
Now your root password is reset to “sahil” and MySQL will now
know the privileges and you’ll be able to login with your new password:
#mysql -uroot -p mysql
Enjoy Linux-Ing 🙂 🙂 🙂
good keep it up.
very good .
very good .
Hey there, I think your website might be having browser compatibility issues.
When I look at your website in Chrome, it looks fine but when opening in Internet
Explorer, it has some overlapping. I just wanted to give you a
quick heads up! Other then that, very good
blog!
Thank you !!
Hey there, I think your website might be having browser compatibility issues.
When I look at your website in Chrome, it looks fine but when opening in Internet
Explorer, it has some overlapping. I just wanted to give you a
quick heads up! Other then that, very good
blog!
Thank you !!