Resolved: SQL INSTALATION
I try so many time but the password still not correct, what shoud I do?Thank You.
2 answers ( 1 marked as helpful)
Hi Annisa!
Thanks for reaching out.
If you forgot the root password in MySQL, here’s a quick solution:
Reset the Root Password:
- Open the Command Prompt as an administrator.
- Run MySQL in safe mode:
mysqld --skip-grant-tables
- Open another Command Prompt and log in without a password:
mysql -u root
- Once logged in, reset the password:
UPDATE mysql.user SET authentication_string = PASSWORD('new_password') WHERE User = 'root';
FLUSH PRIVILEGES;
- Restart MySQL and log in with the new password.
This should resolve the issue.
Hope this helps.
Best,
Tsvetelin
Thanks for reaching out.
If you forgot the root password in MySQL, here’s a quick solution:
Reset the Root Password:
- Open the Command Prompt as an administrator.
- Run MySQL in safe mode:
mysqld --skip-grant-tables
- Open another Command Prompt and log in without a password:
mysql -u root
- Once logged in, reset the password:
UPDATE mysql.user SET authentication_string = PASSWORD('new_password') WHERE User = 'root';
FLUSH PRIVILEGES;
- Restart MySQL and log in with the new password.
This should resolve the issue.
Hope this helps.
Best,
Tsvetelin
Alright, thank you so much for the solution.