Dear Glyndower,
> "All remote db connections are blocked so
This says it! You are not allowed to connect to the database server
from anywhere else but from localhost.
Try:
GRANT ALL ON *.* TO me_as_odbc_user@% IDENTIFIED BY "my_password"
This will grant access to me_as_odbc_user from everywhere (which is a
security problem). If your Windoze machine has the IP "62.122.22.33",
better take "me_as_odbc_user@"62.122.22.33" instead of "%" (= all).
Hope it helps.
Regards,
--- Glyndower <[EMAIL PROTECTED]> wrote:
> This is the email I recieved from tech support of the host i'm using,
> in
> reference to using MyOdbcand MyAccess to connect from Access on a
> windoze
> machine to MySql on a unix machine.
>
> "All remote db connections are blocked so
> phpmyadmin or using ssh to connection (secure telnet) is the two
> database
> admin methods available."
>
> Any help for this out there?
>
>
> ---------------------------------------------------------------------
> 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
>
>
>
=====
---
Stefan Hinz <[EMAIL PROTECTED]>
iConnect e-commerce solutions GmbH, 13355 Berlin
Office: +49 30 46307-382 Mobil: +49 177 7841069
Antwortadresse dieser E-Mail: <[EMAIL PROTECTED]>
BITTE NUR IN DRINGENDEN FÄLLEN AN DIESE ADRESSE ANTWORTEN!
---
__________________________________________________
Do You Yahoo!?
Make international calls for as low as $.04/minute with Yahoo! Messenger
http://phonecard.yahoo.com/
---------------------------------------------------------------------
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