AgileApps Support Wiki

Difference between revisions of "Creating a non-root MySQL User to Run Agile Apps"

From AgileApps Support Wiki
imported>Aeric
(Created page with "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...")
 
imported>Aeric
Line 1: Line 1:
You can create a non-root MySQL user with a limited set of permissions 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 command:
GRANT <command> ON *.* TO '<mysql_user_name>'@'<required_server_ip>'; For example, GRANT SELECT ON *.* TO '<user123>'@'<127.0.0.1>';


Following is the list of minimum permissions that a user should have to use Agile Apps:
Following is the minimum list of permissions that a user should have to use Agile Apps:
:*Select_priv: Y  
:*Select_priv: Y  
:*Insert_priv: Y  
:*Insert_priv: Y  
Line 30: Line 31:
:*Event_priv: N  
:*Event_priv: N  
:*Trigger_priv: Y  
:*Trigger_priv: Y  
:*Create_tablespace_priv: N  
:*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

Revision as of 11:50, 1 March 2018

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

Following is the minimum list of 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
Retrieved from "https://agileappscloud.info/aawiki-src/index.php?title=Creating_a_non-root_MySQL_User_to_Run_Agile_Apps&oldid=26988"