Problem with connection to mysqldb with user

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hi,

how have I to edit the privileges that I can connect from a access-db
stored on a notebook to a mysqlserver stored on a linux box.

Actualy I get the following error:
Access denied for user 'linux@192.168.0.251' using password: NO)

Regards,
Ruprecht
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.2 (GNU/Linux)
Comment: Using GnuPG with SUSE - http://enigmail.mozdev.org

iD8DBQFExQDEOAckbBgiIFcRAkZNAKCYfA+SeCErkaeOAoRcMZBHKJcd4gCf ZR8e
bnOqZrQJe1lhwdwfzVlYhiQ=
=1OcR
-----END PGP SIGNATURE-----

--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=gcdmo-myodbc@m.gmane.org

Re: Problem with connection to mysqldb with user

Hi,

> how have I to edit the privileges that I can connect from a access-db
> stored on a notebook to a mysqlserver stored on a linux box.
>
> Actualy I get the following error:
> Access denied for user 'linux@192.168.0.251' using password: NO)

See this page in the manual:

http://dev.mysql.com/doc/refman/5.1/en/myodbc-examples-walkt hrough.html

Which gives some basic steps for doing this.

It sounds like you haven't configured a user for access to the database.

MC


--
Martin MC Brown, Technical Writer
MySQL AB, http://www.mysql.com
Skype: mcmcslp



--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=gcdmo-myodbc@m.gmane.org

Re: Problem with connection to mysqldb with user

Hi,
>

> See this page in the manual:
>
> http://dev.mysql.com/doc/refman/5.1/en/myodbc-examples-walkt hrough.html
>
> Which gives some basic steps for doing this.
>
> It sounds like you haven't configured a user for access to the database.

Ok all is done. I've tested the connection in the myodbc-Connector and
it works.

Unfortunately I have a problem in access by trying to build a chain to
a table in the mysql-database to which I connect via odbc. In MS Access
I come till the point that I'm asking which ODBC-Configuration I want to
use. After the selection of that configuration ms-access crashes.


I am using Access 2003 on client-side.
Any idea what can be the reason?

Regards,
Ruprecht



--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=gcdmo-myodbc@m.gmane.org