mittwald

Interact with mittwald mStudio API

Actions409

Project Actions
- Project Delete Project Invite
- Project Get Project Invite
- Project Delete Project Membership
- Project Get Project Membership
- Project Update Project Membership
- Project Delete Project
- Project Get Project
- Project Delete Server Avatar
- Project Request Server Avatar Upload
- Project Get Llm Licence Experimental
- Project Update Llm Licence Experimental
- Project Get Project Token Invite
- Project Get Self Membership For Project
- Project Get Server
- Project Update Project Description
- Project Update Server Description
- Storagespace Get Project Statistics
- Storagespace Get Server Statistics
- Storagespace Replace Project Notification Threshold
- Storagespace Replace Server Notification Threshold
- Project Accept Project Invite
- Project Create Llm Beta Licence Experimental
- Project Get Llm Licences Experimental
- Project Create Project Invite
- Project List Invites For Project
- Project Create Project
- Project Decline Project Invite
- Project Delete Project Avatar
- Project Request Project Avatar Upload
- Project List Memberships For Project
- Project List Project Invites
- Project List Project Memberships
- Project List Projects
- Project List Servers
- Project Resend Project Invite Mail
Backup Actions
- Backup Create Project Backup Export
- Backup Delete Project Backup Export
- Backup Create Project Backup Schedule
- Backup List Project Backup Schedules
- Backup Create Project Backup
- Backup List Project Backups
- Backup Delete Project Backup Schedule
- Backup Get Project Backup Schedule
- Backup Delete Project Backup
- Backup Update Project Backup Schedule
- Backup Get Project Backup
- Backup Update Project Backup Description
Cronjob Actions
- Cronjob List Executions
- Cronjob Delete Cronjob
- Cronjob Get Cronjob
- Cronjob Update Cronjob
- Cronjob Get Execution
- Cronjob Update Cronjob App Id
- Cronjob Abort Execution
- Cronjob Create Cronjob
- Cronjob List Cronjobs
- Cronjob Create Execution
App Actions
- App Execute Action
- App Get App
- App Get Appinstallation
- App Patch Appinstallation
- App Uninstall Appinstallation
- App Get Appversion
- App Set Database Users
- App Get Installed Systemsoftware For Appinstallation
- App Get Missing Dependencies For Appinstallation
- App Get Systemsoftware
- App Get Systemsoftwareversion
- App Link Database
- App List Appinstallations For User
- App List Appinstallations
- App Request Appinstallation
- App List Apps
- App List Appversions
- App List Systemsoftwares
- App List Systemsoftwareversions
- App List Update Candidates For Appversion
- App Replace Database
- App Request Appinstallation Copy
- App Retrieve Status
- App Unlink Database
SSH SFTP User Actions
- Sftp User Create Sftp User
- Sftp User List Sftp Users
- Sftp User Delete Sftp User
- Sftp User Get Sftp User
- Sftp User Update Sftp User
- Ssh User Create Ssh User
- Ssh User List Ssh Users
- Ssh User Delete Ssh User
- Ssh User Get Ssh User
- Ssh User Update Ssh User
Project File System Actions
- Project File System Get Directories
- Project File System Get Disk Usage
- Project File System Get File Content
- Project File System Get Jwt
- Project File System List Files
Contract Actions
- Contract Cancel Contract Item Termination
- Contract Terminate Contract Item
- Contract Cancel Contract Tariff Change
- Contract Cancel Contract Termination
- Contract Terminate Contract
- Contract Get Base Item Of Contract
- Contract Get Detail Of Contract By Certificate
- Contract Get Detail Of Contract By Domain
- Contract Get Detail Of Contract By Lead Fyndr
- Order List Project Orders
- Contract Get Detail Of Contract By Mail Address
- Contract Get Detail Of Contract By Project
- Contract Get Detail Of Contract By Server
- Contract Get Detail Of Contract Item
- Contract Get Detail Of Contract
- Contract List Contracts
- Invoice Detail
- Invoice Get Detail Of Invoice Settings
- Invoice Update Invoice Settings
- Invoice Get File Access Token
- Invoice List Customer Invoices
- Order Create Order
- Order List Orders
- Order Create Tariff Change
- Order Get Order
- Order List Customer Orders
- Order Preview Order
- Order Preview Tariff Change
Database Actions
- Database List Mysql Charsets
- Database List Mysql Versions
- Database List Redis Versions
- Database Create Mysql Database
- Database List Mysql Databases
- Database Create Mysql User
- Database List Mysql Users
- Database Create Redis Database
- Database List Redis Databases
- Database Delete Mysql Database
- Database Get Mysql Database
- Database Delete Mysql User
- Database Get Mysql User
- Database Update Mysql User
- Database Delete Redis Database
- Database Get Redis Database
- Database Disable Mysql User
- Database Enable Mysql User
- Database Get Mysql User Php My Admin Url
- Database Update Mysql Database Default Charset
- Database Update Mysql Database Description
- Database Update Mysql User Password
- Database Update Redis Database Configuration
- Database Update Redis Database Description
Domain Actions
- Domain Abort Domain Declaration
- Domain Check Domain Registrability
- Domain Check Domain Transferability
- Domain Create Domain Auth Code
- Domain Delete Domain
- Domain Get Domain
- Domain Get Latest Screenshot
- Domain List Tld Contact Schemas
- Domain Resend Domain Email
- Domain Update Domain Auth Code
- Domain Update Domain Contact
- Domain Update Domain Project Id
- Domain List Domains
- Domain Update Domain Nameservers
- Ingress Update Ingress Paths
- Ingress Update Ingress Tls
- Dns Create Dns Zone
- Dns Delete Dns Zone
- Dns Get Dns Zone
- Dns Get Zone File
- Dns List Dns Zones
- Dns Set Record Set Managed
- Dns Update Record Set
- Domain Suggest
- Ingress Create Ingress
- Ingress List Ingresses
- Ingress Delete Ingress
- Ingress Get Ingress
- Ingress Ingress Verify Ownership
- Ingress List Ingresses Compatible With Certificate
- Ingress Request Ingress Acme Certificate Issuance
- Ssl Check Replace Certificate
- Ssl Create Certificate Request
- Ssl List Certificate Requests
- Ssl Delete Certificate Request
- Ssl Delete Certificate
- Ssl Get Certificate Request
- Ssl Get Certificate
- Ssl Replace Certificate
- Ssl List Certificates
User Actions
- User Update Account
- User Delete Api Token
- User Edit Api Token
- User Get Api Token
- User Delete Ssh Key
- User Edit Ssh Key
- User Get Ssh Key
- User Delete User
- User Get Personalized Settings
- User Update Personalized Settings
- User Get Poll Status
- User Post Poll Status
- Password Validation Get Password Policy
- User Add Phone Number
- User Remove Phone Number
- User Authenticate Mfa
- User Authenticate
- User Authenticate With Access Token Retrieval Key
- User Change Email
- User Change Password
- User Confirm Mfa
- User Disable Mfa
- User Reset Recoverycodes
- User Confirm Password Reset
- User Create Api Token
- User List Api Tokens
- User Create Feedback
- User Create Ssh Key
- User List Ssh Keys
- User Get Session
- User Terminate Session
- User Get User
- User Update Personal Information
- User Init Password Reset
- User List Feedback
- User List Sessions
- User Refresh Session
- User Oauth Retrieve Access Token
- User Register
- User Remove Avatar
- User Request Avatar Upload
- User Resend Verification Email
- User Support Code Request
- User Verify Email
- User Verify Phone Number
- User Verify Registration
Conversation Actions
- Conversation Create Conversation
- Conversation List Conversations
- Conversation Create Message
- Conversation List Messages By Conversation
- Conversation Get Category
- Conversation Get Conversation Members
- Conversation Get Conversation Preferences Of Customer
- Conversation Get Conversation
- Conversation Update Conversation
- Conversation Get File Access Token
- Conversation Request File Upload
- Conversation Set Conversation Status
- Conversation Update Message
Customer Actions
- Customer Accept Customer Invite
- Customer Create Customer Invite
- Customer List Invites For Customer
- Customer Create Customer
- Customer List Customers
- Customer Create Recommendation Suggestion
- Customer Create Wallet
- Customer Get Wallet
- Customer Decline Customer Invite
- Customer Delete Customer Invite
- Customer Get Customer Invite
- Customer Delete Customer Membership
- Customer Get Customer Membership
- Customer Update Customer Membership
- Customer Delete Customer
- Customer Get Customer
- Customer Update Customer
- Customer Get Customer Token Invite
- Customer Is Customer Legally Competent
- Customer List Customer Invites
- Customer List Customer Memberships
- Customer List Memberships For Customer
- Customer Remove Avatar
- Customer Request Avatar Upload
- Customer Resend Customer Invite Mail
Mail Actions
- Mail Create Mail Address
- Mail List Mail Addresses
- Mail Update Mail Address Autoresponder
- Mail Update Mail Address Forward Addresses
- Mail Update Mail Address Password
- Mail Update Mail Address Quota
- Mail Update Mail Address Spam Protection
- Mail Create Deliverybox
- Mail List Delivery Boxes
- Mail Delete Delivery Box
- Mail Get Delivery Box
- Mail Delete Mail Address
- Mail Get Mail Address
- Mail Disable Mail Archive
- Mail List Backups For Mail Address
- Mail List Project Mail Settings
- Mail Recover Mail Address Emails
- Mail Update Delivery Box Description
- Mail Update Delivery Box Password
- Mail Update Mail Address Address
- Mail Update Mail Address Catch All
- Mail Update Project Mail Setting
Notification Actions
- Newsletter Subscribe User
- Notifications List Notifications
- Notifications Read All Notifications
- Notifications Read Notification
File Actions
- File Create File
- File Get File Meta
- File Get File Upload Token Rules
- File Get File Upload Type Rules
- File Get File
- File Get File With Name
Page Insights Actions
- Pageinsights Get Performance Data
- Pageinsights Get Strace Data
- Pageinsights List Performance Data For Project
- Pageinsights Schedule Strace
Relocation Actions
- Relocation Create Legacy Tariff Change
- Relocation Create Relocation
Marketplace Actions
- Contributor Delete Contributor
- Contributor Patch Contributor
- Extension Get Contributor
- Contributor Express Interest To Contribute
- Contributor Get Billing Information
- Contributor Update Billing Information
- Contributor Get Customer Billing Portal Link
- Contributor Get Login Link
- Contributor List Contract Partners Of Contributor
- Extension Get Extension Instance For Customer
- Extension Get Extension Instance For Project
- Contributor List Incoming Invoices
- Contributor List Onbehalf Invoices
- Contributor Receipt Get File Access Token
- Contributor Request Deviating Contributor Avatar Upload
- Contributor Reset Contributor Avatar
- Contributor Request Verification
- Contributor Rotate Secret For Extension Instance
- Extension Authenticate Instance
- Extension Authenticate With Session Token
- Extension Cancel Extension Termination
- Extension Schedule Extension Termination
- Extension Change Context
- Extension Consent To Extension Scopes
- Extension Create Contributor Onboarding Process
- Extension Create Extension Instance
- Extension List Extension Instances
- Extension Create Retrieval Key
- Extension Delete Extension Instance
- Extension Get Extension Instance
- Extension Delete Extension
- Extension Get Own Extension
- Extension Patch Extension
- Extension Disable Extension Instance
- Extension Dry Run Webhook
- Extension Enable Extension Instance
- Extension Generate Extension Secret
- Extension Generate Session Token
- Extension Get Customer Extension Instance Orders
- Extension Get Extension Instance Contract
- Extension Update Extension Instance Contract
- Extension Get Extension
- Extension Get Project Extension Instance Orders
- Extension Get Public Key
- Extension Invalidate Extension Secret
- Extension List Contributors
- Extension List Extensions
- Extension List Own Extensions
- Extension Register Extension
- Extension Order Extension
- Extension Remove Asset
- Extension Remove Logo
- Extension Request Logo Upload
- Extension Request Asset Upload
- Extension Request Extension Verification
- Extension Set Extension Published State
- Extension Update Extension Pricing
- Marketplace Customer Get Payment Method
- Marketplace Customer Update Payment Method
Article Actions
- Article Get Article
- Article List Articles
Container Actions
- Container Create Registry
- Container List Registries
- Container Declare Stack
- Container Get Stack
- Container Update Stack
- Container Delete Registry
- Container Get Registry
- Container Update Registry
- Container Delete Volume
- Container Get Volume
- Container Get Container Image Config
- Container Get Service Logs
- Container Get Service
- Container List Services
- Container List Stacks
- Container List Volumes
- Container Pull Image For Service
- Container Recreate Service
- Container Restart Service
- Container Start Service
- Container Stop Service
- Container Validate Container Registry Uri
- Container Validate Registry Credentials
Misc Actions
- Servicetoken Authenticate Service
- Verification Verify Address
- Verification Verify Company
Lead Fyndr Actions
- Leadfyndr Create Lead Fyndr Access Request
- Leadfyndr Get Lead Fyndr Profile Request
- Leadfyndr Get Cities
- Leadfyndr Get Lead Fyndr Profile Tariff Options
- Leadfyndr Get Lead Fyndr Profile
- Leadfyndr Get Lead
- Leadfyndr Get Unlocked Lead
- Leadfyndr Unlock Lead
- Leadfyndr List Leads
- Leadfyndr List Unlocked Leads
- Leadfyndr Remove Unlocked Lead Reservation
- Leadfyndr Reserve Unlocked Lead

