Mysql
误删mysql服务(sc delete mysql)(该版本是MySQL8.0)
参考:https://www.jb51.net/article/26505.htm
Navicat 连接mysql报错:
解决办法:
mysql> alter user 'root'@'localhost' identified with mysql_native_password by '123456';
Query OK, 0 rows affected (0.60 sec)
mysql> flush privileges;
Query OK, 0 rows affected (0.18 sec)
初始化MySQL,并记录生成的用户密码root的随机密码),在命令窗口内输入: mysqld --initialize --console
安装MySQL服务,命令窗口内输入:mysqld --install
启动MySQL服务,命令窗口内输入:net start mysql
记好刚才初始化时生成的用户名和密码
修改密码
在命令窗口内输入:mysql -u root -p
,然后输入刚才生成的密码
在命令窗口内依次输入:
ALTER USER 'root'@'localhost' IDENTIFIED BY 'password' PASSWORD EXPIRE NEVER;
修改加密规则:
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password';
更新一下用户的密码
在命令窗口内输入:FLUSH PRIVILEGES;
刷新权限
在命令窗口内输入:alter user 'root'@'localhost' identified by '123456';
更改root的密码为123456
参考 https://baijiahao.baidu.com/s?id=1670299179953483847&wfr=spider&for=pc