• 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

Question database user host restrictions

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
 
Back
Top