Re: Problem with GRANT not working.
Hello. Enable a General log and find out what is MySQL thinking about the host from you're connecting to it. Ben Clewett wrote: Dear MySQL, 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 perfectly. Would any users be able to suggest a solution to this? Regards, Ben Clewett. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Problem with GRANT not working.
Hello. It looks very weird for me. I don't have an access to AIX machine, so I suggest you to use gdb and research where MySQL is getting such an interesting result. See sql/hostname.cc file from the source distribution and: http://dev.mysql.com/doc/refman/4.1/en/debugging-server.html Ben Clewett wrote: A little more information: If I use --skip-name-resolve then I get an odd error: ERROR 1045 (28000): Access denied for user 'me'@'0.0.0.0' (using password: YES) This seems to suggest that MySQL thinks my client is from '0.0.0.0' and hence cannot match any GRANT syntax I use. Why would MySQL think my client is from '0.0.0.0'? Thanks in advance for any person who can offer a solution to these problems. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Problem with GRANT not working.
Dear MySQL, 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 perfectly. Would any users be able to suggest a solution to this? Regards, Ben Clewett. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Problem with GRANT not working.
A little more information: If I use --skip-name-resolve then I get an odd error: ERROR 1045 (28000): Access denied for user 'me'@'0.0.0.0' (using password: YES) This seems to suggest that MySQL thinks my client is from '0.0.0.0' and hence cannot match any GRANT syntax I use. Why would MySQL think my client is from '0.0.0.0'? Thanks in advance for any person who can offer a solution to these problems. Ben Clewett wrote: Dear MySQL, 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 perfectly. Would any users be able to suggest a solution to this? Regards, Ben Clewett. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
