报错: mysql -u root -p报错:ERROR 1045 (28000): Access denied for user 'root'@'localhost'
解决方法:
①删除data文件内的所有文件
②mysqld --initialize
③net start mysql
MySQL 服务正在启动 …
MySQL 服务已经启动成功。
④mysql -u root -p
Enter password: ************
(冒号后有一个不需要的空格,如A temporary password is generated for root@localhost: w,y7=h4Z<Wy1初始密码是w,y7=h4Z<Wy1)
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 8
Server version: 8.0.13
⑤mysql>alter user 'root'@'localhost' identified by '你的新密码'; (有分号)
Query OK, 0 rows affected (0.69 sec)
不要关闭当前终端,重新开启一个终端运行net start mysql输入你的新密码,如果Welcom,那就成功啦。