I have searched the forum for similar issues
on
This category is for issues regarding specific apps, NOT general issues with YunoHost.
on
This form is written in English 
but feel free to write in French 
if you’re more comfortable!
on
What type of hardware are you using
Virtual machine
What YunoHost version are you running
12.0.0
What app is this about
PHPBB
Describe your issue
I have just installed Yunohost on my VPS/VM. I have also installed PHPBB via the admin interface, which is running fine. Now I want to restore a backup of the mysql db and the files to the YNH. (This backup did not come from a YNH machine).
However, I cannot seem to get proper access to the MySQL DB. When I login with the phpbb user and the password it allows me to log in. But as soon as I put in the following command I get an error: “mysql -u phpbb -p12345 --default-character-set=utf8 /home/username/forum_db_backup.sql” . The error states: “ERROR 1044 (42000): Access denied for user ‘phpbb’@‘localhost’ to database ‘/etc/yunohost/apps/phpbb/forum_db_backup.sql’”.
I have tried granting additional rights to the DB, but think I have failed in that. Can someone help me restore this MySQL DB so that I can get the forum up and running for the users?
Share relevant logs or error messages
ERROR 1044 (42000): Access denied for user ‘phpbb’@‘localhost’ to database '/etc/yunohost/apps/phpbb/forum_db_backup.sql