Mysql 1067 error and invalid recovery after the character set is modified and restarted, mysql1067

Mysql 1067 error and invalid recovery after the character set is modified and restarted, mysql1067

Download the official website decompress mysql-5.6.37-winx64.zip, modify the configuration file, install the service, and use it directly;

Chinese garbled characters appear. solution:

Under the mysql-5.6.37-winx64 directory, create and configure a new my. ini file (content can be found online, or you can refer to my-default.ini manual configuration)

Note:

[Client] do not make any mistake at the node location, for example:

Error Method:

[mysqld]character-set-server=utf8# Remove leading # and set to the amount of RAM for the most important data# cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.# innodb_buffer_pool_size = 128M[client]default-character-set=utf8# Remove leading # to turn on a very important data integrity option: logging

Ps: the following attributes are under the [mysqld] node. If the [client] node is placed, the attributes of [client] are changed.

Cause the following error: mysql: unknown variable 'basedir = D: \ mysql-5.6.37-winx64'

 basedir = D:\\mysql-5.6.37-winx64 datadir = D:\\mysql_data

The correct method should be to put the [client] node at the end or at the front, instead of in the [mysqld] node. As for the error 1067 when the net start mysql starts mysql service, check the log and find

MySQL: Table 'mysql. plugin 'doesn' t exist2017-10-17 11:40:50 2928 [ERROR] Can't open the mysql. plugin table. please run mysql_upgrade to create it.2017-10-17 11:40:50 2928 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql. user 'doesn' t exist, and finally change datadir = D: \ mysql_data to datadir = D: \ mysql-5.6.37-winx64 \ data

The service has been started (because my. ini has not been created before, and the default configuration is used all the time, so the data location path does not match, just change it)

Summary

The above is a small Editor to introduce you to mysql startup error 1067 and the problem of invalid recovery after restarting the modified character set. I hope to help you. If you have any questions, please leave a message for me, the editor will reply to you in a timely manner. Thank you very much for your support for the help House website!