Difference between revisions of "Creating a non-root MySQL User to Run Agile Apps"
From AgileApps Support Wiki
imported>Aeric |
imported>Aeric Β |
||
(6 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. | 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: | 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]]. | ||
: | |||
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.