• Warning: (): Access denied for user 'root'@'localhost' (using password: YES) in /home/wwwroot/xxxx.php复制代码百度到一般都是这个答案- 方法一:
  • # /etc/init.d/mysql stop
  • # mysqld_safe --user=mysql --skip-grant-tables --skip-networking &
  • # mysql -u root mysql
  • mysql> UPDATE user SET Password=PASSWORD(’newpassword’) where USER=’root’;
  • mysql> FLUSH PRIVILEGES;
  • mysql> quit
  • # /etc/init.d/mysql restart
  • # mysql -uroot -p
  • Enter password:
  • mysql>
  • 方法二:
  • 直接使用/etc/mysql/debian.cnf文件中节提供的用户名和密码:
  • # mysql -udebian-sys-maint -p
  • Enter password:
  • mysql> UPDATE user SET Password=PASSWORD(’newpassword’) where USER=’root’;
  • mysql> FLUSH PRIVILEGES;
  • mysql> quit
  • # mysql -uroot -p
  • Enter password:
  • mysql> 复制代码可是完全不给力啊

![](002.gif)