I went to start development on a project and first step is to install it under a development environment on my laptop. With MAMP loaded under OSX should be easy to do. Created my virtual host and dropped the files and went to install using the localhost key provided. Pretty seamless however I hit a SQL error on the table creation, nothing in the forum about it so I felt it had to be my dev environment, I poked around and then decided to take a closer look at the SQL error. I noticed it was defining time timestamp(14) declaring the length. That didn't seem right/necessary to me so I modified the amember.sql files in the application root, find replace in dreamweaver timestamp(14) -> timestamp and off we go... SQL version is 5.5.9, just thought I'd drop a hint.
Thanks for the info. Yes you right this was not necessary and worked on old MySQL servers. amember.sql was fixed and will be updated on bext release.