Hello, Team
I will like to know the exact privileges that is needed to backup MySQL database on commvault.
We are trying to backup several MySQL databases and we are not to get past the discovery phase. The user has the attached and local system admin.
Also, see the error we are getting while trying to make use of the user.
Best answer by Sunil
Looks like EXECUTE and LOCK TABLES are missing. Please cross check with the permissions listed in this page.
https://documentation.commvault.com/2022e/expert/19239_advanced_configuration_for_mysql.html
For restore operation, we need to grant all privileges.
Thanks,
Sunil
+13Hi
This error usually indicates the failure in connecting to the remote client from CommServer machine or not able to launch the process.
Can you try Check Readiness operation on your MySQL client and see all is good?
Thanks,
Sunil
Hello,
The client is very fine on communications.
The root was used on the same client and we didn't get this error.
We created a user with root privileges but with a different name and we get this error.
This is the reason I am asking of the exact privileges needed for MySQL user.
Kindly see the privileges granted on the mysql side in my previous message.
+13Looks like EXECUTE and LOCK TABLES are missing. Please cross check with the permissions listed in this page.
https://documentation.commvault.com/2022e/expert/19239_advanced_configuration_for_mysql.html
For restore operation, we need to grant all privileges.
Thanks,
Sunil
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
