List Of Free Windows SSH Client Tools To Connect To Your Linux Server

You have Windows as operating system and you need to connect to Linux server to transfer files from Linux to Windows and inversely. So you need to have Secure Shell known as SSH. In fact, SSH is a network protocol which enables you to connect to Linux and Unix servers over the network. It uses public key cryptography to authenticate the remote computer. You can use SSH by several ways, either by using it automatically or by using a password authentication to log in.

This article provides a list of SSH clients let you to connect SSH to your Linux servers.

let’s start.

PuTTY

PuTTY is the most famous SSH and telnet client, developed originally by Simon Tatham for the Windows platform. PuTTY is open source software that is available with source code and is developed and supported by a group of volunteers.

Putty is very easy to install and to use.You don’t usually need to change most of the configuration options. To start the simplest kind of session, all you need to do is to enter a few basic parameters.

Bitvise SSH Client

Bitvise SSH Client is an SSH and SFTP client for Windows. It is developed and supported professionally by Bitvise. The SSH Client is robust, easy to install, easy to use. Bitvise SSH Client is a feature-rich graphical SSH/SFTP client for windows and allow you dynamic port forwarding through an integrated proxy with auto-reconnecting capability.

Bitvise SSH Client is free for personal use, as well as for individual commercial use inside organizations. You can download Bitvise SSH Client here.

MobaXterm

MobaXterm is your ultimate toolbox for remote computing. In a single Windows application, it provides loads of functions that are tailored for programmers, webmasters, IT administrators and pretty much all users who need to handle their remote jobs in a more simple fashion.

MobaXterm provides all the important remote network tools (SSH, X11, RDP, VNC, FTP, MOSH, …) and Unix commands (bash, ls, cat, sed, grep, awk, rsync, …) to Windows desktop, in a single portable exe file which works out of the box. MobaXterm is free for personal use. You can download MobaXterm from here.

DameWare SSH

I think that DameWare SSH is the best free ssh client.

This free tool is a terminal emulator that lets you make multiple telnet and SSH connections from one easy-to-use console.

• Manage multiple sessions from one console with a tabbed interface
• Save favorite sessions within the Windows file system
• Access multiple sets of saved credentials for easy log-in to different devices
• Connect to computers and devices using telnet, SSH1, and SSH2 protocols

You can download DameWare SSH  from this link.

SmarTTY

SmarTTY is a free multi-tabbed SSH client that supports copying files and directories with SCP on-the-fly.

Most SSH servers support up to 10 sub-sessions per connection. SmarTTY makes the best of it: no annoying multiple windows, no need to relogin, just open a new tab and go!

Cygwin

Cygwin is a large collection of GNU and Open Source tools which provide functionality similar to a Linux distribution on Windows.

Cygwin consists of a Unix system call emulation library, cygwin1.dll, together with a vast set of GNU and other free software applications organized into a large number of optional packages. Among these packages are high-quality compilers and other software development tools, an X11 server, a complete X11 development toolkit, GNU emacs, TeX and LaTeX, OpenSSH (client and server), and much more, including everything needed to compile and use PhysioToolkit software under MS-Windows.

An Introduction To MySQL Database

 

This tutorial will explains how to install MySQL, create a sample database, create a table, insert records into the table, and select records from the table.

Installation

You can install mysql using the following command:

On Ubuntu:

sudo apt-get install mysql-server

On Centos:

 sudo yum install mysql-server

Follows the steps below to stop and start MySQL

service mysql start

Starting MySQL.                                            [  OK  ]

service mysql status

MySQL running (12588) 

service mysql stop

Shutting down MySQL.                                       [  OK  ]

Verifying Installation

You can check the MySQL installed version by performing mysql -V as shown below:

[local-host]# mysql -V

mysql  Ver 14.14 Distrib 5.1.25-rc, for redhat-linux-gnu (i686) using readline 5.1

