ERROR 1064 42000 You have an error in your SQL syntax Want to configure a password as root being the user

Question

I have just downloaded WAMP  I want to configure a password for the MySQL root user using MySQL console  No password has been set previously   The following is the input      mysql- gt  use mysql     Database changed     mysql- gt  UPDATE user          - gt  SET Password PASSWORD lt  elephant7  gt           - gt  WHERE user  root        ERROR 1064  42000   You have an error in your SQL syntax  check the   manual that corresponds to your MySQL server version for the right   syntax to use near   WHERE user  root   at line 3

User · Answer

From the mysql documentation version  8 0 18   A superuser account  root   localhost  is created  A password for the superuser is set and stored in the error log file  To reveal it  use the following command  shell gt  sudo grep  temporary password   var log mysqld log Change the root password as soon as possible by logging in with the generated  temporary password and set a custom password for the superuser account   shell gt  mysql -uroot -p mysql gt  ALTER USER  root   localhost  IDENTIFIED BY  MyNewPass4

User · Answer

This worked perfectly for me  mysql gt  use mysql  mysql gt  ALTER USER  root   localhost  IDENTIFIED BY  my-password-here

User · Answer

I was using MySQL 8 and non of the above worked for me    This is what I had to do   ALTER USER  root   localhost  IDENTIFIED BY  new password

User · Answer

Try this   UPDATE mysql user SET password password  elephant7   where user  root

User · Answer

You can use   SET PASSWORD FOR  root    PASSWORD  elephant7      or  in latest versions   SET PASSWORD FOR root    elephant7     You can also use   UPDATE user SET password password  elephant7   WHERE user  root     but in Mysql 5 7 the field password is no more there  and you have to use   UPDATE user SET authentication string password  elephant7   WHERE user  root     Regards

User · Answer

The following commands  modified after those found here  worked for me on my WSL install of Ubuntu after hours of trial and error  sudo service mysql stop sudo mysqld --skip-grant-tables  amp  mysql -u root mysql UPDATE mysql user SET authentication string null WHERE User  root   flush privileges  ALTER USER  root   localhost  IDENTIFIED WITH mysql native password BY  your new password here   flush privileges  exit

User · Answer

I have problems with set password too  And find answer at  official site  SET PASSWORD FOR  root   localhost     your password

User · Answer

Try this one  It may be helpful   mysql gt  UPDATE mysql user SET Password   PASSWORD  pwd   WHERE User  root     I hope it helps

User · Answer

This is the only command that worked for me   I got it from M 8 0 documentation   ALTER USER  root      IDENTIFIED WITH mysql native password BY  YOURPASSWORD   ALTER USER  root   localhost  IDENTIFIED WITH mysql native password BY  YOURPASSWORD

User · Answer

On MySQL 8 0 15  maybe earlier than this too   the PASSWORD   function does not work anymore  so you have to do  Make sure you have stopped MySQL first  Go to   System Preferences   gt  gt   MySQL  and stop MySQL   Run the server in safe mode with privilege bypass  sudo mysqld safe --skip-grant-tables mysql -u root UPDATE mysql user SET authentication string null WHERE User  root   FLUSH PRIVILEGES  exit   Then mysql -u root ALTER USER  root   localhost  IDENTIFIED WITH caching sha2 password BY  yourpasswd    Finally  start your MySQL again  Enlighten by  OlatunjiYso in this GitHub issue

User · Answer

If you have ERROR 1064  42000  or ERROR 1046  3D000   No database selected in Mysql 5 7  you must specify the location of the user table  the location is mysql table name Then the code will work   sudo mysql -u root -p  UPDATE mysql user SET authentication string password  elephant7   WHERE user  root

User · Answer

While using mysql version 8 0     use the following syntax to update root password after starting mysql daemon with --skip-grant-tables option UPDATE user SET PASSWORD FOR  root   localhost    PASSWORD  your new password

User · Answer

mysql gt  use mysql  mysql gt  ALTER USER  root   localhost  IDENTIFIED BY  my-password-here    Try it once  it worked for me

[mysql] ERROR 1064 (42000): You have an error in your SQL syntax; Want to configure a password as root being the user

Examples related to mysql