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
 
(8 intermediate revisions by the same user not shown)
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.
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:
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
Run the SQL query as follows from the mysql command prompt:
:*Repl_client_priv: N
'''GRANT 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 *.* TO '<''mysql_user_name''>'@'<''required_server_ip''>';'''
:*Create_view_priv: Y
 
:*Show_view_priv: Y
For information on running the platform as a non-root user, see [[Running the Platform as a Non-Root User]].
:*Create_routine_priv: Y
:*Alter_routine_priv: Y
:*Create_user_priv: N
:*Event_priv: N
:*Trigger_priv: Y
:*Create_tablespace_priv: N

Latest revision as of 09:08, 2 May 2018

You can create a non-root MySQL user with a limited set of permissions to run Agile Apps.

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

Run the SQL query as follows from the mysql command prompt: GRANT 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 *.* TO '<mysql_user_name>'@'<required_server_ip>';

For information on running the platform as a non-root user, see Running the Platform as a Non-Root User.

Retrieved from "https://agileappscloud.info/aawiki-src/index.php?title=Creating_a_non-root_MySQL_User_to_Run_Agile_Apps&oldid=26997"