Yes, your grant tables are not set up correctly.
For full information, see the manual.
For now try this:
Choose a userid and password just for your db connection. It can be
different from every other userid password you have.
With the mysql client issue the following to SQL statements
GRANT ALL ON *.* TO userid@%.uni-karlsruhe.de IDENTIFIED BY 'password';
FLUSH PRIVILEGES;
Then try to connect with ODBC using the above userid and password.
The effect of the GRANT statement allows userid to connect from any machine
in the un-karlsruhe.de domain.
The *.* means all databases and all their tables.
The % is the wildcard that MySQL needs to allow the domain match.
If your connection is always going to come from the same host, you can put
that exact hostname or ip address after the @ in that section.
MySQL maintains a totally separate user list from the system it is on, which
is why you are getting the error.
On 3/27/01 6:34 PM, "Wawan Setiawan" <[EMAIL PROTECTED]> wrote:
> Hello, I'm new here ...
> I'm trying to use MySQL qith ASP, so I use ODBC .., but when I'm trying to
> connect to the server, it always respons:
>
>
> Microsoft OLE DB Provider for ODBC Drivers error '80004005'
>
> [TCX][MyODBC]Access denied for user:
> '[EMAIL PROTECTED]@mbtpc20.bau-verm.uni-karlsruhe.de' (Using password: YES)
>
>
>
> Any idea on this ..?
>
> Thank you for your reply
>
> -ws-
>
> ---------------------------------------------------------------------
> 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
