ubuntu: gedit editor plugins

Install Gmate in Ubuntu. GMate is a collection of plugins, themes/styles and other improvements to get TextMate-like features in Gedit. Type the following commands to install Gmate.

sudo apt-add-repository ppa:ubuntu-on-rails/ppa
sudo apt-get update
sudo apt-get install gedit-gmate

When you are finished open your a .html.erb you will see syntax highlighted!  

Generate ssh key pair with using email

ssh-keygen -t rsa -C "you@example.com"

ref : http://www.maketecheasier.com/knowing-linux-system-via-the-command-line/

MySQL Create Database with UTF8 Character Set

CREATE DATABASE `database_name` CHARACTER SET utf8 COLLATE utf8_general_ci;
GRANT ALL ON `database_name`.* TO `username`@localhost IDENTIFIED BY 'password';
FLUSH PRIVILEGES;

Alternate option by using 'CREATE SCHEMA'

CREATE SCHEMA `database_name` CHARACTER SET utf8 COLLATE utf8_general_ci;
GRANT ALL ON `database_name`.* TO `username`@localhost IDENTIFIED BY 'password';
FLUSH PRIVILEGES;