mysql access denied error

Google Cloud Apigee
1

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"

}

2

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!

1 Like