Change default hostname for new mysql users

[Thomas Spalinger]

Where can i change the default host for new mysql users.
I thought plesk user localhost as default... but for some reason on my installation '%' is the default. Is there a simple way to change the default for new created users?

 

[IgorG]

As I know '%' for Host is hardcoded and can't be changed. '%' means access from any host.
I can recommend you use Event manager with 'Database user account created' Event with some script for changing '%' to 'localhost' in mysql.user table after creating new DB user.

 

[Thomas Spalinger]

Thanks.

For others that have the same "problem", I created a bash script called in the event (runned as pmaadm, but could be any other user that can run mysql) and in the script there is the following command:
/usr/bin/mysql --user=admin --password="`cat /etc/psa/.psa.shadow`" --database=mysql --execute="update user set host='localhost' where user='${NEW_DATABASE_USER_NAME}'; update db set host='localhost' where user='${NEW_DATABASE_USER_NAME}'; FLUSH PRIVILEGES;"

this works for local mysql server only.