Advertisement
If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)
Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie
Hi there,
There is an issue with role permissions that is being worked on at the moment.
If you are having trouble with access or permissions on regional forums please post here to get access: https://www.boards.ie/discussion/2058365403/you-do-not-have-permission-for-that#latest

Connecting to MySQL from ODBC

  • 27-09-2009 7:12pm
    #1
    stevire
    Registered Users, Registered Users 2 Posts: 1,512 ✭✭✭


    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: 
    [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)


Comments

  • #2
    stevire
    Registered Users, Registered Users 2 Posts: 1,512 ✭✭✭stevire


    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!


Advertisement