Hi,
I want to dump a MySQL DB created by cleavr. But the DB user created with the DB has no privileges for that:
'Access denied; you need (at least one of) the PROCESS privilege(s) for this operation' when trying to dump tablespaces. How can I add the privilege? Where to find the root PW?
Thanks Roman
1 Like
Had to add --no-tablespaces to the command:
mysqldump -uUsername -pPassword database > filepath --no-tablespaces
2 Likes
Glad to hear that you figured it out and thank you for sharing the solution.
FYI, Cleavr doesn’t save any passwords for security reasons. And any passwords created during server provisioning are sent out in the post-provision email. In case you need to perform an action as a root, you need to ssh into your server as a root first and then perform the action.
2 Likes