How to connect to a remote database from centos release 7 that I remotely connect to it(the server)?

Question

0.00/5 (No votes)

See more:

hi,
i'm new at linux environment. and i really need to do this as soon as possible.
i have a linux server and i connected to it using SSH(not local) from windows 8.1.(connected fine and can open terminal and transfer file)
i have a remote database to connect(with ip, usernam, passwaord) here is the problem, i don't know how to connect?!
can anyone guide me and show me the way? what is requirements and steps??

i'll be thankful if anyone could help me

What I have tried:

ERROR 2003 (HY000): Can't connect to MySQL server on....

should it be maria db or what?

Posted 20-Feb-17 19:52pm

Member 13013697

Updated 20-Feb-17 20:41pm

v2

Add a Solution

1 solution

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Michael_Davies · Answer 1 · 2017-02-20T20:41:00

Solution 1

The database on the remote machine uses a port to communicate, in order to connect to that port from a remote pc you need to redirect a local port to it and then use that local port to communicate with the remote database.

SSH port forwarding - Example, command, server config[^]

Posted 20-Feb-17 20:41pm

Michael_Davies

How to connect to a remote database from centos release 7 that I remotely connect to it(the server)?

1 solution

Solution 1

Add your solution here

Preview 0

How to connect to a remote database from centos release 7 that I remotely connect to it(the server)?

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us