My Sql Most of them are in green ( Decompression version ) Then sign up for the service Easy and convenient .

however . Configuration file is a headache .

First configuration mysql Environment variables of .

mySQL environment variable ( My computer - Right click properties - senior - environment variable )

MYSQL_HOME( Decompression path ):E:\MYSQL\mysql-5.6.23-winx64

path: Add... At the end ;%MYSQL_HOME%\bin Pay attention to the semicolon

No environment variables CMD It's not an internal or external command .

It's for the owner .5.6.23 edition .

my-default.ini The contents are as follows

[mysqld]
#skip-grant-tables This can be root Login with forgotten password mysql Very low security .

# port
port=3306

# In some cases default-character-set=utf8 Can solve the problem of Chinese garbled

# Don't use it here default-character-set=utf8 Will report directly to 1067 error

character-set-server=utf8

 

# Pay attention to whether this should be added or not client database results  All are GBK or latin1

init_connect='SET NAMES utf8' 

#show variables like 'char%'; Look at the database code set

# Database storage engine Some versions  default-storage-engine=MyISAM Will start normally Otherwise it will be reported 1067 

default-storage-engine=INNODB

# Set up basedir Point to mysql Installation path for
basedir=E:\MYSQL\mysql-5.6.23-winx64
datadir=E:\MYSQL\mysql-5.6.23-winx64\data

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

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

------------------------------------------------------------------------------- Don't copy this line

Basically, there is no garbled code problem .

Get into mysq...bin\ Run as an administrator

Specify profile , Add service

mysqld  --install MySQL --defaults-file="E:\MYSQL\mysql-5.6.23-winx64\my-default.ini"

start-up mysql

net start mysql

mysql -u root -p The default is empty.

Use Navicat for MySQL Join database .

Registration code :NAVH-WK6A-DMVK-DKW3

Switch to use mysql

select * from mysql.user;

You'll see similar records

You can get in without a password . Kill first localhost The first 4 Bar record .( Anonymous logins )

If you don't change the table . There will be the following picture

Delete paragraph 4 After .

It's time to verify . Prompt for user name

Remember my-default.ini Of skip-grant-tables Don't drive .

modify 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";

Close test available . Restart the service

When you log in . It's about the password

Enter the just 111 Just the password .

Be careful :

If you use cmd Please login in the following format

mysql -u root -p111

Remember not to use :

mysql -u root -p 111

Otherwise it will prompt :

Here we go first . Coding problem Installation services , The password problem has been solved .

I hope I can help my friends in need . It's really a headache if we don't solve the coding problem .chinese

1067 chart .                         

If the relevant properties have been configured before . Please put mysql-data- All the following non folder files will be deleted . Start it up

The End...

My Sql 1067 Error and coding problem solving more related articles

  1. java project Deposit in mysql after Change question mark MySql 5.6 (X64) Decompression version 1067 Solutions to errors and coding problems

    [ Reference resources ]MySQL 5.7.19 Forget the password Reset password my.ini Example Stop after service start Environmental Science Java Environmental Science JDK1.8   installed  mysql-5.6.38-winx64  idea2016(64) ...

  2. [ Reprint ]MySQL5.5 The configuration file my.ini 1067 error

    Link to the original text :http://blog.csdn.net/xiaochunyong/article/details/7438200 decompression mysql-5.5.22-win32.zip In the following table of contents are 5 individual my-xx ...

  3. MYSQL Startup Report 1067 error , In the system log is “ service mysql The accident stopped ” Mysql In the journal, it's :“Plugin \'FEDERATED\' is disabled”

    MYSQL Startup Report 1067 error , In the system log is " service mysql The accident stopped " Mysql In the journal, it's :"Plugin \'FEDERATED\' is disabled&quo ...

  4. Plugin 'FEDERATED' is disabled or 1067 error Startup error and “ service mysql The accident stopped ” resolvent

    MYSQL Startup Report 1067 error , In the system log is “ service mysql The accident stopped ” Mysql In the journal, it's :“Plugin 'FEDERATED' is disabled” I found a solution on the Internet :1. stay MY.I ...

  5. mysql Of 1067 error - 2

    Last blog post <mysql Of 1067 error > Due to the log configuration problem in 1067 error . Due to upgrade MySQL To V5.6, So copy my.ini And data files to the new system . When starting the service , Again 1067 error ! ...

  6. Batch command -- Configure install free mysql 5.6.22, as well as 1067 A solution to the mistake

    mysql Service startup appears 1067 A solution to the mistake : When the service starts 1067 When it's wrong , You can see “windows Event viewer ”, Found similar error prompt Can't find messagefile 'F:\    ...

  7. solve mysql Start failure report 1067 error

    Recently do project use mysql database , Because of unloading Master Lu, the database file is missing . reinstall mysql After starting the database, it appears 1067 error , Details are as follows I checked the cause of the mistake on the Internet , take my.ini The default search engine under the file is changed to  myi ...

  8. Oracle Error summary and problem solving ORA

    Reference address ORA-00001: Violate the only constraint (.) Mistakes show : When you type a duplicate value on the column corresponding to the unique index , This exception is triggered .ORA-00017: Request session to set trace events ORA-00018: Exceeded the maximum number of sessions O ...

  9. start-up mysql appear 1067 error

    0.  open mysql\bin\my.ini, lookup [mysqld], stay [mysqld] Add a line below ,skip-grant-tables I.e. composition [mysqld] skip-grant-tables[ ...

Random recommendation

  1. Here's an Android version for you easyradius SMS prompt client

    It's like Mu you wrote a blog , Send you a small software , It will be updated later It is mainly convenient for some users who use their mobile phones to send expired short messages to users Download address : http://www.yss58.com/yss58

  2. ( turn ) Voting system , change ip Brush ticket

    Preface I believe you will receive the link from your friends , Open it up , Oh , Need to vote . After voting, a page pops up ( Congratulations , You have voted ), When I click again, I find , Ah , Your IP(***.***.***.***) I've already voted , No ...

  3. C# Ini The configuration file

    public class INIUserAccound { static IniFile Ini = new IniFile(AppDomain.CurrentDomain.BaseDirectory ...

  4. etrace track nginx And HTTP Request flow

    curl 127.0.0.1 | | | \--ngx_epoll_process_events | | | | \--ngx_time_update | | | | | \--ngx_gmtime ...

  5. Java Class loading principle analysis

    See :http://blog.yemou.net/article/query/info/tytfjhfascvhzxcyt229 2       Java The structure of virtual machine class loader 2.1    JVM 3、 ... and ...

  6. HTTP Protocol literacy ( Two )HTTP The request method of the protocol 、 Request headers and response headers

    One .HTTP Request method Http The protocol defines many ways to interact with the server , The most basic ones are 4 Kind of , Namely GET,POST,PUT,DELETE. One URL Address is used to describe resources on a network , and HTTP Medium GET, POST ...

  7. elasticsearch health yellow

    csdn Blog address ( It has been tested ):https://blog.csdn.net/yangyangrenren/article/details/81100836 Official address :https://www.elasti ...

  8. vue-cli webpack elementary analysis

    I've been working on scaffolding webpack I'm interested in configuration . Cut a long story short , First from npm start Start . open package.json find scripts You can see start Running dev, dev Again from build/ ...

  9. window.location API

    summary I despised myself today , I can't use it window.location.search Page value transfer . Now to sum up window.location API, Record it for reference in future development , I believe it works for others . Page pass ...

  10. Infinite classification mysql Design