Mysql backup doesn't work on 220.127.116.11 debian Squeeze/Sid
Mysql database backup for customers doesn't work on Debian Squeeze/Sid
in the cron log i get mysqldump: Got error: 1045: Access denied for user 'root'@'localhost' (using password: YES) when trying to connect
the data is correct.
are there any special characters you may not have in mysql password?
if i do
-> mysql -h localhost -u root -p (enter)
-> enter password: (enter the password here)
--> mysql -h localhost -u root -p(password)
i get the following error: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
The mysql root password in that file may not contain any characters that can get interpretde by a shell script. So use only a-z, A-Z 0-9 and _ in the password.
perfect, then i know what the problem is.
Command for those who wants to know to change the root password for mysql:
-> mysqladmin -u root -p'oldpassword' password newpass
|All times are GMT +2. The time now is 10:23.|
Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.