Solved

remote mysql acccess - does software use ssh

Posted on 2014-10-06
6
294 Views
Last Modified: 2014-10-10
Hi

Tools like mysql workbench and phpmyadmin will let you acccess remote databases as you know. But what connection are they using . Is it ssh. I've never seen an ssh 'handshake' when ive used these tools for remote access

thanks
0
Comment
Question by:andieje
  • 2
  • 2
  • 2
6 Comments
 
LVL 4

Expert Comment

by:mbertl
ID: 40363534
They use the normal port for mysql, which is 3306. Just open that on your fw and it should work fine.
0
 
LVL 37

Expert Comment

by:Gerwin Jansen, EE MVE
ID: 40363704
What do you mean by 'remote' exactly? Just opening the standard mysql port 3306 to the outside world (internet) is something I would not recommend...
0
 

Author Comment

by:andieje
ID: 40363864
remote means on a different server, I didnt ask if you recommended this action (no offence). I just wanted to know if they connect via tcp/ip or via ssh

naturally an open line isnt very secure


@mbertl20 - sorry but you didnt answer what i ask
0
Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

 
LVL 4

Expert Comment

by:mbertl
ID: 40363948
Well, you could start reading the documentation provided by the creators of the MySQL server itself:
Try this out:
http://dev.mysql.com/doc/internals/en/client-server-protocol.html
0
 
LVL 37

Accepted Solution

by:
Gerwin Jansen, EE MVE earned 500 total points
ID: 40364301
mysql can support SSL, but it has to be configured and then mysqld has to be started with the SSL options as desribed here: https://dev.mysql.com/doc/refman/5.1/en/using-ssl-connections.html

To check whether your mysql is capable of SSL, display the have_ssl variable:

mysql> SHOW VARIABLES LIKE 'have_ssl';

If you get YES - SSL is supported.

What do you get?
0
 

Author Closing Comment

by:andieje
ID: 40373755
Thanks very much
0

Featured Post

Master Your Team's Linux and Cloud Stack!

The average business loses $13.5M per year to ineffective training (per 1,000 employees). Keep ahead of the competition and combine in-person quality with online cost and flexibility by training with Linux Academy.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
running code or pseudo code of table structure 5 25
paypal ipn to mysql 3 36
SQL Query assistance 16 24
MS SQL Server COnditional Where statement 7 40
Entity Framework is a powerful tool to help you interact with the DataBase but still doesn't help much when we have a Stored Procedure that returns more than one resultset. The solution takes some of out-of-the-box thinking; read on!
I annotated my article on ransomware somewhat extensively, but I keep adding new references and wanted to put a link to the reference library.  Despite all the reference tools I have on hand, it was not easy to find a way to do this easily. I finall…
Learn how to find files with the shell using the find and locate commands. Use locate to find a needle in a haystack.: With locate, check if the file still exists.: Use find to get the actual location of the file.:
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question