搭建JIRA避坑指南

JIRA对工作效率的帮助不用解释。新的工作需要为自己搭建JIRA。遇到若干坑，然后一步一步避坑。记录如下：

     1、Mysql的下载与安装: windows版mysql8.0安装详解_Zn昕的博客-CSDN博客_mysql8.0安装

     2、JIRA需要的Mysql java connector:

mysql-connector-java各种版本下载地址_Bruce_Json的博客-CSDN博客_mysql-connector-java

    3、建立数据库后，遇到Jira提醒数据看不为空的问题

jira安装与配置(Ubuntu),连接mysql8.0提示“连接的数据库不为空“的问题_MtAsFlash的博客-CSDN博客

   4、 mysql 给 jira 用户授权一直失败

mysql> GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP,REFERENCES,ALTER,INDEX on jiradb.* TO 'jira'@'localhost';
ERROR 1410 (42000): You are not allowed to create a user with GRANT
mysql> GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP,REFERENCES,ALTER,INDEX on jiradb.* TO jira@localhost;
ERROR 1410 (42000): You are not allowed to create a user with GRANT
mysql> grant all on jira.* to jira@'%'  identified by "jira";
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 "jira"' at line 1
mysql> grant select on jiradb.* to jira@'%'  identified by "jira";
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 "jira"' at line 1
mysql> grant select on jiradb.* to jira@'%'  identified by jira
    -> ;
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 jira' at line 1

最后成功的方法，并且JIRA成功运行。

mysql> GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP,REFERENCES,ALTER,INDEX on jiradb.* TO 'jira'@'%';
Query OK, 0 rows affected (0.02 sec)

mysql> flush privileges;
Query OK, 0 rows affected (0.01 sec)