2024-04-02T09:43:36.599395Z 0 [System] [MY-010116] [Server] C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe (mysqld 8.0.17) starting as process 12480
2024-04-02T09:43:37.693064Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2024-04-02T09:43:37.707390Z 0 [System] [MY-010931] [Server] C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe: ready for connections. Version: '8.0.17' socket: '' port: 0 MySQL Community Server - GPL.
2024-04-02T09:43:37.872750Z 0 [Warning] [MY-011311] [Server] Plugin mysqlx reported: 'All I/O interfaces are disabled, X Protocol won't be accessible'
复制代码
打开新cmd窗体
打开命令行启动另外一个窗体(win+R)
输入mysql的登录命令,留意不用输密码,直接回车。
mysql -uroot -p
复制代码
修改密码
使用mysql库
use mysql;
置空root的密码
update user set authentication_string='' where user='root';
复制代码
刷新权限
flush privileges;
复制代码
修改密码
IDENTIFIED BY ‘密码’;
ALTER USER 'root'@'localhost' IDENTIFIED BY '123456';