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.
Hi Xannique!
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:sqlFLUSH PRIVILEGES;
Then, close the console and try again. It should work.
Hope this helps.
Best,
Tsvetelin
Hi Tsvetelin,
I figured it out - I created a password ending with the following symbol: '
This caused the password to be saved as blank. I had to restart by uninstalling and reinstalling the app and creating a new password but thank you for the help!