Connect to MySQL Database thru SSH-Tunnel on UNIX

Today I was struggling with connecting to a MySQL server behind a firewall. If you want to connect to a SQL Server or anything else behind a firewall within one shell this will might not challenge you due to the convenient usage of ssh. Therefore, in UNIX the only thing you have to type into …

MySQL: How to add a new column to a table fast?

Recently I was wondering why an old Windows PC does take minutes of processing time for adding a single column to an empty MySQL table while my Mac Book did that in under one second. But more on this later. For the beginning, I will show you how to add columns to a table the …

Increase speed of MySQL Database with Indexing

Today we will discuss how to improve the performance of a MySQL data table. If your table contains just a few thousand values you might not see your performance increasing drastically but if you store millions of variables you will be very satisfied with the rapid performance of your database! First, you have to know, …

How to develop on Raspberry Pi using PyCharm

In this short tutorial, I will show you how I setup my development environment for programming with Python on a Raspberry Pi. Maybe you are familiar with some issues when you want to program on your Raspberry. Your first approach might be coding on the Raspberry Pi itself. Because of a lack of speed and nice …

Very first steps with MySQL from Unix command line

In this diary entry I will give especially you but me a short overview how to install and setup a MySQL Server. These steps will work for Debian. Following tasks will be discussed: Download and Install MySQL Server Set a password for root (if not already happened) Create a new database Create the very first table …