This is a discussion on connection MySQL (on the web) -- Access within the MySQL Database forums, part of the Database Forums category; Hi, I try to connect Microsoft Access (2003) to MySQL (5). I use Connector / ODBC 3.51.12 I fill ...
|
|||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
|
|||
|
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. |
|
|||
|
Paul wrote:
> 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. Please do not multi-post your questions localhost is YOUR box. This should be the IP address of your provider. If you do not even know the basics of networking, how in the world do you expect to actually be effective at anything relating to computers? |