javascript - 为什么我从 Loopback4 收到“访问被拒绝”错误，同时能够使用相同的凭据从 MySql 工作台进行连接

Question

我正在尝试在环回 4 中运行待办事项列表示例。我使用 MySql 作为另一台服务器上的后端数据库。我面临的问题是，虽然我可以从 MySql Workbench 连接到数据库，但当我尝试使用相同的凭据从环回 4 建立数据库连接时，出现以下错误。

感谢任何帮助。

<小时/>

Connection fails: Error: ER_DBACCESS_DENIED_ERROR: Access denied for user 'dev1'@'%' to database 'todo'
It will be retried for the next request.

C:\Users\rames\GitHub\todo-list\node_modules\mysql\lib\protocol\sequences\Sequence.js:47
  var err  = new Error(code + ': ' + packet.message);
             ^
Error: ER_DBACCESS_DENIED_ERROR: Access denied for user 'dev1'@'%' to database 'todo'
    at Handshake.Sequence._packetToError (C:\Users\rames\GitHub\todo-list\node_modules\mysql\lib\protocol\sequences\Sequence.js:47:14)
    at Handshake.ErrorPacket (C:\Users\rames\GitHub\todo-list\node_modules\mysql\lib\protocol\sequences\Handshake.js:123:18)
    at Protocol._parsePacket (C:\Users\rames\GitHub\todo-list\node_modules\mysql\lib\protocol\Protocol.js:291:23)
    at Parser._parsePacket (C:\Users\rames\GitHub\todo-list\node_modules\mysql\lib\protocol\Parser.js:433:10)
    at Parser.write (C:\Users\rames\GitHub\todo-list\node_modules\mysql\lib\protocol\Parser.js:43:10)
    at Protocol.write (C:\Users\rames\GitHub\todo-list\node_modules\mysql\lib\protocol\Protocol.js:38:16)
    at Socket.<anonymous> (C:\Users\rames\GitHub\todo-list\node_modules\mysql\lib\Connection.js:91:28)
    at Socket.<anonymous> (C:\Users\rames\GitHub\todo-list\node_modules\mysql\lib\Connection.js:525:10)
    at Socket.emit (events.js:210:5)
    at addChunk (_stream_readable.js:309:12)
    at readableAddChunk (_stream_readable.js:290:11)
    at Socket.Readable.push (_stream_readable.js:224:10)
    at TCP.onStreamRead (internal/stream_base_commons.js:182:23)
    --------------------
    at Protocol._enqueue (C:\Users\rames\GitHub\todo-list\node_modules\mysql\lib\protocol\Protocol.js:144:48)
    at Protocol.handshake (C:\Users\rames\GitHub\todo-list\node_modules\mysql\lib\protocol\Protocol.js:51:23)
    at PoolConnection.connect (C:\Users\rames\GitHub\todo-list\node_modules\mysql\lib\Connection.js:119:18)
    at Pool.getConnection (C:\Users\rames\GitHub\todo-list\node_modules\mysql\lib\Pool.js:48:16)
    at MySQL.connect (C:\Users\rames\GitHub\todo-list\node_modules\loopback-connector-mysql\lib\mysql.js:90:17)
    at Object.initializeDataSource [as initialize] (C:\Users\rames\GitHub\todo-list\node_modules\loopback-connector-mysql\lib\mysql.js:44:28)
    at DbDataSource.DataSource.setup (C:\Users\rames\GitHub\todo-list\node_modules\loopback-datasource-juggler\lib\datasource.js:513:19)
    at new DataSource (C:\Users\rames\GitHub\todo-list\node_modules\loopback-datasource-juggler\lib\datasource.js:145:8)
    at new DbDataSource (C:\Users\rames\GitHub\todo-list\src\datasources\db.datasource.ts:20:5)
    at C:\Users\rames\GitHub\todo-list\node_modules\@loopback\context\src\resolver.ts:73:14
    at Object.transformValueOrPromise (C:\Users\rames\GitHub\todo-list\node_modules\@loopback\context\src\value-promise.ts:270:12)
    at Object.instantiateClass (C:\Users\rames\GitHub\todo-list\node_modules\@loopback\context\src\resolver.ts:66:35)
    at C:\Users\rames\GitHub\todo-list\node_modules\@loopback\context\src\binding.ts:533:29
    at Binding._getValue (C:\Users\rames\GitHub\todo-list\node_modules\@loopback\context\src\binding.ts:410:14)
    at C:\Users\rames\GitHub\todo-list\node_modules\@loopback\context\src\binding.ts:305:23
    at C:\Users\rames\GitHub\todo-list\node_modules\@loopback\context\src\resolution-session.ts:114:13

Answer 1

我注意到连接字符串中的数据库名称存在拼写错误。我修复了它，现在可以连接了。@jaromanda 谢谢。