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

[hbk2]

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 !

 

[Olaf Doschke]

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.

 

[hbk2]

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

 

[Olaf Doschke]

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.