Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2009
    Posts
    4

    Unanswered: Connecting to MySQL from ODBC

    I've been connecting to mySQL server on my webhosting package to insert data into crystal reports. Used it pretty regularly, but in the last couple of months haven't touched it.

    Then today I wanted to fire off an up to date report but keep getting an access denied error. I went into the mySQL Connector/ODBC and checked it. The data hasn't changed however in the diagnostics of that tool I keep getting the following error when testing the connection:
    Code:
    [MySQL][ODBC 3.51 Driver]Access denied for user 'myuser'@'xxx-xxx-xxx.ntlworld.ie' (using password: YES)
    Anyone know why its using the address "xxx-xxx-xxx.ntlworld.ie" instead of the webhosting address? (the x's are numbers)

  2. #2
    Join Date
    Mar 2009
    Posts
    4
    Got it sorted... My IP address changed since I last used it so I had to add my new IP to the mySQL remote hosts access list!

Posting Permissions

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