|
|
Posted by Paul on 12/01/06 16:58
That leaves the problem: but whta should I fill in then? The provider does
not give a solution.
"Sean" <sean.anderson@[nospam]oakleafgroup.biz> 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" <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.
>>>>
>>>
>>>
>>>
>>
>>
>
>
>
Navigation:
[Reply to this message]
|