Resolved: 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!
Hi Xannique!
Thank you for replying back to the thread and sharing this piece of information with the rest of the Community!
Good luck and please feel free to post another question should you encounter any difficulties. Thank you.
Best,
Martin