• Please be aware: Kaspersky Anti-Virus has been deprecated
    With the upgrade to Plesk Obsidian 18.0.64, "Kaspersky Anti-Virus for Servers" will be automatically removed from the servers it is installed on. We recommend that you migrate to Sophos Anti-Virus for Servers.
  • 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