MYSQL-TOOLS

Comparison of graphical tools for MySQL

SSH and MySQL Articles | Using SSH Tunneling

Create SSH tunnel for MySQL connections

Print PDF
User Rating: / 75
PoorBest 

Today we consider the organization of SSH tunneling through PUTTY to MySQL.

Some programs require a connection to the database MySQL. For example mysql.exe console or other tools to work with databases of online stores or websites.

Very often, in the application, which requires a connection to the database MySQL, there are only 5 fields:

  • Host
  • Port
  • Login
  • Password
  • Database

Some hosting providers allow direct access to the databases from outside, but others provide access to MySQL only through SSH protocol.

To build a SSH tunnel from your local machine to the database on the hosting, we recommend using PuTTY.

Next, write out step by step process.

 

Copy file using SSH

Print PDF
User Rating: / 7
PoorBest 

SSH file transfer Sometimes it is necessary to administer our website download files in a context where there is access only for SSH. In this case, you can use SFTP-connection for your site, which will allow  to quickly upload the necessary files on the site. SFTP - SSH File Transfer Protocol (sometimes called Secure File Transfer Protocol).

 


mysql tools

How create data source in Visual Studio with data from My SQL tables with FK. more...

'mysql.proc' doesn't exist fixed problem

_

Table 'mysql.proc' doesn't exist. Fix error 1146 Table doesn't exist here...