Running into this issue with Cloud SQL. Any idea what it could be ? I followed https://cloud.google.com/appengine/docs/flexible/nodejs/using-cloud-sql and and have the cloud proxy running locally on my Mac. But then run into this Access denied error when i execute the sample code. I tried couple of stackoverflow suggestions but nothing worked.
MacBook-Pro-2:cloudsql kunalpariani$ ./cloud_sql_proxy -instances=<instance-name>=tcp:3306
2017/05/09 19:32:15 Listening on 127.0.0.1:3306 for <instance-name>
2017/05/09 19:32:15 Ready for new connections
2017/05/09 19:35:06 New connection for "<instance-name>"
2017/05/09 19:35:08 Instance <instance-name> closed connection
MacBook-Pro-2:cloudsql kunalpariani$ node createTables.js
prompt: user: xxxxx
prompt: password: xxxxx
prompt: database: xxxxx
{ Error: ER_SPECIFIC_ACCESS_DENIED_ERROR: Access denied; you need (at least one of) the SUPER privilege(s) for this operation
at Query.Sequence._packetToError (/Users/kunalpariani/Projects/autocomplete/cloudsql/node_modules/mysql/lib/protocol/sequences/Sequence.js:52:14)
at Query.ErrorPacket (/Users/kunalpariani/Projects/autocomplete/cloudsql/node_modules/mysql/lib/protocol/sequences/Query.js:77:18)
at Protocol._parsePacket (/Users/kunalpariani/Projects/autocomplete/cloudsql/node_modules/mysql/lib/protocol/Protocol.js:280:23)
at Parser.write (/Users/kunalpariani/Projects/autocomplete/cloudsql/node_modules/mysql/lib/protocol/Parser.js:75:12)
at Protocol.write (/Users/kunalpariani/Projects/autocomplete/cloudsql/node_modules/mysql/lib/protocol/Protocol.js:39:16)
at Socket.<anonymous> (/Users/kunalpariani/Projects/autocomplete/cloudsql/node_modules/mysql/lib/Connection.js:103:28)
at emitOne (events.js:96:13)
at Socket.emit (events.js:191:7)
at readableAddChunk (_stream_readable.js:178:18)
at Socket.Readable.push (_stream_readable.js:136:10)
--------------------
at Protocol._enqueue (/Users/kunalpariani/Projects/autocomplete/cloudsql/node_modules/mysql/lib/protocol/Protocol.js:141:48)
at Connection.query (/Users/kunalpariani/Projects/autocomplete/cloudsql/node_modules/mysql/lib/Connection.js:208:25)
at createTable (/Users/kunalpariani/Projects/autocomplete/cloudsql/createTables.js:20:14)
at getConnection (/Users/kunalpariani/Projects/autocomplete/cloudsql/createTables.js:52:3)
at prompt.get (/Users/kunalpariani/Projects/autocomplete/cloudsql/createTables.js:43:5)
at /Users/kunalpariani/Projects/autocomplete/cloudsql/node_modules/prompt/lib/prompt.js:336:32
at /Users/kunalpariani/Projects/autocomplete/cloudsql/node_modules/async/lib/async.js:154:25
at assembler (/Users/kunalpariani/Projects/autocomplete/cloudsql/node_modules/prompt/lib/prompt.js:333:9)
at /Users/kunalpariani/Projects/autocomplete/cloudsql/node_modules/prompt/lib/prompt.js:342:32
at /Users/kunalpariani/Projects/autocomplete/cloudsql/node_modules/prompt/lib/prompt.js:625:5
code: 'ER_SPECIFIC_ACCESS_DENIED_ERROR',
errno: 1227,
sqlState: '42000',
index: 0 }
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/8b8f3d76-56fa-4191-9945-52a13c8de4f0%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
No comments:
Post a Comment