Last answered:

13 Nov 2024

Posted on:

12 Nov 2024

0

I forgot the workbench root password

nothing to add
1 answers ( 0 marked as helpful)
Instructor
Posted on:

13 Nov 2024

0
Hi Ibrahim!
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

Submit an answer