主要参考:https://dev.mysql.com/doc/refman/8.0/en/resetting-permissions.html

需要注意的是创建文件的时候需要保存为 utf-8 无 BOM格式的不然容易报错。

C:\Users\esen>mysqld --defaults-file="C:\ProgramData\MySQL\MySQL Server 8.0\my.ini" --init-file="D:\mysql-inital-file.txt" --console 2018-08-07T08:58:48.796734Z 0 [System] [MY-010910] [Server] C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe: Shutdown complete (mysqld 8.0.11)  MySQL Community Server - GPL.

2018-08-07T08:58:54.366103Z 0 [Warning] [MY-011071] [Server] option 'read_buffer_size': unsigned value 0 adjusted to 8192
2018-08-07T08:58:54.366135Z 0 [Warning] [MY-011071] [Server] option 'read_rnd_buffer_size': unsigned value 0 adjusted to 1
2018-08-07T08:58:54.366184Z 0 [Warning] [MY-010915] [Server] 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release.
2018-08-07T08:58:54.368433Z 0 [System] [MY-010116] [Server] C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe (mysqld 8.0.11) starting as process 7548
2018-08-07T08:58:56.136588Z 0 [ERROR] [MY-011071] [Server] Can't open shared library 'C:\Program Files\MySQL\MySQL Server 8.0\lib\plugin\mysqlx' (errno: 126 找不到指定的模块。)
2018-08-07T08:58:56.139291Z 0 [ERROR] [MY-010736] [Server] Couldn't load plugin named 'mysqlx' with soname 'mysqlx'.
2018-08-07T08:58:57.134929Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2018-08-07T08:58:57.218333Z 6 [ERROR] [MY-011071] [Server] 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '锘緼LTER USER 'root'@'localhost' IDENTIFIED BY 'Rt_Passwd8' ;' at line 1
2018-08-07T08:58:57.223875Z 0 [System] [MY-010931] [Server] C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe: ready for connections. Version: '8.0.11' socket: '' port: 3306 MySQL Community Server - GPL.
2018-08-07T08:59:21.341168Z 0 [System] [MY-013105] [Server] C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe: Normal shutdown.
^C
C:\Users\esen>2018-08-07T08:59:23.713308Z 0 [System] [MY-010910] [Server] C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe: Shutdown complete (mysqld 8.0.11) MySQL Community Server - GPL. C:\Users\esen>

应该是Window 保存文本格式事件添加字符的原因。

最新文章

  1. mybatis plugins实现项目【全局】读写分离
  2. 使用xUnit,EF,Effort和ABP进行单元测试(C#)
  3. cocos2d中的可见性检测
  4. CSSの神小结-简单备忘一下(亲测可用)
  5. Oracle导入excel数据方法汇总[转]
  6. 添加 SecondaryNameNode
  7. java poi出excel换行问题
  8. 只需三步:使用C# 操作 Azure 队列
  9. Objective-C发展历史
  10. iOS_25彩票_幸运转盘
  11. Jquery 获取上传文件大小
  12. NextCloud前端支持播放mov文件
  13. Snagit for mac(截图软件)中文版,截个图就是这么容易!
  14. 64位 windows2008 R2 上安装32位oracle 10g 的方法
  15. 记录一个简单的dbcp数据连接池
  16. Linux内核驱动之GPIO子系统(一)GPIO的使用【转】
  17. X分钟速成Python
  18. set集合的遍历(基于迭代器和增强for循环,没有一般的for循环)
  19. VC++ 定制应用程序的外观
  20. 使用递归计算n的阶乘n!

热门文章

  1. window.location和window.location.href和document.location的关系
  2. Oracle数据库网闸配置注意事项
  3. meta标签使用
  4. WP8.1&UWP手机设备对状态栏操作
  5. pch文件的创建与配置
  6. Harbor安装 -- 企业级Registry仓库
  7. 最长双回文串——manacehr
  8. luogu2480 [SDOI2010]古代猪文
  9. HackerRank - array-partition 并查集
  10. linux查找包含某个字符的文件并导出文件名