Professional Web Applications Themes

connection MySQL (on the web) -- Access - MySQL

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 What do I have to change to get my acces database connected to MySQL on the net? The provider (Lycos) does not know....

  1. #1

    Default connection MySQL (on the web) -- 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

    What do I have to change to get my acces database connected to MySQL on the
    net?
    The provider (Lycos) does not know.


    Paul Guest

  2. #2

    Default Re: connection MySQL (on the web) -- Access

    On Fri, 1 Dec 2006 13:09:49 +0100, Paul wrote: 

    They need to set up your database properly. They can start with

    GRANT ALL ON databasename.* TO usernamelocalhost;

    --
    _ o
    |/)
    Peter Guest

  3. #3

    Default Re: connection MySQL (on the web) -- Access

    Paul wrote: 


    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?

    onedbguru Guest

Similar Threads

  1. MS Access with Mysql link table connection failed
    By pelhughes in forum Coldfusion Database Access
    Replies: 3
    Last Post: July 3rd, 11:13 PM
  2. Replies: 2
    Last Post: March 19th, 09:28 AM
  3. Replies: 1
    Last Post: January 23rd, 12:06 PM
  4. MySQL Connection with SSL or TLS
    By Patrick T. in forum Macromedia Director Basics
    Replies: 3
    Last Post: October 17th, 06:13 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139