atlassian

安装过程网上资料很多，这里不再搬砖，只记录下遇到的问题：

1. 在配置数据库页面，测试连接时报错，尝试在命令行下登陆，报错信息如下：

[***@localhost ~]$ mysql -ujira -pjirapasswd
ERROR 1045 (28000): Access denied for user 'jira'@'localhost' (using password: YES)

在网上翻阅资料后多是说密码或加密或权限问题，在翻阅歪果仁网站时找到问题原因：

按照网上安装方法创建jira数据库后数据库多了一条jira的用户，

MariaDB [mysql]> select host,user,password from user ;                   
+-----------------------+------+-------------------------------------------+
| host                  | user | password                                  |
+-----------------------+------+-------------------------------------------+
| localhost             | root | *A101EAAAE07FFA75FDF2AF4665D3480F15198C43 |
| localhost.localdomain | root |                                           |
| 127.0.0.1             | root |                                           |
| ::1                   | root |                                           |
| localhost             |      |                                           |
| localhost.localdomain |      |                                           |
| %                     | jira | *BEE5CFA96B5FDBD262E3B38F0A341B6BF87C3565 |
+-----------------------+------+-------------------------------------------+
7 rows in set (0.00 sec)

一般情况下，jira会和MySQL安装在同一台主机上，配置jira时用127.0.0.1的地址，此时就会报上边提到的错误，以为"%"只能通配"localhost"或非"127.0.0.1"的地址，因此会报上面的错误。

有2种方法改善：

-1. 我们在配置jira时，可以把地址写为非"localhost"或非"127.0.0.1"的地址；

[***@localhost ~]$ mysql -ujira -pjirapasswd -h10.26.2.74
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 33
Server version: 5.5.56-MariaDB MariaDB Server
Copyright (c) 2000, 2017, Oracle, MariaDB Corporation Ab and others.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
MariaDB [(none)]> 

-2. 执行下面命令：

MariaDB [mysql]> grant all on jira.* to jira@'localhost ' identified by 'jirapasswd'; 
Query OK, 0 rows affected (0.00 sec)
MariaDB [mysql]> flush privileges;                                                        
Query OK, 0 rows affected (0.00 sec)
MariaDB [mysql]> select host,user,password from user ;                                    
+-----------------------+------+-------------------------------------------+
| host                  | user | password                                  |
+-----------------------+------+-------------------------------------------+
| localhost             | root | *A101EBD8E07FFA75FDF2AF4665D3480F15198C43 |
| localhost.localdomain | root |                                           |
| 127.0.0.1             | root |                                           |
| ::1                   | root |                                           |
| localhost             |      |                                           |
| localhost.localdomain |      |                                           |
| %                     | jira | *BEE5CFA96B5FDBD262E3B38F0A341B6BF87C3565 |
| localhost             | jira | *BEE5CFA96B5FDBD262E3B38F0A341B6BF87C3565 |
+-----------------------+------+-------------------------------------------+
8 rows in set (0.01 sec)
MariaDB [mysql]>