Linux modified MYQL encoding configuration and other information reference

MySQL configuration:

1: Edit the configuration file;

Vi/etc/my.cnf

2: Modify the configuration as follows;

[Client]

Password = 123456

Port = 3306

Default-character-set=utf8

[Mysqld]

Port = 3306

Character_set_server=utf8

Character_set_client=utf8

Collation-server=utf8_general_ci

# (Note that Linux is the default after MySQL is installed: Table names are case-sensitive, column names are case-insensitive; 0: Case sensitive, 1: case insensitive)

Lower_case_table_names=1

# (Set the maximum number of connections, default is the maximum number of connections allowed for the 151,MYSQL server 16384;)

max_connections=1000

[MySQL]

Default-character-set = UTF8

Socket =/var/lib/mysql/mysql.sock

Linux modified MYQL encoding configuration and other information reference