Differences

This shows you the differences between two versions of the page.

--- json_calls [2025/04/16 09:10] – kirtisingh
+++ json_calls [2025/04/22 07:34] (current) – kirtisingh
@@ Line 53: / Line 53: @@
 <code>
+{
     "task":"create_mysql_pair",
     "params":{
@@ Line 63: / Line 64: @@
 </code>
-system_user - %%__%%SYSTEM%%__%%USER%%__%% - The system user to which the DB is mapped. Refernced only w.r.t. backups\\
+system_user - %%__%%SYSTEM%%__%%USER%%__%% - The system user to which the DB is mapped. Referenced only w.r.t. backups\\
 mysql_db_name - %%__%%MYSQL%%_%%DB%%_%%NAME%%__%% - The name of the new MySQL DB\\
 mysql_user_name - %%__%%MYSQL%%_%%USER%%_%%NAME%%__%% - The name of the new MySQL User\\
 mysql_user_pwd - %%__%%MYSQL%%_%%USER%%_%%PWD%%__%% - The password for the new MySQL user. It should be between 8 to 20 characters with a reasonable password strength
+**Create MySQL DB**
+<code>
+{
+    "task":"create_mysql_db",
+    "params":{
+        "system_user":"__SYSTEM_USER__",
+        "mysql_db_name":"__MYSQL_DB_NAME__",
+        "mysql_from_db_name":"__MYSQL_FROM_DB_NAME__",
+        "_comment":"mysql_from_db_name is an optional paramater"
+    }
+}
+</code>
+system_user - %%__%%SYSTEM%%__%%USER%%__%% - The system user to which the DB is mapped. Referenced only w.r.t. backups\\
+mysql_db_name - %%__%%MYSQL%%_%%DB%%_%%NAME%%__%% - The name of the new MySQL DB\\
+mysql_from_db_name - %%__%%MYSQL%%_%%FROM%%__%%DB%%_%%NAME%%__%% - Optional parameter. The name of an existing database from which new DB should be cloned\\
+**Create MySQL User**
+<code>
+{
+    "task":"create_mysql_user",
+    "params":{
+        "mysql_user_name":"__MYSQL_USER_NAME__",
+        "mysql_user_pwd":"__MYSQL_USER_PWD__"
+    }
+}
+</code>
+mysql_user_name - %%__%%MYSQL%%_%%USER%%_%%NAME%%__%% - The name of the new MySQL User\\
+mysql_user_pwd - %%__%%MYSQL%%_%%USER%%_%%PWD%%__%% - The password for the new MySQL user. It should be between 8 to 20 characters with a reasonable password strength
+**Pair an existing MySQL DB and a MySQL User**
+<code>
+{
+    "task":"pair_mysql_db_user",
+    "params":{
+        "mysql_db_name":"__MYSQL_DB_NAME__",
+        "mysql_user_name":"__MYSQL_USER_NAME__"
+    }
+}
+</code>
+mysql_db_name - %%__%%MYSQL%%_%%DB%%_%%NAME%%__%% - The name of an existing MySQL DB\\
+mysql_user_name - %%__%%MYSQL%%_%%USER%%_%%NAME%%__%% - The name of an existing MySQL User\\