Don't name a MySQL table 'user' without a prefix! (At least if you want to access that table in Dreamweaver CS3). As far as I know, it's not a reserved word and doesn't cause any problems when you work from the command line, navicat, whatever, just Dreamweaver. It's probably bad practice to name your user table 'user' but I did it anyways and now I know it's probably bad practice.
Whenever I tried viewing data on the 'users' table, DW would throw an a bad SQL error at me. I was seriously WTF'ing because I could connect to the datasource, see all the tables, and even view data on everything except the 'users' table. Once I narrowed it down to being that one and only table, I realized it was the table name and a quick change fixed it all up.
While I was at it, I added a few tables that I had intention of doing. In my script, I neglected being consistent with specifying the table's character set of UTF-8. I ran the script, it failed. I made some changes, it failed again with a different but similar error. I specify the Character Set of my new tables to match with the other, success!
I had read of people experiencing similar errors on primary keys but apparently, it's very touchy-feely.