禅道数据库默认是绑定的127.0.0.1只能本地连接,如果需要远程连接则需要以下操作。
MariaDB Server version: 10.7.6-MariaDB Source distribution
1. /opt/zbox/etc/mysql/my.cnf 修改 bind-address 为 0.0.0.0
2. /opt/zbox/zbox restart
3. 添加远程用户
cd /opt/zbox/run/mysql/
./mysql -u root -p
create USER 'root'@'%' IDENTIFIED BY '123456';
select host,user,password from mysql.user;
grant all privileges on *.* to 'root'@'%' with grant option;