Hello Everyone,
I am trying to use the provided backup.pl script to backup up my OTRS installation on Ubuntu Linux.
The first part of the script works fine, but I get an error during the database dump:
Dump MySQL rdbms ... mysqldump: Got error: 1045: Access denied for user 'otrs'@'localhost' (using password: YES) when trying to connect
I know that the database name, user name and password are stored in Config.pm. However, in Config.pm, it does not actually show the DB password:
$Self->{DatabasePw} = $dbpass;
I think that the problem is that my database password uses special characters. I have tried escaping them with a \ and specifying the password in Config.pm, but that doesn't seem to work. I am not sure if it is a problem with my escaping or if it is a function on Config.pm and backup.pl that it won't take a specified password as input.
Can I change the password of the dbuser on this production system in mysql to something that doesn't have special characters? I want to ensure that it will not negatively impact my system if I make the password change.
Best Regards,
Mark Novak