wizard icon indicating copy to clipboard operation
wizard copied to clipboard

Docker 安装完后,直接访问报数据库错误

Open YBenX opened this issue 3 years ago • 5 comments

Docker 安装完后,直接访问报数据库错误 SQLSTATE[HY000] [2002] Connection refused (SQL: select wz_project_catalogs., (select count() from wz_projects where wz_project_catalogs.id = wz_projects.catalog_id and wz_projects.deleted_at is null) as projects_count from wz_project_catalogs where show_in_home = 1 order by sort_level asc)

YBenX avatar Jul 14 '21 03:07 YBenX

没有数据库wizard有自动创建

YBenX avatar Jul 14 '21 03:07 YBenX

  1. 运行的操作系统是什么?
  2. 数据库是安装在宿主机上的还是独立的数据库服务器?连接地址是否正确?
  3. 数据库的账号对应的 host 和密码是否有权限访问呢

mylxsw avatar Jul 14 '21 04:07 mylxsw

  1. 运行的操作系统是什么?
  2. 数据库是安装在宿主机上的还是独立的数据库服务器?连接地址是否正确?
  3. 数据库的账号对应的 host 和密码是否有权限访问呢

确实是数据库IP写错了

YBenX avatar Jul 14 '21 13:07 YBenX

但是出现了一个新的问题: SQLSTATE[HY000] [1049] Unknown database 'wizard' (SQL: select wz_project_catalogs., (select count() from wz_projects where wz_project_catalogs.id = wz_projects.catalog_id and wz_projects.deleted_at is null) as projects_count from wz_project_catalogs where show_in_home = 1 order by sort_level asc)

数据库不是自动创建的吗?

YBenX avatar Jul 14 '21 13:07 YBenX

手动创建数据库后,直接在应用容器里面执行下面两条命令就可以了: php artisan migrate:install php artisan migrate

YBenX avatar Jul 14 '21 13:07 YBenX