php连接远程mysql已解决悬赏5积分

提问者向暖答案数1 阅读数1560 发表时间2017-09-20 09:45:35

php和apache在同一台服务器，而mysql在另一台服务器，怎样连接数据库

禅道版本：9.5

安装包类型：源码包

操作系统：CentOS

客户端浏览器：Chrome

答案列表

石洋洋 2017-09-20 10:15:51

安装禅道过程中会有专门填写mysql参数的页面，按照mysql参数填写即可。

3条回复

🥝

向暖 2017/09/20

填写了报错
09:49:02 Uncaught PDOException: SQLSTATE[42000]: Syntax error or access violation: 1044 Access denied for user 'druid_write'@'%' to database 'zentao' in module/install/model.php:345
Stack trace:
#0 module/install/model.php(345): PDO->query('CREATE DATABASE...')
#1 module/install/model.php(230): installModel->createDB('5.7')
#2 module/install/control.php(113): installModel->checkConfig()
#3 framework/base/router.class.php(1691): install->step3()
#4 www/install.php(36): baseRouter->loadModule()
#5 {main}
thrown in module/install/model.php on line 345 when visiting /zentaopms/www/install.php?m=install&f=step3

🥝

向暖 2017/09/20

填写报错09:49:02 Uncaught PDOException: SQLSTATE[42000]: Syntax error or access violation: 1044 Access denied for user 'druid_write'@'%' to database 'zentao' in module/install/model.php:345
Stack trace:
#0 module/install/model.php(345): PDO->query('CREATE DATABASE...')
#1 module/install/model.php(230): installModel->createDB('5.7')
#2 module/install/control.php(113): installModel->checkConfig()
#3 framework/base/router.class.php(1691): install->step3()
#4 www/install.php(36): baseRouter->loadModule()
#5 {main}
thrown in module/install/model.php on line 345 when visiting /zentaopms/www/install.php?m=install&f=step3

石洋洋 2017/09/21

@向暖：请不要多个地方提问相同的问题，报错提示很清楚，也回复过。

联系我们