SQLSTATE [HY000] [1045]使用CakePHP对用户'usernam？?mysql

我是PHP和CakePHP的新手。使用CakePHP连接数据库时发现问题。

以下是我的应用程序配置。

我在Bitnami WAMP堆栈5.4.40-0上。我正在使用CakePHP 3.0.4创建Web MVC应用程序

在我的app.php文件中输入数据源。

/** * Connection information used by the ORM to connect * to your application's datastores. * Drivers include Mysql Postgres Sqlite Sqlserver * See vendor\cakephp\cakephp\src\Database\Driver for complete list / 'Datasources' => [ 'default' => [ 'className' => 'Cake\Database\Connection', 'driver' => 'Cake\Database\Driver\Mysql', 'persistent' => false, 'host' => 'localhost', /* * CakePHP will use the default DB port based on the driver selected * MySQL on MAMP uses port 8889, MAMP users will want to uncomment * the following line and set the port accordingly */ //'port' => 'nonstandard_port_number', 'username' => 'test2', 'password' => 'computer', 'database' => 'jobs', 'encoding' => 'utf8', 'timezone' => 'UTC', 'cacheMetadata' => true,

    /**
     * Set identifier quoting to true if you are using reserved words or
     * special characters in your table or column names. Enabling this
     * setting will result in queries built using the Query Builder having
     * identifiers quoted when creating SQL. It should be noted that this
     * decreases performance because each query needs to be traversed and
     * manipulated before being executed.
     */
    'quoteIdentifiers' => false,

    /**
     * During development, if using MySQL < 5.6, uncommenting the
     * following line could boost the speed at which schema metadata is
     * fetched from the database. It can also be set directly with the
     * mysql configuration directive 'innodb_stats_on_metadata = 0'
     * which is the recommended value in production environments
     */
    //'init' => ['SET GLOBAL innodb_stats_on_metadata = 0'],
],

我已经创建了一个名为数据库表的工作根据CakePHP的约定。用户test2具有与root管理员相同的全局特权。

但是，当我运行bake all命令时，出现以下错误：

2015-07-01 06:24:56 Error: [PDOException] SQLSTATE[HY000] [1045] Access denied for user 'test2'@'localhost' (using password: YES) Stack Trace: C:\Bitnami\wampstack-5.4.40-0\apache2\htdocs\myjobs\vendor\cakephp\cakephp\src\Database\Driver\PDODriverTrait.php(48): PDO->__construct('mysql:host=127....', 'test2', 'computer', Array) C:\Bitnami\wampstack-5.4.40-0\apache2\htdocs\myjobs\vendor\cakephp\cakephp\src\Database\Driver\Mysql.php(89): Cake\Database\Driver\Mysql->_connect('mysql:host=127....', Array) C:\Bitnami\wampstack-5.4.40-0\apache2\htdocs\myjobs\vendor\cakephp\cakephp\src\Database\Schema\BaseSchema.php(46): Cake\Database\Driver\Mysql->connect() 解决的问题（更新）

我遵循了安吉特和斯宾塞的指示。

我有几个问题。

我的用户的主机不是本地主机；那是个通配符%。进行了更改，然后MySQL开始拒绝连接。

我禁用了防火墙，发现端口不同于3306。因此我更改了中的条目app.php。现在我的应用程序已经烤好了:)