I am trying to set up ODBC access from Access 2000 to MySQL running on Linux. Whenever I test the connection in the set-up dialogue, I get "MySQL ODBC [3.5..] Access Denied for [EMAIL PROTECTED] Password Required (yes)" The message is not verbatim but essentially the same.
I check the mailing list archives on MySQL but could not easily find a resolution. I set up the GRANT correctly on the server like: grant all on mydb.* to foobar identified by 'password'; Also tried grant ...... foobar@'%' ..... and the specific IP 68.101.103.68 but the response was the same. If anyone can throw some light on it, I would appreciate it. Thanks _______________________________________________ Boston-pm mailing list [EMAIL PROTECTED] http://mail.pm.org/mailman/listinfo/boston-pm
