• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 322
  • Last Modified:

remote mysql acccess - does software use ssh

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
andieje
Asked:
andieje
  • 2
  • 2
  • 2
1 Solution
 
Manfred BertlManagerCommented:
They use the normal port for mysql, which is 3306. Just open that on your fw and it should work fine.
0
 
Gerwin Jansen, EE MVETopic Advisor Commented:
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
 
andiejeAuthor Commented:
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
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
Manfred BertlManagerCommented:
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
 
Gerwin Jansen, EE MVETopic Advisor Commented:
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
 
andiejeAuthor Commented:
Thanks very much
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

  • 2
  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now