• If you are still using CentOS 7.9, it's time to convert to Alma 8 with the free centos2alma tool by Plesk or Plesk Migrator. Please let us know your experiences or concerns in this thread:
    CentOS2Alma discussion

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

WhizzHacks

New 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