Overview

This node operation allows you to create a new MySQL user for a specified MySQL database within the mittwald mStudio environment. It is useful when you need to programmatically manage database users, such as automating user creation during deployment or provisioning processes. For example, you can use this node to add a new user with specific access rights (full or readonly) and control their access IP mask and external access settings.

Properties

Name	Meaning
Mysql Database Id	The unique identifier of the MySQL database where the new user will be created.
Access Ip Mask	Optional IP mask defining from which IP addresses the user can access the database.
Access Level	The permission level granted to the user; options are "Full" (full access) or "Readonly".
Database Id	Identifier of the database associated with the user.
Description	A textual description for the MySQL user being created.
External Access	Boolean flag indicating whether the user is allowed to access the database externally.
Password	The password assigned to the new MySQL user.

Output

The node outputs JSON data representing the result of the MySQL user creation request. This typically includes details about the newly created user such as its ID, status, and any metadata returned by the mittwald API. There is no binary output involved.

Dependencies

Requires an API key credential for authenticating with the mittwald mStudio API.
The node communicates with the mittwald API endpoint at https://api.mittwald.de.
Proper configuration of the API credential in n8n is necessary for successful requests.

Troubleshooting

Authentication errors: Ensure that the API key credential is correctly configured and has sufficient permissions.
Invalid input data: Verify that all required fields (e.g., Mysql Database Id, Database Id, Password, Access Level) are provided and valid.
Access issues: If the user cannot connect after creation, check the Access Ip Mask and External Access settings to ensure they allow connections from the intended sources.
API errors: Review error messages returned by the mittwald API for hints on misconfiguration or quota limits.

Links and References

mittwald mStudio API Documentation (official API docs)
n8n Documentation (for general node usage and credential setup)