./backup.sh
i am presented with
mysqldump: Got error: 1045: Access denied for user 'root'@'localhost' (using password NO)
Please help me. i have tried a method with the following commands:
/etc/init.d/mysqld stop
mysqld_safe --skip-grant-tables &
mysql -u root
mysql> use mysql;
mysql> update user set password=PASSWORD("newrootpassword") where User='root';
mysql> flush privileges;
mysql> quit
/etc/init.d/mysqld stop
/etc/init.d/mysqld start
Please Help what should i do. I am using Version 0.8.8a.