mysql 1064 syntax,MySQL 1064 (42000) Syntax Error - while copy/pasting recommended code (update user...

Closed. This question does not meet Stack Overflow guidelines. It is not currently accepting answers.

Want to improve this question? Update the question so it's on-topic for Stack Overflow.

Closed 6 days ago.

Improve this question

This is an edit to comply with stackoverflow rules.

My original question for a small private offline diary was solved BY RITWIK MATH'S SUGGESTION BELOW.

My curiousity is still why I could not copy-paste mySQL syntax from all kinds of websites, including here, without getting syntax errors.

I'm going to close this myself tonight - I'm just still curious. Thanks!

Basically, I can't use help websites or how tos on this because I'm getting Syntax errors on copy-and-paste:

[...]

But I have no access to the "root" password and can't change it, because whatever I copy-paste from all websites, I'm getting 1064/42000 Syntax errors around the NEWPASSWORD and ROOT terms.

[...]

mysql> update user set authentication_string=password('NEWPASSWORD') 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 '('NEWPASSWORD') where user='root'' at line 1

I've tried all variations I can imagine (I tried backticks, too, not knowing if what looked like 'user' was user).

I think a syntax error is unlikely if code is found in so many places, so what's wrong??

[...]

Thanks a lot!!

# Answer 1

You can always go for XAMPP... I personally host my wordpress website locally using XAMPP... Another great alternative is Local by flywheel... this the link ... https://localwp.com/

Stop copy pasting without understanding at least the basics...