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
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.
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
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 t
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 Lin
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
TED]>
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.
iginal 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
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';