Access the MySQL shell

Once you have MySQL installed on your droplet, you can access the MySQL shell by typing the following command into terminal:

mysql -u root -p

After entering the root MySQL password into the prompt, you will be able to start building your MySQL database.

mysql -u root -p

Enter password: password

Welcome to the MySQL monitor.  Commands end with ; or \g.

Your MySQL connection id is 13

Server version: 5.1.25-rc-community MySQL Community Server (GPL)

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql>

Creating Databases

After connecting as MySQL root user, you can use this command to create database.

In this example, we will create unixmen database.

mysql> create database;

You can check what databases are available by typing this command:

SHOW DATABASES;

Your screen should look something like this:

 mysql> SHOW DATABASES;

+--------------------+

| Database           |

+--------------------+

| information_schema |

| mysql              |

| performance_schema |

| test               |

| unixmen            | 

|                    |

+--------------------+

5 rows in set (0.01 sec)

Creating Tables

Before you create a mysql table, you need to choose the database that you want to use:

USE unixmen;

Database changed

The following example creates a article table.

create table article (

id INT AUTO_INCREMENT PRIMARY KEY,

name varchar(20),

number varchar(10),

page int(10)

writing_date DATE);

The command show tables to view all the tables available in the database.

mysql> SHOW TABLES;

+------------------+

| Tables_in_unixmen |

+------------------+

| article         |

+------------------+

1 row in set (0.01 sec)

To view the table description, do the following command

 mysql>DESCRIBE article;

+-------------+-------------+------+-----+---------+----------------+

| Field       | Type        | Null | Key | Default | Extra          |

+-------------+-------------+------+-----+---------+----------------+

| id          | int(11)     | NO   | PRI | NULL    | auto_increment |

| name        | varchar(20) | YES  |     | NULL    |                |

| number      |  int(11)    | YES  |     | NULL    |                |

| page        | char(1)     | YES  |     | NULL    |                |

| writing_date| date        | YES  |     | NULL    |                |

+-------------+-------------+------+-----+---------+----------------+

5 rows in set (0.01 sec)

Add Information to Tables

Use the following sample insert commands to insert some records to the article table.

insert into article values(1,'article1','4','a','2012-04-13');

insert into article values(2,'article2','5','b','2012-04-14');

insert into article values(3,'article3','6','C','2012-04-15');

insert into article values(4,'article4','7','d','2012-04-16');

You can take a look at your table using this command

mysql> SELECT * FROM article

+----+------- +----------------+-----------+-------------+

| id | name   | number         | page      |wrinting_date|

+----+------- +----------------+-----------+-------------+

|  1 |article1| 1              | a         | 2012-04-13  |

|  2 |article2| 2              | b         | 2012-04-14  |

|  3 |article3| 3              | c         | 2012-04-15  |

|  4 |article4| 4              | d         | 2012-04-16  |

+----+--------+----------------+-----------+-------------+

4 rows in set (0.00 sec)

Update Information in the Table

You can update a stored information in the table with this command:

UPDATE `article`

SET

`number` = '6'

WHERE `article`.`name` ='article4

Delete a Row, a Column and a Table

You can  delete rows from the table with the following command:

DELETE from  where [column name]=[field text];

mysql> DELETE from article  where name='article2';

Query OK, 1 row affected (0.00 sec)

mysql> SELECT * FROM article

+----+------- +----------------+-----------+-------------+

| id | name   | number         | page      |wrinting_date|

+----+------- +----------------+-----------+-------------+

| 1 |article1 | 1              | a          | 2012-04-13 |

| 3 |article3 | 3              | c          | 2012-04-15 |

| 4 |article4 | 4              | d          | 2012-04-16 |

+----+--------+----------------+-----------+-------------+

3 rows in set (0.00 sec)

You can also delete a column using this command

ALTER TABLE  [column name];

And type this command if you want to delete all table

ALTER TABLE ;