My Sql 1067 error and encoding problem solution

My Sql mostly uses the green version (decompressed version) and then registering the service is simple and convenient.

But. The configuration file is a headache.

First configure the environment variables of mysql.

mySQL environment variables (My Computer-right-click Properties-Advanced-Environment Variables)

MYSQL_HOME (unzip path): E: MYSQLmysql-5.6.23-winx64

path: add;%MYSQL_HOME%bin at the end Note When the semicolon

is not added to the environment variable CMD, it will remind you that it is not an internal or external command.

It is used by the original poster. Version 5.6.23.

my-default.ini content is as follows

[mysqld]
#skip-grant-tables This can be used to log in to mysql if the root password is forgotten. The security is extremely low.

#Port
port=3306

#In some versions, default-character-set=utf8 can solve the problem of Chinese garbled characters

#Do not use default-character-set=utf8 here, it will directly report a 1067 error

character -set-server=utf8

#Note that this must be added or not. Client database results are all GBK or latin1

init_connect='SET NAMES utf8'

#show variables like 'char%'; View database encoding set

#Some versions of database storage engine default-storage-engine=MyISAM will start normally, otherwise it will report 1067

default-storage-engine=INNODB

#Set basedir to point to the installation path of mysql
basedir=E:MYSQLmysql- 5.6.23-winx64
datadir=E:MYSQLmysql-5.6.23-winx64data

[client]
default-character-set=utf8
#password =1234
port=3306

[mysql]
port=3306
default-character-set=utf8

Basically there is no garbled code problem.

Enter mysq...bin and run as administrator

Specify the configuration file and add services

mysqld --install MySQL --defaults-file="E:MYSQLmysql-5.6.23-winx64my-default.ini"

Start mysql

net start mysql

mysql -u root -p is empty by default

Use Navicat for MySQL to connect to the database.

Registration code: NAVH-WK6A-DMVK-DKW3

Switch to use mysql

select * from mysql.user;

You will see similar records

You can enter without a password. First get rid of the 4th record of localhost. (Anonymous login)

If you don’t change the table. There will be a situation like the picture below

After deleting the 4th article.

Verification is required at this time. Prompt to enter user name

Remember not to enable skip-grant-tables in my-default.ini.

Modify the root default password (switch to the root directory)

1.set password for root@localhost = password('111');

2.update user set password=password("111") where user="root ";

Personal testing is available. Restart the service

when logging in at this time. The password is required

Just enter the 111 password just now.

Note:

If you use cmd to log in, please use the following format to log in

mysql -u root -p111

Remember not to use:

mysql -u root -p 111

Otherwise you will be prompted:

First Here it is. Encoding issues, installation services, and password issues have all been resolved.

Hope it can help friends in need. Coding problems are really a headache if they are not solved. chinese

If the relevant attributes have been configured before. Please delete all non-folder files under mysql-data-. Just start it

The End...