[google-cloud-sql-discuss] select command denied for root

I am facing a very strange issue. 

I created a google cloud instnace which also created the root user to import all databased from external source.

 However, when i try to select any table i get the error

https://prnt.sc/11hl93h

when i login as root and use the show grants command, i get 

https://prnt.sc/11hl6ul

The user root is shown in the users section of the cloudSQL

https://prnt.sc/11hla6o

Google cloud documentation is useless and wrong 

https://prnt.sc/11hlbs0

Did any one have this issue with cloudSQL? If yes, how did you resolve it.

Thanks and Regards

Ravi Kumar

--
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/0df3b5f9-92ca-4d90-8390-f4fcac2e3957n%40googlegroups.com.