http://dev.mysql.com/doc/refman/5.5/en/charset-server.html
http://dev.mysql.com/doc/refman/5.5/en/innodb-default-se.html
http://dev.mysql.com/doc/refman/5.5/en/innodb-multiple-tablespaces.html
http://dev.mysql.com/doc/refman/5.5/en/innodb-default-se.html
http://dev.mysql.com/doc/refman/5.5/en/innodb-multiple-tablespaces.html
mysql my.cnf
mysql my.cnf can be found in /etc/my.cnfmysql my.cnf old passwords
you can/should disable old passwords by commenting out the old_passwords configuration option[mysqld] # Default to using old password format for compatibility with mysql 3.x # clients (those using the mysqlclient10 compatibility package). # old_passwords=1
mysql my.cnf character set and character collation
To select a character set and character collation at server startup in an option file include these lines:[mysqld] character-set-server=utf8 collation-server=utf8_general_ci
mysql my.cnf innodb defaults
To make innodb the default engine and use a separate file for each table add[mysqld] default-storage-engine=innodb innodb_file_per_table
REFERRERS
MySql
