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
- 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
- Project File System Actions
- 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
- File Actions
- Page Insights Actions
- Relocation Actions
- 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
- 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
- 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 interacts with the mittwald mStudio API to manage database users. Specifically, the "Database Disable Mysql User" operation disables a MySQL user by its unique identifier. This is useful in scenarios where you want to revoke access for a specific MySQL user without deleting the user entirely, such as temporarily suspending access during maintenance or security reviews.
Practical examples include:
- Disabling a MySQL user account that is no longer needed or suspected of being compromised.
- Temporarily disabling user access during system upgrades or migrations.
- Automating user lifecycle management in a database environment integrated with n8n workflows.
Properties
| Name | Meaning |
|---|---|
| Mysql User Id | ID of the MySQL user to disable. This is a required string input specifying which MySQL user account will be disabled. |
Output
The node outputs JSON data representing the response from the mittwald mStudio API after attempting to disable the specified MySQL user. The structure typically includes confirmation of the action or details about the disabled user. No binary data output is indicated.
Dependencies
- Requires an API key credential for authenticating with the mittwald mStudio API.
- The node uses the base URL
https://api.mittwald.deand expects JSON content-type headers. - Proper configuration of the API authentication credential within n8n is necessary for successful requests.
Troubleshooting
Common issues:
- Invalid or missing MySQL User ID: Ensure the provided ID corresponds to an existing MySQL user.
- Authentication errors: Verify that the API key credential is correctly configured and has sufficient permissions.
- Network or API availability issues: Confirm connectivity to the mittwald API endpoint.
Error messages:
- Unauthorized or 401 errors indicate problems with API credentials.
- 404 errors may mean the specified MySQL user ID does not exist.
- 400 errors could result from malformed requests or missing required parameters.
Resolving these typically involves checking input values, verifying credentials, and ensuring the API service is operational.
Links and References
- mittwald mStudio API Documentation (official API docs for further details on endpoints and usage)