Access denied in Command Prompt
I tried to use command prompt to fix the issue in this video however the screenshot is what I am seeing.
Thanks for reaching out.
You can grant the necessary privileges to the 'root' user with the following SQL command:
GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost';
This command gives the 'root' user full access to all databases and tables when connecting from 'localhost'.
After granting the privileges, you need to run the following command to ensure the changes are recognized immediately:sql
Then, close the console and try again. It should work.
Hope this helps.