[Boston.pm] OT - Any experience with ODBC to MySQL?
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
Re: [Boston.pm] OT - Any experience with ODBC to MySQL?
On Fri, Jun 04, 2004 at 05:47:11PM -0700, Ranga Nathan wrote: 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. If anyone can throw some light on it, I would appreciate it. Since you didn't mention it, I would guess that you did not 'FLUSH PRIVILEGES' after changing the grant tables. If you did, then you may find this page helpful: http://dev.mysql.com/doc/mysql/en/Access_denied.html. FWIW, I have setup this ODBC combination several times and it works fine. -Gyepi ___ Boston-pm mailing list [EMAIL PROTECTED] http://mail.pm.org/mailman/listinfo/boston-pm