Create a new user account and designate the relevant permissions
Updated Apr 16, 2026mysqlApplies to 10.0, 9.2Not yet checked for Applicare 10.0
Check this against your version
This article was last updated on Apr 16, 2026, before Applicare 10.0 was released (Jun 19, 2026), and has not been re-checked for Applicare 10.0. Confirm the steps in your environment or contact Support.
CREATE USER '<user>'@'%' IDENTIFIED BY '<password>';
GRANT SELECT, SHOW DATABASES, SHOW VIEW ON *.* TO '<user>'@'%';
GRANT EXECUTE ON xp_readerrorlog TO <user>;
Substitute <new_user> and <password> with the newly username and password you have just created.
Example:If the newly created username is appuser and the password is appuserpass, use these details in place of <new_user> and <passwords>."
CREATE USER 'appuser'@'%' IDENTIFIED BY 'appuserpass';
GRANT SELECT, SHOW DATABASES, SHOW VIEW, REPLICATION CLIENT, REPLICATION SLAVE ON *.* TO 'appuser'@'%';
GRANT EXECUTE ON xp_readerrorlog TO 'appuser';
Was this article helpful?
Votes and follows are kept by Zendesk, so they need a Help Center account. These buttons open this article there.
