- WAKAKA2010-12-23论坛元老1152
- 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> 复制代码可是完全不给力啊
