Sunday, January 12, 2020

[google-cloud-sql-discuss] I have no idea how to resovled this problem when I tried to restore a MySQL database

Hey guys ,I uploaded my database backup file which was a sql file to GCP storage,then I tried to import this backup file into the MySQL vm,after a while it occured ths exception

Import failed: Import error: exit status 1 ERROR 1227 (42000) at line 10871: Access denied; you need (at least one of) the SUPER privilege(s) for this operation


it can't be resolved anyway though,it's impossible to grant super privilleges to any users in MySQL vm though

--
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/896594df-21f7-490d-97a2-4aaa59f46b91%40googlegroups.com.

No comments:

Post a Comment