View source for Creating a non-root MySQL User to Run Agile Apps

You can create a non-root MySQL user with a limited set of permissions to run Agile Apps. Run the following SQL query from the mysql command prompt:
'''GRANT <command> *.* TO '<mysql_user_name>'@'<required_server_ip>';''' For example, GRANT SELECT *.* TO '<user123>'@'<127.0.0.1>';

Following is the minimum list of permissions that a user should have to use Agile Apps:
:*SELECT
:*INSERT
:*UPDATE
:*DELETE
:*CREATE
:*DROP
:*GRANT OPTION
:*REFERENCES
:*INDEX
:*ALTER
:*CREATE TEMPORARY TABLES
:*LOCK TABLES
:*EXECUTE
:*CREATE VIEW
:*SHOW VIEW
:*CREATE ROUTINE
:*ALTER ROUTINE
:*TRIGGER ON