首先在控制台输入后并报错
mysql -u root -p
Enter password: ***
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
在mysql的bin目录下找到my.ini
添加这一段代码 skip-grant-tables
输入以下语句允许所有用户通过root访问:
grant all privileges on *.* to 'root'@'%' identified by '你的 mysql root 账户密码';
然后查看数据库时出现以下错误:
show databases;
ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.
网上查找的解决方案为:打开sql yog 输入Mysql这一个命令 回车 然后set重置一下密码
mysql> SET PASSWORD = PASSWORD('your new password');