Mysql

storage engine;
MyISAM --table lock -- full text index
InnoDB -- transanction --line lock
BDB -- transanction
MEMORY
EXAMPLE
NDB Cluster
ARCHIVE
CSV
BLACKHOLE
FEDERATED

MyISAM;
.MYD data file
.MYI index file
.frm definition file

InnoDB;

 

cmds;
show character set
show collation like 'utf8%'
show variables like 'character_set_server';

unicode;
Universal Multiple-Octet Coded Character Set (UCS)

character set;
server level;
database level;
table level;
field level;

 

 

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

is the mysql service started?