I am using fullbackup4.sh to backup both www/mysql openemr ( backup.pgp/bckup.pgp), I created the encryption key and .gnupg is in both /root/ , /home/openemr directories
I was able to decrypt and untar backup.pgp and the directory is there .
was able to decrypt ( no need to untar mysql file) bckup.pgp , it overwrites outpufilename using the key phrase successfully.
When trying to restore database:
mysql -h localhost -p openemr < outputfilename
it asks for password.
in the new machine I am restoring to I tried in mysql the user password , root password, key password, always I get:
ERROR 1045 (28000): Access denied for user ‘mohammad’@‘localhost’ (using password: YES)
I’m using OpenEMR version
mohammad is user in mysql.
what I need to do to restore database?