Error in connection to MySQL in VB

------=_Part_21054_1712842.1159336178252
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

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

------=_Part_21054_1712842.1159336178252--

RE: Error in connection to MySQL in VB

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@gmail.com]
Sent: 27 September 2006 06:50
To: myodbc@lists.mysql.com
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


--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=gcdmo-myodbc@m.gmane.org