将本地Laravel环境连接到Google Cloud SQL-MySQL [英] Connect local Laravel environment to Google Cloud SQL - MySQL

问题描述

我尝试将Laravel项目连接到本地开发环境中，并连接到Google Cloud SQL(MySQL).

I try to connect my Laravel project into my local development environment to Google Cloud SQL (MySQL).

为此，我从带有Cloud SQL-Proxyclient的OSX终端连接到端口3307的远程数据库. 我可以将MySQL Workbench连接到远程数据库，并且可以查看/更改表，...

For this, I connected from my OSX Terminal with the Cloud SQL-Proxyclient to the remote database with port 3307. I can connect with my MySQL Workbench to the remote database, and I can see/change tables, ...

将我的Laravel项目添加到.env中，我更改了设置:

Into my Laravel project into .env I changed the settings:

DB_CONNECTION=mysql
DB_HOST=127.0.0.1
DB_PORT=3307
DB_DATABASE=mydatabasename
DB_USERNAME=mydatabaseusername
DB_PASSWORD=mydatabasepassword

当我在浏览器中打开我的项目时，在终端中看不到，这表明有人试图使用该连接. 进入浏览器，我收到一条错误消息: SQLSTATE [HY000] [2002]没有这样的文件或目录(2002)

When I open my project into the browser, into terminal I can't see, that something tries to use the connection. Into the browser I get an error message: SQLSTATE[HY000] [2002] No such file or directory (2002)

我认为，该项目无法连接到远程数据库

I think, the project can't connect to the remote database

我该如何解决这个问题?

How can I solve this problem?

感谢帮助！

推荐答案

确保您具有正确的DB_HOST配置.获取IPv4请阅读以下内容以获取更多信息: https://cloud.google.com/sql/docs/mysql/connect-external-app#appaccessIP

Make sure you have config for right DB_HOST. Let get an IPv4 Read this for more informations: https://cloud.google.com/sql/docs/mysql/connect-external-app#appaccessIP

这篇关于将本地Laravel环境连接到Google Cloud SQL-MySQL的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！