• We value your experience with Plesk during 2024
    Plesk strives to perform even better in 2025. To help us improve further, please answer a few questions about your experience with Plesk Obsidian 2024.
    Please take this short survey:

    https://pt-research.typeform.com/to/AmZvSXkx
  • The Horde webmail has been deprecated. Its complete removal is scheduled for April 2025. For details and recommended actions, see the Feature and Deprecation Plan.
  • We’re working on enhancing the Monitoring feature in Plesk, and we could really use your expertise! If you’re open to sharing your experiences with server and website monitoring or providing feedback, we’d love to have a one-hour online meeting with you.

Resolved [SSH] Create Database User with SSH and deactivate remote access

FloLa

Basic Pleskian
At the moment I am trying to create a database with SSH and an associated user.
This user should only be available locally and not from outside.

In the Plesk web panel under Database users, there is the setting "Only allow local connections".
Is it possible to activate this via the command line, i.e. SSH? If yes how?
 

Attachments

  • Screenshot.png
    Screenshot.png
    6.3 KB · Views: 3
Solved with this code:

Code:
plesk bin database --create "test" -domain "mysql.example.com" -type mysql -add_user "test" -passwd "T3stP4@@w0rd!" -add-access 'localhost' -remove-access '%'
 
Back
Top