Connect Google Cloud SQL with MySQL Workbench

This post will show you how to create a Google Cloud SQL instance and connect your Google Cloud SQL instance database with MySQL Workbench. Before connecting, make sure you have enabled billing for Google Cloud Engine.

Creating a Google Cloud SQL instance

  1. Go to the Google Cloud Console.
  2. Create a new Cloud Console project, or open an existing project.
  3. In the sidebar on the left, select Cloud SQL to open the Cloud SQL control panel for the project.
  4. Click New Instance to create a new Cloud SQL instance in your project.
  5. Enter a name for the instance. The instance name will be automatically combined with your project name, and any domain-specific names as shown here: Continue reading Connect Google Cloud SQL with MySQL Workbench

How to check whether an array is a sub array of another array in Javascript

Below code snippet can be used to find whether an array is a sub array of another array in JavaScript

Results :

 

Installing Zend Guard on Linux distributions (Centos 6, Debian, Ubuntu)

Zend Optimizer is a PHP extension and can be used to run PHP scripts that are encoded with Zend Guard. Zend Optimizer is compatible with PHP 5.2. If you are running PHP 5.3 or above you should use Zend Guard, which is an analogue of Zend Optimizer. In this article I will go through the steps you need to follow when installing Zend Guard on popular Linux distributions like Centos 6, Debian, Ubuntu.

1. First you need to know the linux distribution, it’s architecture, and the PHP version you are using.

  • To find the linux distribution, type cat /etc/issue in terminal.
  • To find the¬†architecture of your system, type uname -a in terminal.
  • To find the php version, type php -v in terminal.

2. Download the appropriate Zend Gard

  • For 32-bit operating systems :
  • ¬†For 64-bit operating systems :

Continue reading Installing Zend Guard on Linux distributions (Centos 6, Debian, Ubuntu)

Quick fix for skype not opening in Ubuntu 13.04

This is a quick fix for a little bug which occurs when using Skype + Ubuntu 13.04 X64 (bug #1097773).

Bug details : Even if you have installed Skype in your Ubuntu machine Skype won’t start up. Instead of starting up properly it will ends up with a crash saying

or

or

If you comes up with this error, Continue reading Quick fix for skype not opening in Ubuntu 13.04

How to install Eclipse Juno in Ubuntu 13.04?

**This tutorial can be used to install Eclipse in any Ubuntu version.**

Basically there are two methods to install eclipse IDE in Ubuntu.
1. Using Ubuntu Software Center
2. Download Eclipse IDE package and then install manually (personally recommended)

Personally I prefer to use the second method. Because If you chose the first method and if you need to install Eclipse IDE on multiple Ubuntu machines, You will have to download Eclipse IDE on each and every machine. That will cost bandwith as well as time. Therefore, in this tutorial I’m only going to show the second method.

In order to do this first you need to make sure that you have Java installed. To check that you can type

in the terminal and it will give you the current java version installed on your computer. If you do not have Java installed on your computer please follow Install JDK on Ubuntu tutorial in order to install Java.

Steps :

Continue reading How to install Eclipse Juno in Ubuntu 13.04?