connection MySQL and ms Access

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.

Re: connection MySQL and ms Access

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

Allows SELECT access
GRANT SELECT ON * TO

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

The use of "*" infers all tables.

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



"Paul" 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.
>

Re: connection MySQL and ms Access

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" 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
>
> If you want total control (SELECT, UPDATE, INSERT, DELETE)
> GRANT ALL ON * TO
>
> The use of "*" infers all tables.
>
> You could specify the tables:
> GRANT SELECT ON mytable1 TO
> GRANT SELECT ON mytable2 TO
> GRANT SELECT ON mytable3 TO
> GRANT UPDATE ON mytable4 TO
>
>
>
> "Paul" 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.
>>
>
>
>

Re: connection MySQL and ms Access

If the SQL server is on the Internet, then from your PC the server name
would not be "localhost" as this refers to your PC. Noting of course that
when a page is uploaded to a website, localhost would then be the server on
which the page resides.

"Paul" wrote in message
news:45704ca2$0$19905$e4fe514c@dreader27.news.xs4all.nl...
>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" 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
>>
>> If you want total control (SELECT, UPDATE, INSERT, DELETE)
>> GRANT ALL ON * TO
>>
>> The use of "*" infers all tables.
>>
>> You could specify the tables:
>> GRANT SELECT ON mytable1 TO
>> GRANT SELECT ON mytable2 TO
>> GRANT SELECT ON mytable3 TO
>> GRANT UPDATE ON mytable4 TO
>>
>>
>>
>> "Paul" 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.
>>>
>>
>>
>>
>
>

Re: connection MySQL and ms Access

Sean wrote:
> If the SQL server is on the Internet, then from your PC the server
> name would not be "localhost" as this refers to your PC. Noting of
> course that when a page is uploaded to a website, localhost would
> then be the server on which the page resides.

Noting more importantly that most 'simple' hosting accounts do not allow
remote access to the database. It would only be accessable locally, so a
web connection cannot be made, unless they're willing to change this.

--
Grtz,

Rik

Re: connection MySQL and ms Access

That leaves the problem: but whta should I fill in then? The provider does
not give a solution.

"Sean" schreef in bericht
news:1164986734.813379@kestrel.skynet.co.uk...
> If the SQL server is on the Internet, then from your PC the server name
> would not be "localhost" as this refers to your PC. Noting of course that
> when a page is uploaded to a website, localhost would then be the server
> on which the page resides.
>
> "Paul" wrote in message
> news:45704ca2$0$19905$e4fe514c@dreader27.news.xs4all.nl...
>>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" 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
>>>
>>> If you want total control (SELECT, UPDATE, INSERT, DELETE)
>>> GRANT ALL ON * TO
>>>
>>> The use of "*" infers all tables.
>>>
>>> You could specify the tables:
>>> GRANT SELECT ON mytable1 TO
>>> GRANT SELECT ON mytable2 TO
>>> GRANT SELECT ON mytable3 TO
>>> GRANT UPDATE ON mytable4 TO
>>>
>>>
>>>
>>> "Paul" 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.
>>>>
>>>
>>>
>>>
>>
>>
>
>
>