SyntaxFix
Write A Post
Hire A Developer
Questions
Also the problem can occur if you are using old version of the MySQL UI (like SQLYoug) that generates passwords with wrong hash.
Creating user with SQL script will fix the problem.