mysql utf8


[mysqld]
default-character-set=utf8
character-set-server=utf8
collation-server=utf8_unicode_ci


[mysql]
default-character-set=utf8


 

fix mysql relay log

• SHOW SLAVE STATUS //note relay_master_log_pos and exec_master_log_pos
• SLAVE STOP
• CHANGE MASTER TO MASTER_LOG_FILE=[relay_master_log_pos value], MASTER_LOG_POS=[exec_master_log_pos]
• SLAVE START

 

mysql command line client prompt

I usually like to change the default mysql client prompt to user@hostname:dbname >. Open my.cnf and replace prompt = “” with

prompt = "\u@\h:\d >"

 

mysql command line autocomplete rescan/enable

mysql>\#

 

Impossible WHERE noticed after reading const tables

MySQL has read all const (and system) tables and notice that the WHERE clause is always false.