But why do i get this error?

|
P M 2022-08-05 01:07:08
Suno nana /etc/path

It’s open but unable to save bin path

P M 2022-08-05 01:07:15
Help me please
P M 2022-08-05 07:21:10
I need help installing MySQL in MAC on Intel
Yogesh Pandey 2022-08-05 15:12:09
Is there any function that converts seconds value to hh:mm:ss format in sas or sql?
Sachin Kansal 2022-08-05 15:59:11
Anyone can tell me about reference book/workbook on SQL and MySQL for practice
suricruise1 2022-08-05 16:06:15
Date format
Yogesh Pandey 2022-08-05 18:30:56
Written like this in column
129
Result required like this
00:02:09

In new column

Vchoudhary12 2022-08-05 18:33:03
SELECT(SEC_TO_TIME(129));
Vchoudhary12 2022-08-05 18:33:07
Try this once
suricruise1 2022-08-05 19:05:37
mysql_en-23586.jpg

suricruise1 2022-08-05 19:25:31
Is it working bro?
Dwijendra 2022-08-06 04:31:28
What resources..?Share to me..
Vaishnavi Kiran 2022-08-06 08:26:50
mysql_en-23593.jpg

Vaishnavi Kiran 2022-08-06 08:26:59
Can you help me
smlkw 2022-08-06 08:50:37
You have made a photo of a part of the question
V9000000 2022-08-06 09:04:24
Need MySQL dba
sara sara 2022-08-06 09:27:11
mysql_en-23597.jpg
Hello, on this page, which one should I click to continue?
Raghuvendra26 2022-08-06 20:30:39
Hello Freshers/Exp folks,

I am offering a 100% guranteed placement data analytics course in which I will give training in SQL, Excel and Tableau. Also I will be helping you in Resume Building, mock interview sessions and will align multiple interviews for you so that you can easily get placed. The duration of the course is 2 months.
I will also be providing interview proxy if the candidate requires.

Fees is very nominal.

Interested candidates can contact me directly on my number +91-8578902304 through phone or whatsapp to reserve your spot in my new batch..

Aviral_NSN 2022-08-06 20:35:19
Fee ??
Raghuvendra26 2022-08-06 20:37:32
Hi Aviral, kindly DM me for more details or call me on+91-8578902304.
Liran 2022-08-07 10:03:59
I tried to run dump on my replica (running on 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?

smlkw 2022-08-07 10:09:28
Your user doesn’t have rights to execute that query
Liran 2022-08-07 10:11:59
I think (and believe) that the user creating the dump is root in GCP. no? 😮
smlkw 2022-08-07 10:12:14
Seems no
smlkw 2022-08-07 10:12:47
Or GCP denies running that query with root user
Liran 2022-08-07 10:14:23
mysql_en-23616.jpg
thats the view definition. there;s a user definer
Liran 2022-08-07 10:16:57
I see that the user that created (view definer) doesn’t exist anymore in DB. maybe that’s the issue?
smlkw 2022-08-07 10:21:36
Probably yes

The important part in your issue — who is running the query

Liran 2022-08-07 10:26:08
those are some other users in the mySQL not root.
smlkw 2022-08-07 10:26:54
It’s not obvious which user is running that query

It’s just empty right now

Liran 2022-08-07 10:27:29
mysql_en-23621.jpg
i found this and try focus on sugestion 2. running select * from mysql.tables_priv; returned this:

https://dba.stackexchange.com/questions/84370/why-mysqldump-is-returning-with-error-1143-couldnt-execute-show-table-status

Liran 2022-08-07 10:30:55
but I dont understand why I see my own user name (lirany) as the view grantor while in the view definer there’s another user (avishayg) which doesn’t exist.
Liran 2022-08-07 11:07:13
how can i fix this?
Liran 2022-08-07 11:08:50
the user running the dump is root when using GCP’s export function. but why do i get this error?
smlkw 2022-08-07 11:10:23
Show your command, please
|