Re: can't successfully make an ODBC connection!
Daniel Kasak <[email protected]>
| Newsgroups | gmane.comp.db.mysql.odbc |
|---|---|
| Message-ID | <[email protected]> |
Nancy Joseph wrote: > I am new to mySql so maybe I am missing something, but I cannot successfully create an ODBC connection which I must have to work with the MySql database in Crystal Reports. I keep getting an Access Denied for user 'ODBC'@'localhost' (using password: NO) > I do not have a problem using the mySql command line to start up mySql and use my database. So why can't it connect via ODBC? Using the command line I do not have to specify any userid or passwords. It begins by prompting for a password and I simply hit enter without a typing any password. > > Anywhere to look? I have been exhaustively through the manual and haven't gained any ground. I would be most appreciative of your help. > I'm not sure about that 'exhaustive' search through the manual - perhaps your manual is missing a chapter or 2? But anyway since the user administration section of MySQL Administrator are currently broken, here are some links in the documentation for setting up authentication the old-fashioned way: http://dev.mysql.com/doc/refman/5.1/en/privileges.html http://dev.mysql.com/doc/refman/5.1/en/access-denied.html -- Daniel Kasak IT Developer NUS Consulting Group Level 5, 77 Pacific Highway North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 email: [email protected] website: http://www.nusconsulting.com.au -- MySQL ODBC Mailing List For list archives: http://lists.mysql.com/myodbc To unsubscribe: http://lists.mysql.com/[email protected]