Connecting Jira application error: SQL syntax near 'IDENTIFIED BY '<PASSWORD>''

[eiger3970]

Clean Jira and MySQL install.

I'm following https://confluence.atlassian.com/adminjiraserver/connecting-jira-applications-to-mysql-938846854.html

Step 3 for MySQL 5.7.6 and above, command fails: 

GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP,REFERENCES,ALTER,INDEX on <JIRADB>.* TO '<USERNAME>'@'<JIRA_SERVER_HOSTNAME>' IDENTIFIED BY '<PASSWORD>';

Error message: 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 'IDENTIFIED BY '<password entered when I setup the MySQL database>'' at line 1
 

[eiger3970]

I can complete the command without the identified argument. I.e.  GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP,REFERENCES,ALTER,INDEX on jiradb.* TO 'root'@'localhost';
Query OK, 0 rows affected (0.27 sec)