• 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
  • Inviting everyone to the UX test of a new security feature in the WP Toolkit
    For WordPress site owners, threats posed by hackers are ever-present. Because of this, we are developing a new security feature for the WP Toolkit. If the topic of WordPress website security is relevant to you, we would be grateful if you could share your experience and help us test the usability of this feature. We invite you to join us for a 1-hour online session via Google Meet. Select a convenient meeting time with our friendly UX staff here.

Question database user host restrictions

D

David_VB

New Pleskian
Dear Plesk forum members,

Since Plesk by default doesn't seem to restrict database users to a host / hosts. I know how to set this for new users, and I also know how to alter this setting from the Plesk panel for existing users, but since I have to deal with a lot of existing unrestricted users spread out over multiple servers I would like to automate it a bit.
Therefore I was searching through the psa database to see which table contained the host restrictions, but so far I haven't found it. Does anyone happen to know where I can find this?

Or does anyone know of a CLI command that controls this setting?

Kind regards,

David
 
You must log in or register to reply here.

Similar threads

S
Issue No database servers
Replies
8
Views
636
Stettin
S
A
Question Plesk for Windows (Godaddy Website Hosting) and Microsoft RPC Service
Replies
4
Views
1K
AlmaWalters
A
K
Resolved No underscore used as delimiter when setting a custom user prefix for database users
Replies
5
Views
979
Peter Debik
P
M
Issue Plesk Update 18.0.34 to 18.0.57 Database 'psa' not found
Replies
10
Views
915
musa.sc
M
M
Question High CPU usage of mariadbd for long periods of time
Replies
0
Views
478
mapodec
M
Back
Top