mittwald icon

mittwald

Interact with mittwald mStudio API

Actions409

Overview

This node operation updates an existing MySQL user in a database managed via the mittwald mStudio API. It allows modifying key attributes of a MySQL user such as access permissions, IP restrictions, and descriptive metadata. This is useful for database administrators who need to programmatically manage user privileges and access controls without manually interacting with the database or control panel.

Practical examples include:

  • Updating a user's access level from readonly to full after a role change.
  • Restricting or expanding the IP addresses from which a user can connect by changing the access IP mask.
  • Adding or updating a description to document the purpose or owner of the MySQL user.
  • Enabling or disabling external access for security compliance.

Properties

Name Meaning
Mysql User Id The unique identifier of the MySQL user to update.
Access Ip Mask Optional IP address mask defining allowed client IPs for this MySQL user.
Access Level The permission level granted to the user; options are "Full" (full access) or "Readonly".
Description A textual description or note about the MySQL user.
External Access Boolean flag indicating whether external access to the MySQL user is enabled (true) or disabled (false).

Output

The node outputs JSON data representing the updated MySQL user object as returned by the mittwald mStudio API. This typically includes the updated fields such as user ID, access level, IP mask, description, and external access status.

No binary data output is indicated.

Dependencies

  • Requires an API key credential for authenticating with the mittwald mStudio API.
  • The node uses the mittwald mStudio REST API endpoint at https://api.mittwald.de.
  • Proper network connectivity and API permissions are necessary to perform update operations on MySQL users.

Troubleshooting

  • Invalid Mysql User Id: If the provided user ID does not exist, the API will likely return an error. Verify the user ID before running the node.
  • Insufficient Permissions: The API key used must have rights to update MySQL users; otherwise, authorization errors will occur.
  • Malformed IP Mask: Providing an invalid IP mask format may cause the API to reject the request.
  • Missing Required Fields: Ensure all required properties (Mysql User Id, Access Level, Description) are set; missing these will cause validation errors.
  • Network Issues: Connectivity problems or incorrect base URL configuration can lead to request failures.

Links and References

Discussion