当前位置：网站首页>Solution access denied for user 'root' @ 'localhost' (using password: yes)

Solution access denied for user 'root' @ 'localhost' (using password: yes)

2022-04-22 08:43:00 【Wandering hunter】

  • 1、 find mysql Install under directory my.ini file , Then add a line skip-grant-tables.
  • 2、 Press down win key , Then the input cmd, Right click Run in administrator mode .
  • 3、 Enter the command ：net stop mysql, Stop service first . Then , Input net start mysql Start the service .
  • 4、mysql -uroot -p Back to the car , Then he entered .
  • 5、use mysql choice mysql Its own library , And then execute ,update user set password=PASSWORD(“123456”) where user=‘root’;
  • 6、 After the above operations are successful , find mysql Install under directory my.ini file , Then delete skip-grant-tables.
  • 7、 After the above operation is completed , Enter the command ：net stop mysql, Stop service first . Then , Input net start mysql Start the service .

版权声明
本文为[Wandering hunter]所创，转载请带上原文链接，感谢
https://yzsam.com/2022/04/202204220744582296.html

边栏推荐

猜你喜欢

随机推荐