Initial setup and configuration of MySQL on XP SP2
Posted on 2006-06-14
I'm having a devil of a time installing MySQL for the very first time so that it hooks into ODBC. I assume this is the way to do it if I'm ultimately trying to setup a data bind for Dreamweaver MX 04.
When I am in the ODBC config area, I see my recently installed MySQL ODBC driver 3.51.12. If I select that to add to ODBC stack, the config screen comes up, but when i try to add the database (which I had just created successfully in the Command window) I'm getting an error:
Request returned with SQL_ERROR
If I hit the Diagnostics button in the ui, it reads:
[MySQL][ODBC 3.51 Driver]Access denied for user 'ODBC'@'localhost' (using password: NO)
[MySQL][ODBC 3.51 Driver]Access denied for user 'ODBC'@'localhost' (using password: YES)
I've tried it both ways with the only password I've indicated during initial setup of MySQL.
Can you tell I'm a total newb? Help!