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