Import PBPBB database backup: no access?

Support apps
, ,
1

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 :united_kingdom: but feel free to write in French :france: 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

2

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?

3

Install phpmyadmin and import the database to the right one

4

Can’t DB is to large for that. I think the DB is about 600MB.

5

If you’re looking for the db credentials you can find them in /etc/yunohost/apps/phpbb/settings.yml

6

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.

7

You must switch to root user to be allowed to access databases

8

How do I do that? I cannot find the root MySQL DB password anywhere?

9

sudo -i

10

This topic was automatically closed 15 days after the last reply. New replies are no longer allowed.