SQLSTATE[28000] [1045] 用户 'root'@'localhost' 的访问被拒绝(使用密码:NO) [英] SQLSTATE[28000] [1045] Access denied for user 'root'@'localhost' (using password: NO)

问题描述

我正在使用 symfony 2.1.2、FOSuserBundle、SonataAdminBundle、SonataUserBundle 和 SonataMediaBundle.问题是我无法访问我的数据库并收到此错误.

I´m working with symfony 2.1.2, FOSuserBundle, SonataAdminBundle, SonataUserBundle and SonataMediaBundle. The problem is that I cannot access to my database and get this error.

这是我的参数.yml

parameters:
    database_driver: pdo_mysql
    database_host: localhost
    database_port: null
    database_name: superlinea
    database_user: root
    database_password: !Admin1234
    mailer_transport: smtp
    mailer_host: localhost
    mailer_user: null
    mailer_password: null
    locale: en
    secret: f4c89326a7c2d2fb848e84dc8b39ea92
    database_path: null

这是我的 config.yml [教义部分:]

and this is my config.yml [ doctrine section: ]

doctrine:
    dbal:
        default_connection:   default
        connections:
            default:
                driver:   %database_driver%
                host:     %database_host%
                port:     %database_port%
                dbname:   %database_name%
                user:     %database_user%
                password: %database_password%
                charset:  UTF8
    orm:
        auto_generate_proxy_classes: %kernel.debug%
        # auto_mapping: true
        # entity_managers:
        #     default:
        #         mappings:
        #             ApplicationSonataMediaBundle: ~
        entity_managers:
            default:
                mappings:
                    ApplicationSonataMediaBundle: ~
                    ApplicationSonataUserBundle: ~
                    SonataUserBundle: ~
                    FOSUserBundle: ~
    dbal:
        types:
            json: Sonata\Doctrine\Types\JsonType

我使用 parameters.yml 上的凭据检查了从我的终端连接到 mysql 并正确连接.我清除了缓存，但仍然没有使用指定的密码.

I checked to connect to mysql from my terminal using the credentials on parameters.yml and it connects correctly. I purged the cache and still it isn´t taken the specified password.

有什么帮助吗?

推荐答案

问题出在你的 config.yml 中，

the problem is within your config.yml, the

dbal:
  types:
    json: Sonata\Doctrine\Types\JsonType

应该进入 dbal 教义.像这样:

should go inside doctrine dbal. Like this:

doctrine:
    dbal:
        default_connection:   default
        connections:
            default:
                driver:   %database_driver%
                host:     %database_host%
                port:     %database_port%
                dbname:   %database_name%
                user:     %database_user%
                password: %database_password%
                charset:  UTF8
        types:
            json: Sonata\Doctrine\Types\JsonType

希望能帮到你

这篇关于SQLSTATE[28000] [1045] 用户 'root'@'localhost' 的访问被拒绝(使用密码:NO)的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！