For earlier versions of MySQL, you can combine the user creation and granting privileges into a single statement, but the IDENTIFIED BY clause needs to be used correctly.
Some results have been hidden because they may be inaccessible to you
Show inaccessible results