AgileApps Support Wiki

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

From AgileApps Support Wiki
imported>Aeric
imported>Aeric
Line 1: Line 1:
You can create a non-root MySQL user with a limited set of permissions to run Agile Apps. Run the following command:
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> ON *.* TO '<mysql_user_name>'@'<required_server_ip>';''' For example, GRANT SELECT ON *.* TO '<user123>'@'<127.0.0.1>';
'''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:
Following is the minimum list of permissions that a user should have to use Agile Apps:
:*Select_priv: Y
:*SELECT
:*Insert_priv: Y
:*INSERT
:*Update_priv: Y
:*UPDATE
:*Delete_priv: Y
:*DELETE
:*Create_priv: Y
:*CREATE
:*Drop_priv: Y
:*DROP
:*Reload_priv: N
:*GRANT OPTION
:*Shutdown_priv: N
:*REFERENCES
:*Process_priv: N
:*INDEX
:*File_priv: N
:*ALTER
:*Grant_priv: Y
:*CREATE TEMPORARY TABLES
:*References_priv: Y
:*LOCK TABLES
:*Index_priv: Y
:*EXECUTE
:*Alter_priv: Y
:*CREATE VIEW
:*Show_db_priv: N
:*SHOW VIEW
:*Super_priv: N
:*CREATE ROUTINE
:*Create_tmp_table_priv: Y
:*ALTER ROUTINE
:*Lock_tables_priv: Y
:*TRIGGER ON
:*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

Revision as of 12:03, 1 March 2018

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
Retrieved from "https://agileappscloud.info/aawiki-src/index.php?title=Creating_a_non-root_MySQL_User_to_Run_Agile_Apps&oldid=26991"