Common MySQL settings: character set encoding, Automatic completion (automatic prompt), and monitoring of Internet IP addresses

Set the MySQL listening Internet IP Address

 

 
Sudo VI/etc/My. cnfbind-address = 127.0.0.1
 

Set MySQL Character Set charset

Sudo VI/etc/My. CNF adds a line of character_set_server = utf8 under [mysqld] and a line of default-character-set = utf8sudo/usr/local/MySQL/support-files/MySQL under [MySQL. server restartmysql-uroot-p1mysql> statusserver characterset: utf8db characterset: utf8client characterset: utf8conn. characterset: utf8mysql> show variables like 'character _ set % '; + bytes + | variable_name | value | + bytes + | character_set_client | utf8 | character_set_connection | utf8 | character_set_database | utf8 | bytes | binary | utf8 | | character_set_server | utf8 | character_set_system | utf8 | character_sets_dir |/usr/local/MySQL/share/charsets/| + rows + 8 rows in SET (0.00 Sec)

MySQL automatic prompt, command automatic completion, syntax prompt

 
Sudo VI/etc/My. CNF: Find [MySQL] [MySQL] # No-auto-rehashauto-rehashsudo/usr/local/MySQL/support-files/MySQL. server restartmysql-uroot-p1use MySQL must first use a database and press the tab key to automatically prompt.
 

Note: previously writtenArticleIt's too long, there are duplicates, it's against dry, and now it's sorted out.