mysql 8 修改root 密码
2024-09-28 08:46:19
主要参考: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 保存文本格式事件添加字符的原因。
最新文章
- mybatis plugins实现项目【全局】读写分离
- 使用xUnit,EF,Effort和ABP进行单元测试(C#)
- cocos2d中的可见性检测
- CSSの神小结-简单备忘一下(亲测可用)
- Oracle导入excel数据方法汇总[转]
- 添加 SecondaryNameNode
- java poi出excel换行问题
- 只需三步:使用C# 操作 Azure 队列
- Objective-C发展历史
- iOS_25彩票_幸运转盘
- Jquery 获取上传文件大小
- NextCloud前端支持播放mov文件
- Snagit for mac(截图软件)中文版,截个图就是这么容易!
- 64位 windows2008 R2 上安装32位oracle 10g 的方法
- 记录一个简单的dbcp数据连接池
- Linux内核驱动之GPIO子系统(一)GPIO的使用【转】
- X分钟速成Python
- set集合的遍历(基于迭代器和增强for循环,没有一般的for循环)
- VC++ 定制应用程序的外观
- 使用递归计算n的阶乘n!