List:MySQL ODBC« Previous MessageNext Message »
From:Al McNicoll Date:September 28 2006 5:09pm
Subject:RE: Error in connection to MySQL in VB
View as plain text  
You need to not only create a user, but also specify what host it can
connect from. Unless you want IP-based security, create the user as
'myuser'@'%' (where myuser is the name of your user) - the percent sign
means "anything" and therefore allows you to connect from any machine.

Al

-----Original Message-----
From: Sushil Pugalia [mailto:sushilpugalia@stripped] 
Sent: 27 September 2006 06:50
To: myodbc@stripped
Subject: Error in connection to MySQL in VB

Sir,

We get following error while connecting to MySQL though VB Code

[MySQL][ODBC 3.51 Driver]Host '172.31.21.249' is not allowed to connect to
this MySQL server

Please help.

Thanks

Sushil Pugalia

Thread
Error in connection to MySQL in VBSushil Pugalia27 Sep
  • RE: Error in connection to MySQL in VBAl McNicoll28 Sep