Thursday, March 7, 2013

Let' us a new start with Mysql

Forgot password   :(
Don't Worry

ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)

Solution:

(First start the mysql server instance or daemon with the --skip-grant-tables option. (security setting)  --) ignorable

 Follow this

open cmd
# mysql -u root mysql
mysql> UPDATE user SET Password=PASSWORD('your_new_password') where USER='root';
mysql> FLUSH PRIVILEGES;

 Then, restart the instance    
 /daemon without the --skip-grant-tables option. 

 Now you can able to connect with your new password.

# mysql -u root -p
Enter password: your_new_password



No comments:

Post a Comment

web stats