IMPORTANT, please fill the questions
We assume you are using Bitnami to deploy your application.
Which version of the application are you using?:
Please choose how you got the application: Installer (Windows, Linux, macOS), cloud image (AWS, GCE, Azure, ...) or VM (VMDK, VBOX):
AWS Lightsail (Wordpress + OS)
Have you installed any plugin or modified any configuration file?:
Describe here your question/suggestion/issue (expected and actual results):
I am unable to reset the MYSQL root password by using the following command:
UPDATE mysql.user SET Password=PASSWORD('NEW_PASSWORD') WHERE User='root';
This command is found at this Bitnami doc: https://docs.bitnami.com/aws/apps/wordpress/#how-to-change-the-mysql-root-password.
I have replaced the NEW_PASSWORD placeholder with my new password, 16 characters long with aplha, numeric and special characters.
Steps to reproduce the issue (if relevant):
I get the syntax error if I use the brackets. If I drop the brackets then I get the error: Update command not found. :
Copy the apache log (if relevant):
How do I solve this problem?