本地连接MYSQL:1045 mysql Access denied for user [email protected]

今天突然想连本地,发现这个错误。哈哈哈

本地连接MYSQL:1045 mysql Access denied for user [email protected]

1.找到MYSQL文件夹

我的路径:C:\Program Files\MySQL\MySQL Server 5.5

2.打开my.ini在[mysqld]下一行,填入skip_grant_tables

本地连接MYSQL:1045 mysql Access denied for user [email protected]

3.重启sql,打开cmd,net stop mysql,net start mysql

net stop mysql
net start mysql

4.进入mysql:mysql -uroot -p

本地连接MYSQL:1045 mysql Access denied for user [email protected]

5.use mysql

本地连接MYSQL:1045 mysql Access denied for user [email protected]

6.update user set authentication_string=password('newpassword') where user='root';

7.flush privileges;

本地连接MYSQL:1045 mysql Access denied for user [email protected]

至此,就是重置密码的步骤。解决这个问题。

mysql 安装默认密码是root