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
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