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

Question

我正在尝试在环回 4 中运行待办事项列表示例。我使用 MySql 作为不同服务器上的后端数据库。我面临的问题是，虽然我可以从 MySql 工作台连接到数据库，但当我尝试使用相同的凭据从环回 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:UsersramesGitHubtodo-listnode_modulesmysqllibprotocolsequencesSequence.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:UsersramesGitHubtodo-listnode_modulesmysqllibprotocolsequencesSequence.js:47:14)
at Handshake.ErrorPacket (C:UsersramesGitHubtodo-listnode_modulesmysqllibprotocolsequencesHandshake.js:123:18)
at Protocol._parsePacket (C:UsersramesGitHubtodo-listnode_modulesmysqllibprotocolProtocol.js:291:23)
at Parser._parsePacket (C:UsersramesGitHubtodo-listnode_modulesmysqllibprotocolParser.js:433:10)
at Parser.write (C:UsersramesGitHubtodo-listnode_modulesmysqllibprotocolParser.js:43:10)
at Protocol.write (C:UsersramesGitHubtodo-listnode_modulesmysqllibprotocolProtocol.js:38:16)
at Socket.<anonymous> (C:UsersramesGitHubtodo-listnode_modulesmysqllibConnection.js:91:28)
at Socket.<anonymous> (C:UsersramesGitHubtodo-listnode_modulesmysqllibConnection.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:UsersramesGitHubtodo-listnode_modulesmysqllibprotocolProtocol.js:144:48)
at Protocol.handshake (C:UsersramesGitHubtodo-listnode_modulesmysqllibprotocolProtocol.js:51:23)
at PoolConnection.connect (C:UsersramesGitHubtodo-listnode_modulesmysqllibConnection.js:119:18)
at Pool.getConnection (C:UsersramesGitHubtodo-listnode_modulesmysqllibPool.js:48:16)
at MySQL.connect (C:UsersramesGitHubtodo-listnode_modulesloopback-connector-mysqllibmysql.js:90:17)
at Object.initializeDataSource [as initialize] (C:UsersramesGitHubtodo-listnode_modulesloopback-connector-mysqllibmysql.js:44:28)
at DbDataSource.DataSource.setup (C:UsersramesGitHubtodo-listnode_modulesloopback-datasource-jugglerlibdatasource.js:513:19)
at new DataSource (C:UsersramesGitHubtodo-listnode_modulesloopback-datasource-jugglerlibdatasource.js:145:8)
at new DbDataSource (C:UsersramesGitHubtodo-listsrcdatasourcesdb.datasource.ts:20:5)
at C:[e-mail]:73:14
at Object.transformValueOrPromise (C:[e-mail]:270:12)
at Object.instantiateClass (C:[e-mail]:66:35)
at C:[e-mail]:533:29
at Binding._getValue (C:[e-mail]:410:14)
at C:[e-mail]:305:23
at C:[e-mail]:114:13

Answer 1

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