# Import PBPBB database backup: no access? **URL:** \ **Category:** Support apps\ **Tags:** phpbb, mysql, english\ **Created:** [March 11, 2025, 9:09am UTC](https://forum.yunohost.org/t/import-pbpbb-database-backup-no-access/35868 "2025-03-11T09:09:05Z")\ **Posts on this page:** 10\ **Page:** 1
**Author:** ![Mecallie](https://forum.yunohost.org/letter_avatar_proxy/v4/letter/m/9dc877/32.png) [@Mecallie](https://forum.yunohost.org/u/Mecallie)\ **Post date:** [March 11, 2025, 9:09am UTC](https://forum.yunohost.org/t/import-pbpbb-database-backup-no-access/35868/1 "2025-03-11T09:09:05Z")
### 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 ---
**Author:** ![Mecallie](https://forum.yunohost.org/letter_avatar_proxy/v4/letter/m/9dc877/32.png) [@Mecallie](https://forum.yunohost.org/u/Mecallie)\ **Post date:** [March 20, 2025, 5:50pm UTC](https://forum.yunohost.org/t/import-pbpbb-database-backup-no-access/35868/2 "2025-03-20T17:50:56Z")
No one that can help with this issue? I think it probably is not even phpbb specific, it is just a matter of getting the correct rights to the MySQL DB? ---
**Author:** ![jarod5001](https://forum.yunohost.org/user_avatar/forum.yunohost.org/jarod5001/32/5323_2.png) [@jarod5001](https://forum.yunohost.org/u/jarod5001)\ **Post date:** [March 20, 2025, 7:06pm UTC](https://forum.yunohost.org/t/import-pbpbb-database-backup-no-access/35868/3 "2025-03-20T19:06:58Z")
Install phpmyadmin and import the database to the right one ---
**Author:** ![Mecallie](https://forum.yunohost.org/letter_avatar_proxy/v4/letter/m/9dc877/32.png) [@Mecallie](https://forum.yunohost.org/u/Mecallie)\ **Post date:** [March 20, 2025, 8:13pm UTC](https://forum.yunohost.org/t/import-pbpbb-database-backup-no-access/35868/4 "2025-03-20T20:13:36Z")
Can’t DB is to large for that. I think the DB is about 600MB. ---
**Author:** ![jarod5001](https://forum.yunohost.org/user_avatar/forum.yunohost.org/jarod5001/32/5323_2.png) [@jarod5001](https://forum.yunohost.org/u/jarod5001)\ **Post date:** [March 20, 2025, 8:34pm UTC](https://forum.yunohost.org/t/import-pbpbb-database-backup-no-access/35868/5 "2025-03-20T20:34:48Z")
If you’re looking for the db credentials you can find them in /etc/yunohost/apps/phpbb/settings.yml ---
**Author:** ![Mecallie](https://forum.yunohost.org/letter_avatar_proxy/v4/letter/m/9dc877/32.png) [@Mecallie](https://forum.yunohost.org/u/Mecallie)\ **Post date:** [March 21, 2025, 5:01pm UTC](https://forum.yunohost.org/t/import-pbpbb-database-backup-no-access/35868/6 "2025-03-21T17:01:52Z")
Thank you. I already found that. But I do not think that that is enough to import a DB, since I still get the not allowed error. ---
**Author:** ![jarod5001](https://forum.yunohost.org/user_avatar/forum.yunohost.org/jarod5001/32/5323_2.png) [@jarod5001](https://forum.yunohost.org/u/jarod5001)\ **Post date:** [March 21, 2025, 5:56pm UTC](https://forum.yunohost.org/t/import-pbpbb-database-backup-no-access/35868/7 "2025-03-21T17:56:01Z")
You must switch to root user to be allowed to access databases ---
**Author:** ![Mecallie](https://forum.yunohost.org/letter_avatar_proxy/v4/letter/m/9dc877/32.png) [@Mecallie](https://forum.yunohost.org/u/Mecallie)\ **Post date:** [March 22, 2025, 9:07am UTC](https://forum.yunohost.org/t/import-pbpbb-database-backup-no-access/35868/8 "2025-03-22T09:07:56Z")
How do I do that? I cannot find the root MySQL DB password anywhere? ---
**Author:** ![jarod5001](https://forum.yunohost.org/user_avatar/forum.yunohost.org/jarod5001/32/5323_2.png) [@jarod5001](https://forum.yunohost.org/u/jarod5001)\ **Post date:** [March 22, 2025, 12:08pm UTC](https://forum.yunohost.org/t/import-pbpbb-database-backup-no-access/35868/9 "2025-03-22T12:08:43Z")
`sudo -i` ---
**Author:** ![system](https://forum.yunohost.org/uploads/default/original/2X/f/f59fe8e3ee6b100b4f574d30d6e30479c68b89f0.png) [@system](https://forum.yunohost.org/u/system)\ **Post date:** [April 6, 2025, 12:08pm UTC](https://forum.yunohost.org/t/import-pbpbb-database-backup-no-access/35868/10 "2025-04-06T12:08:55Z")
Closed on April 6, 2025, 12:08pm UTC This topic was automatically closed 15 days after the last reply. New replies are no longer allowed.