Attempting to create a Token Vault in MySQL results in a failed to save error when using a non-root user.
The store procedure that is created in the tokenspace1 database uses a function that sets a global variable. This is the only database that uses this stored procedure. For the server to create this stored procedure it needs the SUPER privilege. This is not part of the grant all set of privileges as such using GRANT ALL on the cdp user will not work. The default root user has this privilege by default.
Grant SUPER to the user attempting to connect to the Tokenspace1 database.
GRANT ALL on tokenspace1.* to 'cdpadmin'@'localhost'; GRANT SUPER on *.* to 'cdpadmin'@'localhost';
Imported Document ID: 000030145
Subscribing will provide email updates when this Article is updated. Login is required.
Thanks for your feedback. Let us know if you have additional comments below. (requires login)
Subscribed to the Article.
Unable to subscribe
Thanks for your additional feedback !!!
Enterprise Support Virtual Agent
Rate Me :
Tell us more:
Welcome! My name is Sami, the Enterprise Support Virtual Agent answering technical support questions.