Windows环境下报错:
ERROR 1045 (28000): Access denied for user ‘root’@‘localhost’ (using password: YES)
解决方式:
1、MySQL安装目录下找到my.ini文件,在[mysqid]下添加skip-grant-tables后保存退出
skip-grant-tables
2、重启MySQL
net stop mysql
net start mysql
mysql -u root -p
当弹出Enter password时直接回车,因为skip-grant-tables直接跳过了登录权限