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