<div>
They use the normal port for mysql, which is 3306. Just open that on your fw and it should work fine.
</div>


They use the normal port for mysql, which is 3306. Just open that on your fw and it should work fine.

<div>
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...
</div>


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...

<div>
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 <br />
<br />
naturally an open line isnt very secure<br />
<br />
<br />
@mbertl20 - sorry but you didnt answer what i ask
</div>


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

<div>
Well, you could start reading the documentation provided by the creators of the MySQL server itself:<br />
Try this out:<br />
<a href="http://dev.mysql.com/doc/internals/en/client-server-protocol.html" rel="ugc">http://dev.mysql.com/doc/internals/en/client-server-protocol.html</a>
</div>


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 [http://dev.mysql.com/doc/internals/en/client-server-protocol.html]

<div>
<div class="content wysiwyg-content">
Hi<br />
<br />
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<br />
<br />
thanks
</div>
</div>


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

remote mysql acccess - does software use ssh

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.

MySQL Server

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.

Databases

Linux is a UNIX-like open source operating system with hundreds of distinct distributions, including: Fedora, openSUSE, Ubuntu, Debian, Slackware, Gentoo, CentOS, and Arch Linux. Linux is generally associated with web and database servers, but has become popular in many niche industries and applications.