Re: Problems with MySql CONNECTOR ODBC Ver. 3.51.12
Martin MC Brown <[email protected]>
| Newsgroups | gmane.comp.db.mysql.odbc |
|---|---|
| Message-ID | <[email protected]> |
Hi, > REQUEST RETURN WITH SQL_ERROR > > and in the Diagnostic dialog, it returns the following error: > > [MySQL][ODBC 3.51 Driver]Can't connect to MySQL server on > <static_ip_server_2003> (10060) > > User ID and Password are correct (user@%) I'm confused by the above line... What do you mean 'user@%' When you set a username/password through the GRANT command, the format is: grant all to USERNAME @ HOSTNAME identified by PASSWORD The '%' is used as a wildcard to match the hostname, but it isn't a component of the username or the password. There's a basic walkthrough of the steps required to connect from one machine to another (with a Unix/Linux MySQL host, although the same principles apply to a Windows/Windows connection) here: http://dev.mysql.com/doc/refman/5.1/en/myodbc-examples-walkthrough.html MC -- Martin MC Brown, Technical Writer MySQL AB, http://www.mysql.com Skype: mcmcslp -- MySQL ODBC Mailing List For list archives: http://lists.mysql.com/myodbc To unsubscribe: http://lists.mysql.com/[email protected]