GCP) but I got this error -
mysqldump: Couldn't execute 'SHOW FIELDS FROM `view_active_opportunities`': SELECT command denied to user ''@'%' for column 'opportunity_id' in table 'tb_opportunity__area' (1143)
what it means? and how can I solve this?
Your user doesn’t have rights to execute that query
I think (and believe) that the user creating the dump is root in GCP. no? 😮
I see that the user that created (view definer) doesn’t exist anymore in DB. maybe that’s the issue?
Probably yes The important part in your issue — who is running the query
those are some other users in the mySQL not root.
It’s not obvious which user is running that query It’s just empty right now
how can i fix this?
Обсуждают сегодня