Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Connection failed: [HY000] [Mysql][ODBC 5.1 driver]

Status
Not open for further replies.

hbk2

Programmer
Apr 9, 2016
16
TN
hi, I try to connect to mysql database on ip adresse with visual foxpro9 but i got this message :
Connection failed: [HY000] [Mysql][ODBC 5.1 driver]Can't connect to MySQL server on 'ipaddress' (10060)
can you help me !
 
Can't connect to MySQL server on 'ipaddress' points out you're trying to connect from an unallowed ip address. Probably access is limited to localhost, local usage of the database only, no remote access.

Bye, Olaf.
 
thank you olaf but in the server i create new user "user1" with ALL PRIVILEGES and i specifiy my ip adress , and in my code i try to connect with user 1
 
What did you specify as your ip address? Is it really the same address you also see logged in your servers access log? Your public ip address?

Where did you add the user, how? This can't just be a database user. If your hoster in general doesn't allow remote access you can't grant it. Overall it's much more a thing to handle with them than in a forum. Administration differs and your hoster will know what to do.

Bye, Olaf.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top