Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Google cloud sql instance super privilege error

I am very new in Google app engine please help me to solve my problem

I have created one instance in Google cloud sql when I import SQL file then it shows me error like this.

ERROR 1227 (42000) at line 1088: Access denied; you need (at least one of) the SUPER privilege(s) for this operation

How do I to add super privilege to my instance.

like image 450
ketan110 Avatar asked Mar 02 '15 08:03

ketan110


People also ask

Are Google Cloud SQL backups encrypted?

Cloud SQL customer data is encrypted when stored in database tables, temporary files, and backups. External connections can be encrypted by using SSL, or by using the Cloud SQL Auth proxy.

What type of database does Cloud SQL does not support?

MySQL 8.0 for Cloud SQL does not support the legacy version of MySQL high availability (HA) configuration that uses failover replicas. It supports the new regional HA configuration.

Is rest SQL cloud encrypted?

By default, the Google Cloud SQL service encrypts all data at rest using Google-managed encryption keys. The cloud service manages this type of encryption without any additional actions from you and your application.


1 Answers

As stated at the Cloud SQL documentation:

The SUPER privilege is not supported.

You can take a look at this page that explains how to import data to a Cloud SQL instance.

like image 139
Adrián Avatar answered Oct 10 '22 15:10

Adrián