Keywords: Mautic - AWS - Technical issue - Other
Description:
Hi everyone, in the last week I start to using mautic. I did the installation through AWS marketplace, everything is working fine, except the mail builder, which I discover the problem here.
Since my bitnami mautic installation is on v3.1.0, I'm thinking with the update to v3.1.1 the mail builder will be fixed, right?
So before the update, I'm trying to do the backup, but it keeps telling me that I don't have the process privileges for the operation. As you can see in the image below:
Console image .
As you could see in the image, I'm trying to backup with the following command:
mysqldump -u bn_mautic -p bitnami_mautic > jimimautic.sql
I already test others varitaions like:
mysqldump --host=localhost --user=bn_mautic --password='MyPassHere' bitnami_mautic> jimimautic.sql
But didn't work too.
It says:
mysqldump: Error: 'Access denied; you need (at least one of) the PROCESS privilege(s) for this operation' when trying to dump tablespaces
So I tried with another SQL with GRANTS:
GRANT PROCESS, SELECT, LOCK TABLES ON . TO 'bn_mautic@localhost';
but it gives to me another error:
1045 (28000): Access denied for user 'bn_mautic'@'localhost' (using password: YES)
When i run SELECT user();
This is the result:
user()
+---------------------+
| bn_mautic@localhost |
SHOW GRANTS FOR 'bn_mautic'@'localhost';
Grants for bn_mautic@localhost
+---------------------------------------------------------+
| GRANT USAGE ON . TO bn_mautic
@localhost
| GRANT ALL PRIVILEGES ON bitnami_mautic
.* TO bn_mautic
@localhost
What I'm missing here?