I need to update the Super privileges for an account not on localhost in order to turn of binary logging. When I do try to grant the privileges:
GRANT ALL PRIVILEGES ON . TO 'user'@'%s' WITH GRANT OPTION;
For host name that is too long, I would prefer using corresponded IP address instead.
Ip resolution is essential for the
grant operation to execute as a sql statement, even if a host name is passed as argument in sql, it is to be underlying converted to address first, which could be done independently by