MySQL-related issues

1,mysql Chinese display as? Solutions

Show variables like ' character_set_% ';

Show variables like ' collation_% ';

Character_set_database and Character_set_server should be utf8_general_ci for Utf8,collation_database and Collation_server.

If not, you need to modify/ETC/MY.CNF

First close the database and disconnect the database service

/etc/init.d/mysqld stop

Service Mysqld Stop

After opening my.cnf, add the following two lines of settings under [mysqld] within the file:

Charcter_set_server=utf8

init_connect= ' SET NAMES UTF8 '

Save exit

Restarting the database service

/etc/init.d/mysqld start

Service mysqld Start

2,

Modifying the database encoding format

ALTER DATABASE < databases name > character set UTF8;

Modify the data table encoding format

ALTER TABLE < table name > character set UTF8;

Modify field encoding format

ALTER TABLE < table name > change < Field name > < Field name > < type > Character set UTF8;

For example: ALTER TABLE user change username username text character set UTF8 NOT null;

3,

Establishing SSL connection without server ' s identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must is established by default if explicit Opti On isn ' t set. For compliance with existing applications not using SSL, the Verifyservercertificate property was set to ' false '. You need either to explicitly disable SSL by setting Usessl=false, or set usessl=true and provide truststore for server CE Rtificate verification.

View Sql_mode

SELECT @ @sql_mode

Remove the only_full_group_by and reset the value.

Set GLOBAL sql_mode =' Strict_trans_tables,no_zero_in_date,no_zero_date,error_for_division_by_zero,no_auto _create_user,no_engine_substitution ';

4,

Error code:1175. You is using Safe update mode and you tried to update a table without a WHERE is uses a KEY column to disable safe mode , toggle the option in Preferences, SQL Queries and reconnect

Set sql_safe_updates=0;

MySQL-related issues