mysql cheat sheet

backup

$ mysqldump -u USER -p --opt DBNAME --net_buffer_length=8000 | gzip > GZIPFILE

初期設定

skip-character-set-client-handshake
character-set-server   = utf8
default-storage-engine = InnoDB
collation-server       = utf8_general_ci
innodb_file_format     = Barracuda
innodb_file_per_table  = 1
innodb_user_sys_malloc = 0

$ mysql_secure_installation

ユーザ追加

> grant all privileges on dbname.* to uname@localhost;
> flush privileges;