Centos7.6之禪道開源版17.6.1安裝記錄

1. 下載

官網(wǎng)： http://www.zentao.net/download.html

wget https://www.zentao.net/dl/zentao/17.6.1/ZenTaoPMS.17.6.1.zbox_64.tar.gz

2. 安裝

# 1. 解壓
[root@localhost zbox]# tar -zxvf ZenTaoPMS.17.6.1.zbox_64.tar.gz 

# 2. 設(shè)置 Apache 端口號及mysql端口號
[root@localhost zbox]# /opt/zbox/zbox -ap 4005 -mp 3307
# 3.啟動禪道服務(wù)
[root@localhost zbox]# /opt/zbox/zbox start
Start Apache success
Start Mysql success

# 4. 至此服務(wù)啟動成功，訪問地址如下：
http://禪道服務(wù)器ip:4005

開放端口4005   
192.168.31.110:4005


http://192.168.31.110:4005

192.168.31.110:501 ssh
192.168.31.110:3307
192.168.31.110:4005
192.168.31.110:6379
192.168.31.110:8161
192.168.31.110:11211
192.168.31.110:27017
192.168.31.110:61616
192.168.31.110:5672
192.168.31.110:15672
192.168.31.110:5001
192.168.31.110:5002
192.168.31.110:5003
192.168.31.110:5004
192.168.31.110:5005
192.168.31.110:5006
192.168.31.110:5007
192.168.31.110:5008
192.168.31.110:5009
192.168.31.110:9000 
192.168.31.110:9001

3. 登錄

默認admin用戶密碼為： 123456

修改后密碼為：Sys2021@123

4. 連接數(shù)據(jù)庫

1. 本地連接

[root@localhost ~]# /opt/zbox/bin/mysql -u root -P 3307 -hlocalhost -p
Enter password: 

2. 遠程連接

這里以root用戶為例，可以自己創(chuàng)建用戶文章來源地址http://www.zghlxwxcb.cn/news/detail-830526.html

1. 開啟遠程訪問用戶

# 1.查看訪問權(quán)限
# SELECT User, Host FROM mysql.user;
MariaDB [(none)]>  SELECT User, Host FROM mysql.user;
+-------------+-----------+
| User        | Host      |
+-------------+-----------+
| mariadb.sys | localhost |
| nobody      | localhost |
| root        | localhost |
| zentao      | localhost |
+-------------+-----------+  
# 2. 開啟遠程連接
grant all privileges on *.* to 'root'@'%' identified by 'Sibo2022@zbox' with grant option;
# 3. 刷新權(quán)限
flush privileges;
# 4.再次查看
MariaDB [(none)]>  SELECT User, Host FROM mysql.user;
+-------------+-----------+
| User        | Host      |
+-------------+-----------+
| root        | %         |
| mariadb.sys | localhost |
| nobody      | localhost |
| root        | localhost |
| zentao      | localhost |
+-------------+-----------+
5 rows in set (0.002 sec)

2. 更改mysql綁定的主機

1. 編輯vim /opt/zbox/etc/mysql/my.cnf文件,并將bind-address注釋掉

[root@localhost ~]# vim /opt/zbox/etc/mysql/my.cnf 
[client]
port   = 3307
socket = /opt/zbox/tmp/mysql/mysql.sock

[mysqld_safe]
socket = /opt/zbox/tmp/mysql/mysql.sock
nice   = 0

[mysqld]
user     = nobody
pid-file = /opt/zbox/tmp/mysql/mysqld.pid
socket   = /opt/zbox/tmp/mysql/mysql.sock
port     = 3307
basedir  = /opt/zbox/run/mysql
datadir  = /opt/zbox/data/mysql
tmpdir   = /opt/zbox/tmp/mysql
skip-external-locking
# 注釋掉bind-address，任何主機可訪問
#bind-address            = 127.0.0.1
max_allowed_packet      = 20M
table_cache             = 64

max_connections = 600
innodb_buffer_pool_size = 512M
innodb_file_per_table = 1
innodb_log_files_in_group = 2
innodb_log_file_size = 256M
innodb_log_buffer_size = 16M
key_buffer_size         = 16M
sort_buffer_size        = 2M
join_buffer_size = 2M
query_cache_size = 40M
query_cache_limit = 2M
bulk_insert_buffer_size = 64M
read_buffer_size        = 2M
read_rnd_buffer_size    = 16M
thread_cache_size = 300

net_buffer_length       = 8K
myisam_sort_buffer_size = 8M
log_error  = /opt/zbox/logs/mysql_error.log

explicit_defaults_for_timestamp
default-storage-engine=InnoDB
default-tmp-storage-engine=InnoDB

server-id  = 1

[mysqldump]
quick
quote-names
max_allowed_packet = 16M

[mysql]
no-auto-rehash

[isamchk]
key_buffer_size  = 20M
sort_buffer_size = 20M
read_buffer      = 2M
write_buffer     = 2M

[myisamchk]
key_buffer_size  = 20M
sort_buffer_size = 20M
read_buffer      = 2M
write_buffer     = 2M

[mysqlhotcopy]
interactive-timeout

[root@localhost ~]# 

3. 重啟Apache與MySQL服務(wù)

# 重啟Apache和mysql
[root@localhost ~]# /opt/zbox/zbox restart mysql

4. 常用命令

1. Apache和Mysql常用命令

# 開啟Apache和Mysql
[root@localhost ~]# /opt/zbox/zbox start
# 停止Apache和Mysql
[root@localhost ~]# /opt/zbox/zbox stop 
# 重啟Apache和Mysql
[root@localhost ~]# /opt/zbox/zbox stop 
# 注：如果需要開機自動啟動，可以把 /opt/zbox/zbox restart 加到操作系統(tǒng)的自啟目錄。

2. 其他

# 可以使用/opt/zbox/zbox -h命令來獲取關(guān)于zbox命令的幫助。
# 其中 -ap參數(shù) 可以修改Apache的端口，-mp參數(shù) 可以修改Mysql的端口。
# 例如（apache端口改為8080，mysql端口改為3307）：
[root@localhost ~]#  /opt/zbox/zbox stop
[root@localhost ~]#  /opt/zbox/zbox -ap 8080 -mp 3307
[root@localhost ~]#  /opt/zbox/zbox start

到了這里，關(guān)于Centos7.6之禪道開源版17.6.1安裝記錄的文章就介紹完了。如果您還想了解更多內(nèi)容，請在右上角搜索TOY模板網(wǎng)以前的文章或繼續(xù)瀏覽下面的相關(guān)文章，希望大家以后多多支持TOY模板網(wǎng)！