webdancer's Blog

mysql备份错误的处理

在ubuntu下备份mysql数据库是出现:

mysqldump: Got error: 1045: Access denied for user 'root'@'localhost' (using password: YES) when trying to connect

错误。
解决方法:
重新为root设置密码。记录一下:
  1. mysql -u root -p
  2. mysql> update user set password=password('***') where user='root';
  3. mysql> flush privileges;
  4. sudo service  mysql stop
  5. sudo service  mysql start

这样就可以用:mysqldump 来备份了。

 

ubuntu 10.4倒计时

ubuntu又快有新版本! 

Ubuntu: For Desktops, Servers, Netbooks and in the cloud




Host by is-Programmer.com | Power by Chito 1.3.3 beta | © 2007 LinuxGem | Design by Matthew "Agent Spork" McGee