stijn0713 Posted July 10, 2012 Share Posted July 10, 2012 Hi, - my initial goal was to establish a linked table synchronization between a local running MS access database and a remote mysql database via myODBC. - i provided the host, username, pasw but i got the error: HY000][MySQL][ODBC 5.1 Driver]Can?t connect to MySQL server on dbvoorwebshop.db.8957115.hostedresource.com - then i wanted to manually write a script for getting the records of MS ACCESS database and store them into the mysql database. However now, I get a timed out message saying my script cannot connect to the mysql database. - the mysql database holds tables for OSCOMMERCE (webshop) - via the adminpanel, the backend of oscommerce, im able to read, write the database so the mysql database should work.. :S - I provided the good hostname, usern, pasw I don't know what's going wrong :S Quote Link to comment https://forums.phpfreaks.com/topic/265481-mysql_connect-timed-out/ Share on other sites More sharing options...
fenway Posted July 11, 2012 Share Posted July 11, 2012 Using it says "using password :YES/NO". Quote Link to comment https://forums.phpfreaks.com/topic/265481-mysql_connect-timed-out/#findComment-1360950 Share on other sites More sharing options...
smoseley Posted July 12, 2012 Share Posted July 12, 2012 did you grant permissions to remote logins for that user? This will grant permissions to that user from any location (not suggested): GRANT ALL on database_name.* TO user_name@'%'; If you know your IP address where you're connecting from, you can do this: GRANT ALL on database_name.* TO user_name@'123.45.67.89' ; Quote Link to comment https://forums.phpfreaks.com/topic/265481-mysql_connect-timed-out/#findComment-1360997 Share on other sites More sharing options...
stijn0713 Posted July 12, 2012 Author Share Posted July 12, 2012 Indeed, i had to have the option remote access on db of godaddy enabled Quote Link to comment https://forums.phpfreaks.com/topic/265481-mysql_connect-timed-out/#findComment-1361061 Share on other sites More sharing options...
smoseley Posted July 13, 2012 Share Posted July 13, 2012 Maybe check to see that your router and/or firewall allows connections on port 3306? EDIT: Nevermind, rereading your post, it seems the remote access was the issue. Cheers! Quote Link to comment https://forums.phpfreaks.com/topic/265481-mysql_connect-timed-out/#findComment-1361198 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.