Hi everyone, I am trying to connect apigee with mysql databasee though volos connectors. I have given the details that relates to database but I am still getting the following error.
{ "action": "GET", "query": {}, "path": "/people", "url": "/people", "data": { "code": "ER_ACCESS_DENIED_ERROR", "errno": 1045, "sqlState": "28000", "fatal": true }, "timestamp": 1491314680228, "duration": 3617, "applicationName": "volos-mysql", "sql": "SELECT idpeople FROM apigee.people LIMIT 100"
}
Can you make sure you have perms to access apigee database schema and people table? I'd test running the SQL statement first using a client MySQL CLI or DataGrip to ensure perms look all right.
Also make sure that your database whitelist the MPs IP addresses. Fr dev purposes and on a temporary basis you can whitelist all IPs until you isolate exactly the issue. Leveraging % while granting access whitelists all IPs.
Last but not least try NPM MySQL Module directly to isolate the issue. https://www.npmjs.com/package/mysql. It's possible that you're running into a bug. In that case, I can advise you to leverage something like J'sjs along with MySQL. But for now try tips above.
Hope it helps!
User | Count |
---|---|
7 | |
2 | |
2 | |
2 | |
1 |