A new installation of 4.1.9 on AIX 5. I have a GRANT that is not working.
Connecting from foreign server 'pho.com' with IP of '192.168.1.1', I
should be able to GRANT using either:
mysql> GRANT all ON test.* TO test@'192.168.%' IDENTIFIED BY 'test';
mysql> GRANT all ON test.* TO test@'%.com' IDENTIFIED BY 'test';
The second version '%.com' allows access. The first version access by
IP '192.168.%' does not work.
This always has worked on 4.1.9 before. There is nothing in the manual
to elaborate on this problem. As far as I can see, this should work
Would any users be able to suggest a solution to this?