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]
Re: GRANT not working
I believe my problem was that I was omitting the word PRIVILEGES. I was doing just GRANT ALL ON... I also added *.* instead of * and @'localhost' and that got it working. Thanks to all who helped out. Andrew I personally have never had a problem with Redhat. Andrew try this: grant all privileges on *.* to 'amp'@'%' identified by 'blah' (with grant option) ; let me know if it works. - Original Message - From: Matt Hargraves [EMAIL PROTECTED] To: Andrew Pierce [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, September 03, 2002 7:22 PM Subject: Re: GRANT not working I believe that your problem is specifically with RedHat. I've ran it on just about every incarnation of Linux from Mandrake to Gentoo. The only one that I have ever had a problem getting MySQL to run on was RedHat 7.x and I've even run it on things like OpenMosix (www.openmosix.org) and Scyld. Tried RedHat versions from 7.0 to 7.3, none of them will run, install any other distro, it works from the start. Don't matter whether it's MySQL 3.x or 4.x, it won't work for me or anyone else I know with RedHat. Hope that helps you with your problem. Matt - Original Message - From: Andrew Pierce [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, September 03, 2002 7:06 AM Subject: GRANT not working I have a new installation of RedHat 7.3 and MySql. I had MySql working great on a Mandrake 8.0 installation. Now that I have reloaded this box with RH, I cannot get setup and working. I can run mysql as root and get in. I ran the commands below: grant all on * to amp identified by 'blahdblah'; flush privileges; Now when I run mysql like this: $mysql -u amp -pblahdblah I get the following error: ERROR 1045: Access denied for user: 'amp@localhost' (Using password: YES) I have a sneaking suspicion about the host but I don't know how to fix it. Thanks for any help. Andrew - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
GRANT not working
I have a new installation of RedHat 7.3 and MySql. I had MySql working great on a Mandrake 8.0 installation. Now that I have reloaded this box with RH, I cannot get setup and working. I can run mysql as root and get in. I ran the commands below: grant all on * to amp identified by 'blahdblah'; flush privileges; Now when I run mysql like this: $mysql -u amp -pblahdblah I get the following error: ERROR 1045: Access denied for user: 'amp@localhost' (Using password: YES) I have a sneaking suspicion about the host but I don't know how to fix it. Thanks for any help. Andrew - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: GRANT not working
I believe that your problem is specifically with RedHat. I've ran it on just about every incarnation of Linux from Mandrake to Gentoo. The only one that I have ever had a problem getting MySQL to run on was RedHat 7.x and I've even run it on things like OpenMosix (www.openmosix.org) and Scyld. Tried RedHat versions from 7.0 to 7.3, none of them will run, install any other distro, it works from the start. Don't matter whether it's MySQL 3.x or 4.x, it won't work for me or anyone else I know with RedHat. Hope that helps you with your problem. Matt - Original Message - From: Andrew Pierce [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, September 03, 2002 7:06 AM Subject: GRANT not working I have a new installation of RedHat 7.3 and MySql. I had MySql working great on a Mandrake 8.0 installation. Now that I have reloaded this box with RH, I cannot get setup and working. I can run mysql as root and get in. I ran the commands below: grant all on * to amp identified by 'blahdblah'; flush privileges; Now when I run mysql like this: $mysql -u amp -pblahdblah I get the following error: ERROR 1045: Access denied for user: 'amp@localhost' (Using password: YES) I have a sneaking suspicion about the host but I don't know how to fix it. Thanks for any help. Andrew - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: GRANT not working
I personally have never had a problem with Redhat. Andrew try this: grant all privileges on *.* to 'amp'@'%' identified by 'blah' (with grant option) ; let me know if it works. - Original Message - From: Matt Hargraves [EMAIL PROTECTED] To: Andrew Pierce [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, September 03, 2002 7:22 PM Subject: Re: GRANT not working I believe that your problem is specifically with RedHat. I've ran it on just about every incarnation of Linux from Mandrake to Gentoo. The only one that I have ever had a problem getting MySQL to run on was RedHat 7.x and I've even run it on things like OpenMosix (www.openmosix.org) and Scyld. Tried RedHat versions from 7.0 to 7.3, none of them will run, install any other distro, it works from the start. Don't matter whether it's MySQL 3.x or 4.x, it won't work for me or anyone else I know with RedHat. Hope that helps you with your problem. Matt - Original Message - From: Andrew Pierce [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, September 03, 2002 7:06 AM Subject: GRANT not working I have a new installation of RedHat 7.3 and MySql. I had MySql working great on a Mandrake 8.0 installation. Now that I have reloaded this box with RH, I cannot get setup and working. I can run mysql as root and get in. I ran the commands below: grant all on * to amp identified by 'blahdblah'; flush privileges; Now when I run mysql like this: $mysql -u amp -pblahdblah I get the following error: ERROR 1045: Access denied for user: 'amp@localhost' (Using password: YES) I have a sneaking suspicion about the host but I don't know how to fix it. Thanks for any help. Andrew - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: GRANT not working
On Tue, 2002-09-03 at 13:22, Matt Hargraves wrote: Tried RedHat versions from 7.0 to 7.3, none of them will run, install any other distro, it works from the start. Don't matter whether it's MySQL 3.x or 4.x, it won't work for me or anyone else I know with RedHat. I am running mysql 3.23.49 on RH7.3, I did not specify the identified by part, but I was able to (as root) create a db and grant a normal user all privileges to it. Everything was working fine as far as I've tried it... grant all on * to amp identified by 'blahdblah'; flush privileges; I also did not use the flush privileges command, I simply logged out of mysql and logged back in... $mysql -u amp -pblahdblah The command I use to start mysql as user is simply mysql --local-infile=1 (to be able to insert data from a file. This probably doesn't help that musch but at least you'll know it should be possible... Regards, -- # Mertens Bram M8ram [EMAIL PROTECTED] Linux User #249103 # # Red Hat Linux 7.3 KDE 3.0.0-10 kernel 2.4.18-3 i686 128MB RAM # - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php