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
