Description:
Hi,
we are running Mysql 4.1.9 in 'skip-name-resolve'-Mode. When trying to
GRANT ALL ON mydb.* TO myuser@'1.2.0.0/255.255.192.0' IDENTIFIED BY 'mypass';
I receive the warning:
+---------+------+------------------------------------------------------------------------
--------------------------------------+
| Level | Code | Message
|
+---------+------+------------------------------------------------------------------------
--------------------------------------+
| Warning | 1285 | MySQL is started in --skip-name-resolve mode; you must restart it
without this switch for this grant to work |
+---------+------+------------------------------------------------------------------------
--------------------------------------+
When I disable 'skip-name-resolve'-Mode everything works fine.
How to repeat:
see above
Suggested fix:
When I understand the code the correct way there is something missing in file
sql/sql_acl.cc in function 'hostname_requires_resolving': You also have to test for '(cur
!= '/')'!
Description: Hi, we are running Mysql 4.1.9 in 'skip-name-resolve'-Mode. When trying to GRANT ALL ON mydb.* TO myuser@'1.2.0.0/255.255.192.0' IDENTIFIED BY 'mypass'; I receive the warning: +---------+------+------------------------------------------------------------------------ --------------------------------------+ | Level | Code | Message | +---------+------+------------------------------------------------------------------------ --------------------------------------+ | Warning | 1285 | MySQL is started in --skip-name-resolve mode; you must restart it without this switch for this grant to work | +---------+------+------------------------------------------------------------------------ --------------------------------------+ When I disable 'skip-name-resolve'-Mode everything works fine. How to repeat: see above Suggested fix: When I understand the code the correct way there is something missing in file sql/sql_acl.cc in function 'hostname_requires_resolving': You also have to test for '(cur != '/')'!