CHEAT SHEETS

Basic combination of styles to achieve dots when text is overflowing container:

    .container {
        text-overflow: ellipsis;
        overflow: hidden;
        white-space: nowrap;
    }

Reference: http://www.blakems.com/archives/000077.html

/* This parent can be any width and height */
.block {
  text-align: center;
}

/* The ghost, nudged to maintain perfect centering */
.block:before {
  content: '';
  display: inline-block;
  height: 100%;
  vertical-align: middle;
  margin-right: -0.25em; /* Adjusts for spacing */
}

/* The element to be centered, can
   also be of any width and height */ 
.centered {
  display: inline-block;
  vertical-align: middle;
  width: 300px;
}

Source reference: css-tricks.com/centering-in-the-unknown/

Locate your my.cnf and make sure that skip-networking is commented and that bind-address is your servers IP. Here is an example:

[mysqld]
user            = mysql
pid-file        = /var/run/mysqld/mysqld.pid
socket          = /var/run/mysqld/mysqld.sock
port            = 3306
basedir         = /usr
datadir         = /var/lib/mysql
tmpdir          = /tmp
language        = /usr/share/mysql/English
bind-address    = 65.55.55.2


skip-networking

If you made any changes, make sure you restart the mysql service before you continue.

$ /etc/init.d/mysql restart

Start a console for mysql

$ mysql -u root -p password

Input the following commands to first create the database (only if it does not already exist) and then to grant the preferred user access to the database:

mysql> CREATE DATABASE my_database;
mysql> GRANT ALL ON my_database.* TO my_user@'33.33.33.1' IDENTIFIED BY 'my_password';

33.33.33.1 in this case is the IP address used when my computer connects to my Vagrant box. You can also grant access on all databases by writing:

mysql> GRANT ALL ON *.* TO ....

More details can be found at cyberciti

Date (Year, Month, Day): %Y - Year with century (can be negative, 4 digits at least) -0001, 0000, 1995, 2009, 14292, etc. %C - year / 100 (round down. 20 in 2009) %y - year % 100 (00..99)

%m - Month of the year, zero-padded (01..12) %_m blank-padded ( 1..12) %-m no-padded (1..12) %B - The full month name (January'') %^B uppercased (JANUARY'') %b - The abbreviated month name (Jan'') %^b uppercased (JAN'') %h - Equivalent to %b

%d - Day of the month, zero-padded (01..31) %-d no-padded (1..31) %e - Day of the month, blank-padded ( 1..31)

%j - Day of the year (001..366)

Time (Hour, Minute, Second, Subsecond): %H - Hour of the day, 24-hour clock, zero-padded (00..23) %k - Hour of the day, 24-hour clock, blank-padded ( 0..23) %I - Hour of the day, 12-hour clock, zero-padded (01..12) %l - Hour of the day, 12-hour clock, blank-padded ( 1..12) %P - Meridian indicator, lowercase (am'' orpm'') %p - Meridian indicator, uppercase (AM'' orPM'')

%M - Minute of the hour (00..59)

%S - Second of the minute (00..60)

%L - Millisecond of the second (000..999) %N - Fractional seconds digits, default is 9 digits (nanosecond) %3N millisecond (3 digits) %6N microsecond (6 digits) %9N nanosecond (9 digits) %12N picosecond (12 digits)

Time zone: %z - Time zone as hour and minute offset from UTC (e.g. +0900) %:z - hour and minute offset from UTC with a colon (e.g. +09:00) %::z - hour, minute and second offset from UTC (e.g. +09:00:00) %Z - Time zone abbreviation name

Weekday: %A - The full weekday name (Sunday'') %^A uppercased (SUNDAY'') %a - The abbreviated name (Sun'') %^a uppercased (SUN'') %u - Day of the week (Monday is 1, 1..7) %w - Day of the week (Sunday is 0, 0..6)

ISO 8601 week-based year and week number: The week 1 of YYYY starts with a Monday and includes YYYY-01-04. The days in the year before the first week are in the last week of the previous year. %G - The week-based year %g - The last 2 digits of the week-based year (00..99) %V - Week number of the week-based year (01..53)

Week number: The week 1 of YYYY starts with a Sunday or Monday (according to %U or %W). The days in the year before the first week are in week 0. %U - Week number of the year. The week starts with Sunday. (00..53) %W - Week number of the year. The week starts with Monday. (00..53)

Seconds since the Epoch: %s - Number of seconds since 1970-01-01 00:00:00 UTC.

Literal string: %n - Newline character (\n) %t - Tab character (\t) %% - Literal ``%'' character

Combination: %c - date and time (%a %b %e %T %Y) %D - Date (%m/%d/%y) %F - The ISO 8601 date format (%Y-%m-%d) %v - VMS date (%e-%^b-%4Y) %x - Same as %D %X - Same as %T %r - 12-hour time (%I:%M:%S %p) %R - 24-hour time (%H:%M) %T - 24-hour time (%H:%M:%S)