Well, I did the grant and still cannot connect. This is so annoying. Well,
I tried putting these grants::
GRANT ALL ON *.* TO anonymous@"mydomainthatisnotshowninthisemail.com";
GRANT ALL ON *.* TO anonymous@anonymous;
GRANT ALL ON *.* TO ""@"";
So far, none have worked. any suggestions? I want anyone to be able to
access my database.
- Deryck H
- http://www.comp-u-exchange.com
----- Original Message -----
From: "Venu" <[EMAIL PROTECTED]>
To: "Deryck Henson" <[EMAIL PROTECTED]>
Cc: "MySQL" <[EMAIL PROTECTED]>
Sent: Wednesday, September 05, 2001 12:12 AM
Subject: RE: What does this error mean??!!
>
> )-----Original Message-----
> )From: Deryck Henson [mailto:[EMAIL PROTECTED]]
> )Sent: Tuesday, September 04, 2001 10:10 PM
> )To: [EMAIL PROTECTED]
> )Cc: MySQL
> )Subject: Re: What does this error mean??!!
> )
> )
> )Would you be so kind as to do that step by step? I'm very new to this
and
> )don't know half this stuff (although I am starting to learn books, etc.).
> )Please. Not tryin to get you mad or anything but I dont have a clue on
how
> )to go about doing that.
>
> Hummmaaa....!!!! ok, here is the link, which guides you step by step in
> depth than me.
>
http://www.mysql.com/documentation/mysql/bychapter/manual_MySQL_Database_Adm
> inistration.html#Privilege_system
>
> Regards, venu
> --
> For technical support contracts, go to https://order.mysql.com/
> __ ___ ___ ____ __
> / |/ /_ __/ __/ __ \/ / Mr. Venu <mailto:[EMAIL PROTECTED]>
> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer
> /_/ /_/\_, /___/\___\_\___/ Woodside, California USA
> <___/ www.mysql.com
> )
> )- Deryck H
> )- http://www.comp-u-exchange.com
> )----- Original Message -----
> )From: "Venu" <[EMAIL PROTECTED]>
> )To: "Deryck Henson" <[EMAIL PROTECTED]>; "Joshua J. Kugler"
> )<[EMAIL PROTECTED]>
> )Cc: "MySQL" <[EMAIL PROTECTED]>
> )Sent: Wednesday, September 05, 2001 12:00 AM
> )Subject: RE: What does this error mean??!!
> )
> )
> )>
> )> )-----Original Message-----
> )> )From: Deryck Henson [mailto:[EMAIL PROTECTED]]
> )> )Sent: Tuesday, September 04, 2001 9:55 PM
> )> )To: Joshua J. Kugler
> )> )Cc: MySQL
> )> )Subject: Re: What does this error mean??!!
> )> )
> )> )
> )> )I know that!!! But how do I fix it? On the DSN, I put uid and
> )> )pwd to blank
> )> )because I did the same in the ODBC UserDSN setup window.
> )>
> )> Execute GRANT ALL ON *.* TO "some"@"something.com" IDENTIFIED BY
> )> "mypassword" at the root level, and then try to connect it. This
> )gives all
> )> types of access to user "some" from "something.com".
> )>
> )> Regards, Venu
> )> --
> )> For technical support contracts, go to https://order.mysql.com/
> )> __ ___ ___ ____ __
> )> / |/ /_ __/ __/ __ \/ / Mr. Venu <mailto:[EMAIL PROTECTED]>
> )> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer
> )> /_/ /_/\_, /___/\___\_\___/ Woodside, California USA
> )> <___/ www.mysql.com
> )>
> )> )
> )> )- Deryck H
> )> )- http://www.comp-u-exchange.com
> )> )----- Original Message -----
> )> )From: "Joshua J. Kugler" <[EMAIL PROTECTED]>
> )> )To: "Deryck Henson" <[EMAIL PROTECTED]>; "Deryck Henson"
> )> )<[EMAIL PROTECTED]>; "MySQL" <[EMAIL PROTECTED]>
> )> )Sent: Tuesday, September 04, 2001 7:02 PM
> )> )Subject: Re: What does this error mean??!!
> )> )
> )> )
> )> )> It means that access for the user connecting from the domain
> )> )something.com
> )> )> has been denied. You don't have permissions set up properly.
> )> )>
> )> )> j----- k-----
> )> )>
> )> )> On Tuesday 04 September 2001 15:59, Deryck Henson wrote:
> )> )> > [TCX][MyODBC]Access denied for user: '[EMAIL PROTECTED]'
> )to database
> )> )> > 'dbasename'
> )> )> >
> )> )> > I get this every time I try to connect with mysql.
> )> )>
> )> )> --
> )> )> Joshua Kugler, Information Services Director
> )> )> Associated Students of the University of Alaska Fairbanks
> )> )> [EMAIL PROTECTED], 907-474-7601
> )> )>
> )> )> --------------------------------------------------------------------
-
> )> )> 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
