Syntax to access the remote database/server

[Poorna Sravan Bhogavilli]

I am trying to establish a connection from a local database on my PC to the database hosted on a server, in this case it is in AWS MYSQL server.

I tried the syntax like


insert into [xxx.rds.amazonaws.com][database_name][user_name][table_name]


UPDATE [xxx.rds.amazonaws.com][database_name][user_name][table_name]
SET vin=b.vin
FROM [xxx.rds.amazonaws.com][database_name][user_name][table_name] a,
INNER JOIN [localhost][name_of_local_databse][user_name][table_name] b ON (a.serial_number=b.serial_number)
WHERE b.serial_number=1;


But, I am not able to connect to the other database. Could someone help?

Thanks in advance.