Solved

remote mysql acccess - does software use ssh

Posted on 2014-10-06
6
298 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 38

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
Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

 
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 38

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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

These days, all we hear about hacktivists took down so and so websites and retrieved thousands of user’s data. One of the techniques to get unauthorized access to database is by performing SQL injection. This article is quite lengthy which gives bas…
Google Drive is extremely cheap offsite storage, and it's even possible to get extra storage for free for two years.  You can use the free account 15GB, and if you have an Android device..when you install Google Drive for the first time it will give…
Learn how to get help with Linux/Unix bash shell commands. Use help to read help documents for built in bash shell commands.: Use man to interface with the online reference manuals for shell commands.: Use man to search man pages for unknown command…
Connecting to an Amazon Linux EC2 Instance from Windows Using PuTTY.

789 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