Posted by Paul on 12/01/06 15:39

I dont't quite understand:
1. I use the username I normally use in php without a problem.
2. How can I use your script in relation to create a connection with the
controlpanel of windows?

"Sean" <sean.anderson@[nospam]oakleafgroup.biz> schreef in bericht
news:1164973473.196313@kestrel.skynet.co.uk...
> 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]