adamsargant
New Pleskian
- Server operating system version
- Windows Server 2022 Datacenter 21H2
- Plesk version and microupdate number
- 18.0.63 #4
I'm trying to create a bash script to update the ACL on every MySQL db user. I have tested the command I'm running on the command line direct
(I have also tried this with just one IP)
I am getting the response message "SUCCESS: Update db user 'dbuser' in database 'dbname' completed." but this is not reflected in the Access Control section of the DB User management screen, which still reads "Allow remote connections from any host"
I'm using MariaDB v10.11.8. Instructions like
work just fine
Any help would be humbly and gratefully received
Code:
plesk bin database -u dbname -update_user dbuser -set-acl xx.xx.xxx.xx,xx.xx.xxx.xx,xx.xx.xxx.xx,xx.xx.xxx.xx
(I have also tried this with just one IP)
I am getting the response message "SUCCESS: Update db user 'dbuser' in database 'dbname' completed." but this is not reflected in the Access Control section of the DB User management screen, which still reads "Allow remote connections from any host"
I'm using MariaDB v10.11.8. Instructions like
Code:
plesk bin database --create dbname -domain targetdomain -type mysql
work just fine
Any help would be humbly and gratefully received