It would be better if mySQL users were created as 'username'@'%' instead of 'username'@'127.0.0.1' both users created by auto wordpress setup or via web ui but also ploi and root users.

Because they are created this way they force TCP connection, using 'localhost' as sql hostname in config usually defaults to socket connection (which is faster and uses less resources anyway when local) so it is neccesary to eiter use 127.0.0.1 in webapp configor to force TCP connections.

Another issue is when you create a server with sql only role, it is not possible to connect unless you explicitly set the user as 'username'@'web_server_public_ip' which in turn means you can not use that same user from local connectionand can not use the same username from multiple web servers connecting to that sql server.

Maybe in some cases it is preferred because of stricter security requirements but I think it would at least be nice if it was configurable, f.x. as a team default and then when you create a user you would have the option to override the default.