So it means the machine running the mySQL was configured to recieve connections only from the VPN?

|
Makgato 2022-02-15 11:07:28
Hey guys i need to know that how to host mySQL database to access it from another devices
piterden 2022-02-15 12:16:18
Makgato 2022-02-15 11:07:28
Hey guys i need to know that how to host mySQL database to access it from another devices

What do you mean? Call a few cases

snehakshaylata 2022-02-15 12:54:17
Anyone can help me
snehakshaylata 2022-02-15 12:54:33
How to add columns value in a column
MasterZiv 2022-02-15 12:55:28
snehakshaylata 2022-02-15 12:54:33
How to add columns value in a column

INSERT or UPDATE

Prashant 2022-02-15 12:56:10
snehakshaylata 2022-02-15 12:54:33
How to add columns value in a column

Alter table table_name add column_name datype;

snehakshaylata 2022-02-15 13:02:36
No no
snehakshaylata 2022-02-15 13:03:03
mysql_en-17522.jpg

snehakshaylata 2022-02-15 13:03:26
I want add three columns for tot_sc
Vijay A 2022-02-15 13:04:17
svart 2022-02-14 22:32:47
I’d highly recommend to avoid active-active on prod. You could try galera if you are fine with its cons

What do you suggest for high availability

Prashant 2022-02-15 13:05:12
Insert into table_name(column_name1,column_name2,column_name3) values(value1,values2,value3);
MasterZiv 2022-02-15 13:05:36
snehakshaylata 2022-02-15 13:03:26
I want add three columns for tot_sc

Ask full , detailed question then

svart 2022-02-15 14:31:23
Vijay A 2022-02-15 13:04:17
What do you suggest for high availability

I already provided you suggestions

Vijay A 2022-02-15 14:59:18
Ohh Galera cluster.. thanks
NSG6349 2022-02-15 15:18:15
Hi, I want to create a query to fetch data from log tables where i need to find the number of customers who are using services for 10 days continues, if a user is not using the app for 14 days, and few other buckets. Can someone help me out to build the logic around it.
Liran 2022-02-15 15:54:22
my user is defined like this: GRANT all PRIVILEGES ON *.* TO ‘lirany’@‘%’
I am unable to connect to this if my VPN is off – why is that if it’s defined with %??? PLEASE SEND HELP
MasterZiv 2022-02-15 17:18:09
Liran 2022-02-15 15:54:22
my user is defined like this: GRANT all PRIVILEGES ON *.* TO ‘lirany’@‘%’
I am unable to connect to this if my VPN is off – why is that if it’s defined with %??? PLEASE SEND HELP

because you don’t have network connection to that host at all, obviously

Liran 2022-02-15 17:19:20
MasterZiv 2022-02-15 17:18:09
because you don’t have network connection to that host at all, obviously

so it means the machine running the mySQL was configured to recieve connections only from the VPN?

MasterZiv 2022-02-15 17:20:15
Liran 2022-02-15 17:19:20
so it means the machine running the mySQL was configured to recieve connections only from the VPN?

no, you can reach the network where MySQL is listening the network only by means of VPN

Liran 2022-02-15 17:20:57
MasterZiv 2022-02-15 17:20:15
no, you can reach the network where MySQL is listening the network only by means of VPN

so mysql bind-address is set to VPN address?

MasterZiv 2022-02-15 17:21:27
Liran 2022-02-15 17:20:57
so mysql bind-address is set to VPN address?

,no there is no such notion as VPN address

Liran 2022-02-15 17:21:52
MasterZiv 2022-02-15 17:21:27
,no there is no such notion as VPN address

i dont understand then 🙁 can you explain little bit more

MasterZiv 2022-02-15 17:22:41
Liran 2022-02-15 17:21:52
i dont understand then 🙁 can you explain little bit more

Learn networking, and you will understand.
Now, ask more practical, simple questions.

Liran 2022-02-15 17:23:44
i just try to understand if it’s something with the mySQL / the machine running the mySQL/ my PC
MasterZiv 2022-02-15 17:24:01
Liran 2022-02-15 15:54:22
my user is defined like this: GRANT all PRIVILEGES ON *.* TO ‘lirany’@‘%’
I am unable to connect to this if my VPN is off – why is that if it’s defined with %??? PLEASE SEND HELP

this grant
GRANT all PRIVILEGES ON *.* TO ‘lirany’@‘%’
is not related at all to how you can connect to your mysqld instance by means of networking.

MasterZiv 2022-02-15 17:25:06
Liran 2022-02-15 17:23:44
i just try to understand if it’s something with the mySQL / the machine running the mySQL/ my PC

if it’s something is not understandable

Vijay A 2022-02-15 17:26:13
Liran simple telnet to machine running to MySQL ip and port number will conclude if you have connectivity or not
Vijay A 2022-02-15 17:26:33
Then try to ask MySQL related questions if connectivity is good
Vijay A 2022-02-15 17:26:52
telnet x.x.x.x 3306
Vijay A 2022-02-15 17:27:03
Replace x.x.x.x with ur actual ip address
Liran 2022-02-15 17:35:27
MasterZiv 2022-02-15 17:24:01
this grant
GRANT all PRIVILEGES ON *.* TO ‘lirany’@‘%’
is not related at all to how you can connect to your mysqld instance by means of networking.

then what exactly the % means?

MasterZiv 2022-02-15 17:37:32
Liran 2022-02-15 17:35:27
then what exactly the % means?

it is mask for the hosts from which the user can connect. But it is NOT related to networking.
First you must reach the MySQL instance from the network, then mysql will choose one of users by the login name and the host from which you are connecting.

Liran 2022-02-15 18:04:38
if bind-address was set to *, it means I can access the mySQL from any network no?
MasterZiv 2022-02-15 18:05:55
Liran 2022-02-15 18:04:38
if bind-address was set to *, it means I can access the mySQL from any network no?

% , not * .

Yes , the idea is like this.

Liran 2022-02-15 18:08:44
if it is * what it means then? because the mySQL im trying to connect is with * not % for bind-address
|