Posted by Sean on 12/01/06 16:22

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" <pietcom@xs4all.nl> 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" <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]