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?