What security reasons do you mean?

|
PrasanjitPattanaik 2021-11-29 20:31:03
MasterZiv 2021-11-29 20:29:57
Why are your credentials ‘exposed’ ? Don’t ‘expose’ then.

Suppose by mistake

MasterZiv 2021-11-29 20:31:23
PrasanjitPattanaik 2021-11-29 20:31:03
Suppose by mistake

Don’t do mistakes then.

PrasanjitPattanaik 2021-11-29 20:31:34
piterden 2021-11-29 20:30:47
I don’t know what to say else

Ok then bro then can you share any docs or anything. For more reference

MasterZiv 2021-11-29 20:32:16
PrasanjitPattanaik 2021-11-29 20:31:03
Suppose by mistake

What else do you need from us? to keep your secret passwords for you?

piterden 2021-11-29 20:33:20
PrasanjitPattanaik 2021-11-29 20:31:34
Ok then bro then can you share any docs or anything. For more reference

I don’t know. It is so obvious

MasterZiv 2021-11-29 20:34:58
Usually RDBMS is not accessed from the Internet, only from Intranet, local network, so it doesn’t matter from which host you allow this access.
*.*.*.* will mean ‘from any host inside the Intranet.
piterden 2021-11-29 20:35:46
I always allow only localhost
piterden 2021-11-29 20:44:56
PrasanjitPattanaik 2021-11-29 20:21:20
In MySQL while creating users I am also adding Host IP for security reasons.

So if a new node auto scale that IP is not their in Mysql so they are not connected

What security reasons do you mean?

PrasanjitPattanaik 2021-11-29 21:45:13
piterden 2021-11-29 20:44:56
What security reasons do you mean?

If suppose due to any developer the mysql User name and Password is exposed then also no one can acess to it.

PrasanjitPattanaik 2021-11-29 21:45:20
As the IP will be different
Nobita 2021-11-30 16:31:15
Hi everyone i was wondering if you could help me with this i have one table(A) which has 10 columns in it and the table contains millions of record now i have another table(B) which has 14 columns in it my requirement is i need to merge A and B and between A & B 10 columns are same can someone tell how this can be done
MasterZiv 2021-11-30 16:52:02
Nobita 2021-11-30 16:31:15
Hi everyone i was wondering if you could help me with this i have one table(A) which has 10 columns in it and the table contains millions of record now i have another table(B) which has 14 columns in it my requirement is i need to merge A and B and between A & B 10 columns are same can someone tell how this can be done

Explain first what you mean by “to merge A and B”

davidraja james 2021-11-30 16:56:00
it means table A contain a 10 column and table b cantain a 14 column… his doubt was Merge to two table…he want to like single table…
Nobita 2021-11-30 17:02:46
Yeah I need to insert the table A to B
MasterZiv 2021-11-30 17:08:34
Nobita 2021-11-30 17:02:46
Yeah I need to insert the table A to B

Well, then just write corresponding INSERT statement

davidraja james 2021-11-30 17:11:33
that’s okay.. how to add in new column and then how to insert new values…
MasterZiv 2021-11-30 17:30:38
davidraja james 2021-11-30 17:11:33
that’s okay.. how to add in new column and then how to insert new values…

you can’t add fields in INSERT statement.
That is why I asked WHAT exactly you wand to do

rodrigo_tc7 2021-11-30 20:52:27
Insert from select with extra colums as null values
rodrigo_tc7 2021-11-30 20:52:39
Or default values if they exists
2021-11-30 20:56:06
Pls what I’m I suppose to do as a bigginer
piterden 2021-12-01 16:03:41
Nobita 2021-11-30 17:02:46
Yeah I need to insert the table A to B

Use CREATE TABLE AS statement

yogesh365 2021-12-01 16:55:51
I write the kubernets mysql backup script , the backup script working fine manually but not working in cronjob, if any one know suggest me the solution

kubectl exec mysql-0 -n autotat-qa — mysqldump -u root –password=root@123 –all-databases –single-transaction –quick –lock-tables=false | gzip > /home/ec2-user/backups/mysql/$(date +%Y%m%d%H%M%S).sql.gz

MasterZiv 2021-12-01 17:40:58
yogesh365 2021-12-01 16:55:51
I write the kubernets mysql backup script , the backup script working fine manually but not working in cronjob, if any one know suggest me the solution

kubectl exec mysql-0 -n autotat-qa — mysqldump -u root –password=root@123 –all-databases –single-transaction –quick –lock-tables=false | gzip > /home/ec2-user/backups/mysql/$(date +%Y%m%d%H%M%S).sql.gz

This is not related to mySQL

2021-12-02 08:05:02
Tnx
L_evan 2021-12-03 13:38:14
mysql_en-14577.jpg
Hello friends, Kindly assist I’m stuck ,I’d like to connect this db with an existing one from filemaker pro, how should I go about it? Thank you all in advance.😟
rodrigo_tc7 2021-12-04 02:30:43
Malformed subquery
rodrigo_tc7 2021-12-04 11:54:09
You have only select clause and no ending parenthesis… You should start over there
Iconoclastic_004 2021-12-04 16:27:37
mysql_en-14596.jpg
Photo from $€%π@™
Iconoclastic_004 2021-12-04 16:27:38
mysql_en-14598.jpg
Photo from $€%π@™
Iconoclastic_004 2021-12-04 16:27:38
mysql_en-14597.jpg
Photo from $€%π@™
Iconoclastic_004 2021-12-04 16:27:53
Does anyone have pdf of these books
Liran 2021-12-05 12:58:59
i have a table that i would like to update a specific column from true to false. i want to do this for a list of ID’s that i have (like 2000 ids). what’s the best way to do this?
using where in?
svart 2021-12-05 13:02:14
Liran 2021-12-05 12:58:59
i have a table that i would like to update a specific column from true to false. i want to do this for a list of ID’s that i have (like 2000 ids). what’s the best way to do this?
using where in?

when you do not have much rows to update then it is fine to go with “where”. if you would have a bigger amount rows then would be better to insert ids into another table and then join tables

Liran 2021-12-05 13:03:08
it might have 2000 rows to update
Liran 2021-12-05 13:03:53
so better approach will be to create some table just with those ID’s, then join tables based id’s and then update this join?
|