set utf8

When using Mysqlbinlog to analyze logs, error:/usr/local/mysql/bin/mysqlbinlog:unknown variable ' Default-character-set=utf8 'Cause Analysis:The reason for this problem is that I added it in the Client option group in MY.CNF:

Mysqld: unknownvariabledefault-character-setutf8 solutions have a need for friends can refer. Mysqld: unknown variable default-character-set = utf8. If you need a solution, refer to it. When using mysql5.5, follow the previous 5.1 Method to

MySQL Chinese garbled solution: the MySQL database encoding unified UTF8To view the database encoding:Show variables like ' character%

In the afternoon when troubleshooting MySQL master-slave synchronization problem, want to find some clues from the main library binlog, the bare binlog file is unable to look directly, mysqlbinlog This tool is used to view the contents of Binlog

When you modify the character set of MySQL, in order to set the default character set to Utf-8, you add a line Default-character-set=utf8 under/etc/my.cnf [mysqld].But the next time you start the system, MySQL login is not, error can ' t connect to

When using mysql5.5, modify the my.cnf file according to the previous 5.1 method, but the following error event type is prompted: ErrorEvent Source: MySQLEvent Type: NoneEvent id:100Date: 2012-11-14Event: 12:00:12Users: N/AComputer:

Mysqlbinlog mysql-bin.000036 | LessQuery A statement that contains several fields: Mysqlbinlog mysql-bin.000036| Egrep ' (2011030610002460|2011030310001730|2011030410011680|2011030410006280) ' Mysqlbinlog Viewing binary log

Mysqlbinlog view binlog log times wrong unknown variable ' Default-character-set=utf8 ' When you export a SQL file by using a full file and an incremental binlog file to restore the full database. Since the bare binlog file cannot be looked directly

MySQL under the Windows system:1. Locate the MySQL profile: The file name may not be my.ini (such as My-default.ini) and modified to My.ini.Open the configuration file and edit it as follows: (if no [client] is added)3. Restart the MySQL server,

MySQL-server-5.5.11 is installed through RPM package, directly input service MySQL start on the command line, MySQL started successfully, Then modify/etc/My. CNF, add default-character-set = utf8 to [mysqld], and restart the MySQL service. An

1. After modifying my.cnf, perform service mysql restart Restart database failed service MySQL restartshutting down MySQL. SUCCESS! starting MySQL ... error! The server quit without updating PID file (/usr/local/mysql/data/vm_0_12_centos.pid)2.

To see how to solve the garbled problem:In MySQL, the default character set is Latin1,If you want to set the character set to Uft-8, you can add the following settings in the My.cnf

UTF8 is a three-byte character, and the Emoj expression is a four-sub-section, so you need to change the character set to UTF8MB4. The latter is compatible with UTF8.For production libraries with existing data, the change process is as follows:

1. create the test table createtablesselect * frommysql on the source side. user; 2. source to view the test table creation statement showcreatetables; EOFCREATETABLE's '('host' char (60) CHARACTERSETutf8COLLATEutf8_binNOTNULLDEFAULT, 'user' char (16

1. Create a test table on the source sideCreate table s select * from mysql. user;2. view the table creation statement of the test table on the source side.Show create table s;Create table's '('Host' char (60) character set utf8 COLLATE utf8_bin not

Mysql>show engines;+--------------------+---------+----------------------------------------------------------------+-------------- +------+------------+| Engine | Support | Comment | Transactions | XA | savepoints |+--------------------+---------+---

The database is almost a right-hand person for the service-side developer. Almost every server-side developer has to deal with the database. and MySQL with its open source free, small and easy to use, powerful function of the Chinese database to

TestUnlock the main MySQL first> unlock tables;Delete a table> Use db1; > show tables; > drop table help_category;Go and see it from MySQL.> Use db1; > Show tables;No help_category.///////////////////////////////////////////////////////////////////

One, character set and validation rulesA character set is a set of conformance and encoding, a set of rules that are used to compare characters within a character set, that is, the collation of a character set. MySQL can use the pair of character

MySQL innodb_table_stats table does not exist MySQL version 5.6.14 The company's error logs for several MySQL servers show that several system tables do not