如何通过Symfony 4连接到使用MAMP创建的mySQL数据库? [英] How can I connect via Symfony 4 to mySQL database created with MAMP?
本文介绍了如何通过Symfony 4连接到使用MAMP创建的mySQL数据库?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我在MAMP中创建了一个名为项目"的数据库.
I created a database in MAMP called "project".
在我的.env
文件中,添加了以下行:
In my .env
file I added this line:
DATABASE_URL=mysql://root:root@localhost:3306/project
现在我要跑步
php bin/console doctrine:database:create
但是我收到一条错误消息:
But I get an error message:
SQLSTATE [HY000] [2002]没有这样的文件或目录
SQLSTATE[HY000] [2002] No such file or directory
我的学说配置:
parameters:
# Adds a fallback DATABASE_URL if the env var is not set.
# This allows you to run cache:warmup even if your
# environment variables are not available yet.
# You should not need to change this value.
env(DATABASE_URL): ''
doctrine:
dbal:
# configure these for your database server
driver: 'pdo_mysql'
server_version: '5.7'
charset: utf8mb4
default_table_options:
charset: utf8mb4
collate: utf8mb4_unicode_ci
url: '%env(resolve:DATABASE_URL)%'
orm:
auto_generate_proxy_classes: '%kernel.debug%'
naming_strategy: doctrine.orm.naming_strategy.underscore
auto_mapping: true
mappings:
App:
is_bundle: false
type: annotation
dir: '%kernel.project_dir%/src/Entity'
prefix: 'App\Entity'
alias: App
推荐答案
解决了!
在文件"config/packages/doctrine.yaml"中,我必须添加这一行
in the file "config/packages/doctrine.yaml" I had to add this line
unix_socket:/Applications/MAMP/tmp/mysql/mysql.sock
unix_socket: /Applications/MAMP/tmp/mysql/mysql.sock
这意味着更改此内容:
dbal:
# configure these for your database server
driver: 'pdo_mysql'
server_version: '5.7'
charset: utf8mb4
default_table_options:
charset: utf8mb4
collate: utf8mb4_unicode_ci
url: '%env(resolve:DATABASE_URL)%'
进入
dbal:
# configure these for your database server
driver: 'pdo_mysql'
server_version: '5.7'
charset: utf8mb4
unix_socket: /Applications/MAMP/tmp/mysql/mysql.sock
default_table_options:
charset: utf8mb4
collate: utf8mb4_unicode_ci
url: '%env(resolve:DATABASE_URL)%'
这篇关于如何通过Symfony 4连接到使用MAMP创建的mySQL数据库?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文