Posted by Sean on 12/01/06 12:41

You need to allow the user to access to the database.

Allows SELECT access
GRANT SELECT ON * TO <username>

If you want total control (SELECT, UPDATE, INSERT, DELETE)
GRANT ALL ON * TO <username>

The use of "*" infers all tables.

You could specify the tables:
GRANT SELECT ON mytable1 TO <username>
GRANT SELECT ON mytable2 TO <username>
GRANT SELECT ON mytable3 TO <username>
GRANT UPDATE ON mytable4 TO <username>



"Paul" <pietcom@xs4all.nl> wrote in message
news:45701bfd$0$16272$e4fe514c@dreader22.news.xs4all.nl...
> Hi,
>
> I try to connect Microsoft Access (2003) to MySQL (5).
> I use Connector / ODBC 3.51.12
> I fill in:
> Login:
> Datasourcename: http://www.sitename.nl
> Description: Web connection
> Server: localhost
> User: username I got from the provider
> Password: ***** (password to open the database)
> Databasename: the name I got from the provider.
>
> Clicking test I get an error: access denied for user username@localhost.
>
> What do I have to change to get my acces database connected to MySQL on
> the net?
> The provider (Lycos) does not know.
>

[Back to original message]