#1
  1. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Aug 2000
    Location
    Kuwait
    Posts
    47
    Rep Power
    15
    I have MySQL on some host, and I am interested in executing a query from Access on my local machine.

    Does anyone know how to connect remotly?

    Thank you.
  2. #2
  3. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Nov 2000
    Posts
    9
    Rep Power
    0
    it is runs mysql console:

    mysql -h<remote host> -u<username> -p<password> <database name>
  4. #3
  5. No Profile Picture
    Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Sep 2000
    Location
    Colchester, England
    Posts
    131
    Rep Power
    15
    You will need to install the ODBC drivers for MySql.

    Download from here: http://www.mysql.com/downloads/api-myodbc.html

    The userid you use to login to MySql with must be set up to allow access remotely. The default is to allow login from localhost. The userid can be set to allow remote access from specific IP addresses, domains or % (anywhere) etc.

    Once you have all drivers and userid in place
    go into access and right click within "tables" and select link tables form the menu. On the file type tab in the next screen scroll to the bottom and select ODBC.

    Select the MySql datasource you want or set up a new one and then select your tables when prompted.

    Andy J.

  6. #4
  7. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Aug 2000
    Location
    Kuwait
    Posts
    47
    Rep Power
    15
    How do I setup MySQL on the hosting machine to allow remote access. Do hosting companies usually setup MySQL to be accessed remotely or just localy?

    Thank you.
  8. #5
  9. Banned (not really)
    Devshed Supreme Being (6500+ posts)

    Join Date
    Dec 1999
    Location
    Brussels, Belgium
    Posts
    14,643
    Rep Power
    4492
    Probably just locally to begin with. It's not a big deal to add in another host that relates to where you'll be connecting in from. If you have a dial-up account, your IP address will change, but the first two numbers should stay the same. Ask them to put something like '143.77.%' in as your host (substitute your actual IP of course). If you have a static IP address, then you can put the whole thing in as the host. Your service provider will have to do it for you, though.

    ---John Holmes...
  10. #6
  11. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Aug 2000
    Location
    Kuwait
    Posts
    47
    Rep Power
    15
    Andy,

    I have followed your instrcutions on setting up MyODBC, and it was working on MySQL the local version (on my windows 98), but when I tried to connect to MySQL on host server (on the internet), I was denied access. It said:

    <BLOCKQUOTE><font size="1" face="Verdana,Arial,Helvetica">quote:</font><HR> [TCX][MyODBC]Host 'as13-130.quality-net.net' is not allowed to connect to this MySQL server {#1130}[/quote]

    I assume this is what you were talking about when you mentioned setting up userid for remote access.

    How can I setup the userid for remote access?

    Thank you

  12. #7
  13. No Profile Picture
    Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Sep 2000
    Location
    Colchester, England
    Posts
    131
    Rep Power
    15
    Check this out for a full explanation http://www.mysql.com/documentation/m...ge_system.html

    GRANT ALL PRIVILEGES on databasename.* to username@%;

    The above allows "username" to have all privileges to "databasename" from "%"(anywhere).

    You may have to ask your hosting company to set this up.

    Andy

Similar Threads

  1. mysql connect issue
    By slen in forum MySQL Help
    Replies: 1
    Last Post: February 17th, 2004, 03:33 AM
  2. Replies: 1
    Last Post: February 4th, 2004, 11:50 PM
  3. connect to mysql db server in another server
    By darcher in forum MySQL Help
    Replies: 5
    Last Post: January 13th, 2004, 10:22 PM
  4. Replies: 0
    Last Post: January 6th, 2004, 04:13 AM
  5. Replies: 2
    Last Post: January 5th, 2004, 08:53 PM

IMN logo majestic logo threadwatch logo seochat tools logo