← prev | next →
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
Yogesh Pandey 2022-08-05 18:30:56
Written like this in column
Result required like this
In new column
Vchoudhary12 2022-08-05 18:33:03
Vchoudhary12 2022-08-05 18:33:07
Try this once
suricruise1 2022-08-05 19:05:37
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
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
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
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
smlkw 2022-08-07 10:12:47
Or GCP denies running that query with root user
Liran 2022-08-07 10:14:23
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
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
i found this and try focus on sugestion 2. running select * from mysql.tables_priv; returned this:
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?
← prev | next →
smlkw 2022-08-07 11:10:23
Show your command, please