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...