Does anyone has mysql 8 database administration student guide?

|
Khushi Hura 2022-02-12 19:50:20
Ohk
Khushi Hura 2022-02-12 19:50:33
What’s its syntax
ceo_lupeko 2022-02-12 20:53:13
how to replace all numbers in string to certain value?
amuelle1 2022-02-13 00:01:16
Khushi Hura 2022-02-12 19:50:33
What’s its syntax

It’s not about syntax. As of security reasons you need special rights on mysql and mysql itself must configured to enable it. See load_file docu

Liran 2022-02-13 15:53:02
i have issue with one of my users – it has those privs = GRANT USAGE ON *.* TO ‘noamc’@’%’ + GRANT SELECT, INSERT, UPDATE ON `smallstage_grouponi_groupon`.`tb_orders_items_csat_questions` TO ‘noamc’@‘%’
with one PC i am able to connect and the other is getting – Communications link failure The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server. connect timed out connect timed out. why is that???
cris_highlight_bot 2022-02-13 15:53:03
Liran 2022-02-13 15:53:02
i have issue with one of my users – it has those privs = GRANT USAGE ON *.* TO ‘noamc’@’%’ + GRANT SELECT, INSERT, UPDATE ON `smallstage_grouponi_groupon`.`tb_orders_items_csat_questions` TO ‘noamc’@‘%’
with one PC i am able to connect and the other is getting – Communications link failure The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server. connect timed out connect timed out. why is that???

mysql_en-17445.jpg

cris_highlight_bot 2022-02-13 15:53:03
Liran 2022-02-13 15:53:02
i have issue with one of my users – it has those privs = GRANT USAGE ON *.* TO ‘noamc’@’%’ + GRANT SELECT, INSERT, UPDATE ON `smallstage_grouponi_groupon`.`tb_orders_items_csat_questions` TO ‘noamc’@‘%’
with one PC i am able to connect and the other is getting – Communications link failure The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server. connect timed out connect timed out. why is that???

mysql_en-17444.jpg

cris_highlight_bot 2022-02-13 15:53:03
Liran 2022-02-13 15:53:02
i have issue with one of my users – it has those privs = GRANT USAGE ON *.* TO ‘noamc’@’%’ + GRANT SELECT, INSERT, UPDATE ON `smallstage_grouponi_groupon`.`tb_orders_items_csat_questions` TO ‘noamc’@‘%’
with one PC i am able to connect and the other is getting – Communications link failure The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server. connect timed out connect timed out. why is that???

mysql_en-17443.jpg

cris_highlight_bot 2022-02-13 15:53:08
====================================================
MasterZiv 2022-02-14 11:08:33
@GCMON2 , offtopic .
Anuj Yadav 2022-02-14 13:05:00
mysql_en-17472.jpg
Hi can anyone help me in this question???
piterden 2022-02-14 13:06:53
Anuj Yadav 2022-02-14 13:05:00
Hi can anyone help me in this question???

Nope, sorry. Do it self

Anuj Yadav 2022-02-14 13:07:18
I’m halfway there but not sure how go forward
piterden 2022-02-14 13:07:49
Anuj Yadav 2022-02-14 13:07:18
I’m halfway there but not sure how go forward

It’s normal, you will do it

piterden 2022-02-14 13:08:55
Don’t send screenshots of your code to the chat
Anuj Yadav 2022-02-14 13:09:02
Ok
Anuj Yadav 2022-02-14 13:20:17
piterden 2022-02-14 13:07:49
It’s normal, you will do it

Hey,
I have to do it without using windows function

Anuj Yadav 2022-02-14 13:20:38
That is what making it difficult for me
Anuj Yadav 2022-02-14 13:21:13
Any tip for that???
MasterZiv 2022-02-14 13:24:10
Anuj Yadav 2022-02-14 13:20:17
Hey,
I have to do it without using windows function

This should not be done without window functions.

Anuj Yadav 2022-02-14 13:25:29
So should I tell my instructor that Or should I research more
MasterZiv 2022-02-14 13:43:37
Anuj Yadav 2022-02-14 13:25:29
So should I tell my instructor that Or should I research more

I think you should tell your tutor.

MasterZiv 2022-02-14 13:45:12
Anuj Yadav 2022-02-14 13:25:29
So should I tell my instructor that Or should I research more

or this can be done with recursive query, but I don’t know if MySQL supports it (if it does, then it should be only the latest 8)

Anuj Yadav 2022-02-14 13:46:51
MasterZiv 2022-02-14 13:45:12
or this can be done with recursive query, but I don’t know if MySQL supports it (if it does, then it should be only the latest 8)

Ok will check it out

Vijay A 2022-02-14 15:12:54
Hi Guys ,
I have a question regarding MySQL active active servers.

In a scenario if i keep two servers in active active state. Data gets added randomly in the server’s.

Let’s say when one server goes down for 15-20 mins and come back again .
Q. So will it synchronise first with the first server and then start inserting data or how it will act.

svart 2022-02-14 22:32:47
Vijay A 2022-02-14 15:12:54
Hi Guys ,
I have a question regarding MySQL active active servers.

In a scenario if i keep two servers in active active state. Data gets added randomly in the server’s.

Let’s say when one server goes down for 15-20 mins and come back again .
Q. So will it synchronise first with the first server and then start inserting data or how it will act.

I’d highly recommend to avoid active-active on prod. You could try galera if you are fine with its cons

Surbhiksyp 2022-02-15 08:23:41
Hii, plz help me about resources allocation in mysql
MasterZiv 2022-02-15 08:28:04
Surbhiksyp 2022-02-15 08:23:41
Hii, plz help me about resources allocation in mysql

Be more precise in your questions

Surbhiksyp 2022-02-15 08:29:50
Surbhiksyp 2022-02-15 08:23:41
Hii, plz help me about resources allocation in mysql

I want to know what is resources allocation exactly and how do we do it

MasterZiv 2022-02-15 08:33:43
Surbhiksyp 2022-02-15 08:29:50
I want to know what is resources allocation exactly and how do we do it

Which resources?

Surbhiksyp 2022-02-15 08:34:00
Memory
MasterZiv 2022-02-15 08:38:23
Surbhiksyp 2022-02-15 08:34:00
Memory

MySQL manages its memory itself, you need only configure the amount of memory to be used.
The docs are above

Surbhiksyp 2022-02-15 08:41:13
Thanks you 😊😊
Avinash Singh 2022-02-15 09:57:39
Hi All,

Does anyone has mysql 8 database administration student guide ?

Thanks.

snehakshaylata 2022-02-15 10:48:30
I want add columns
|