• Introducing WebPros Cloud - a fully managed infrastructure platform purpose-built to simplify the deployment of WebPros products !  WebPros Cloud enables you to easily deliver WebPros solutions — without the complexity of managing the infrastructure.
    Join the pilot program today!
  • The Horde component is removed from Plesk Installer. We recommend switching to another webmail software supported in Plesk.
  • The BIND DNS server has already been deprecated and removed from Plesk for Windows.
    If a Plesk for Windows server is still using BIND, the upgrade to Plesk Obsidian 18.0.70 will be unavailable until the administrator switches the DNS server to Microsoft DNS. We strongly recommend transitioning to Microsoft DNS within the next 6 weeks, before the Plesk 18.0.70 release.

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