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.

Following is the list of minimum permissions that a user should have to use Agile Apps:

• Select_priv: Y
• Insert_priv: Y
• Update_priv: Y
• Delete_priv: Y
• Create_priv: Y
• Drop_priv: Y
• Reload_priv: N
• Shutdown_priv: N
• Process_priv: N
• File_priv: N
• Grant_priv: Y
• References_priv: Y
• Index_priv: Y
• Alter_priv: Y
• Show_db_priv: N
• Super_priv: N
• Create_tmp_table_priv: Y
• Lock_tables_priv: Y
• Execute_priv: Y
• Repl_slave_priv: N
• Repl_client_priv: N
• Create_view_priv: Y
• Show_view_priv: Y
• Create_routine_priv: Y
• Alter_routine_priv: Y
• Create_user_priv: N
• Event_priv: N
• Trigger_priv: Y
• Create_tablespace_priv: N
• ssl_type:
• ssl_cipher:
• x509_issuer:
• x509_subject:
• max_questions: 0
• max_updates: 0
• max_connections: 0
• max_user_connections: 0
• plugin:
• authentication_string: NULL