ER_SPECIFIC_ACCESS_DENIED_ERROR while trying to connect to Cloud SQL (2nd Generation-MySQL 5.7)

[Kunal Pariani]

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 }

[David Newgas]

Cloud SQL does not give SUPER privileges. Your script is probably doing something that requires this such as using "DEFINER" in a trigger/event or modifying system tables.

What SQL is your script running when it gets the error? (You might find this at line 20)

--
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+unsub...@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.