I'm confused about the MySQL passwords.
Upon MySQL install, I was provided a random password, then prompted to change. I changed to a password.
I then had a 2nd password from MySQL.
I added user root.
Somehow I cannot complete the below command with the user root and root password?
App: Jira 7.12.1.
Database MySQL: mysql Ver 8.0.12 for Linux on x86_64 (MySQL Community Server - GPL).
OS: CentOS Linux release 7.5.1804 (Core).
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