I installed mysql5 and mysql5-server with macports started service fine but when i did
mysqladmin5 -u root -p ping
Enter password: mysqladmin5: connect to server at 'localhost' failed error: 'Access denied for user 'root'@'localhost' (using password: NO)'
after some rooting around the socket was missing so i did a shameless chmod on its location, restarted and the socket now appears but that doesn't fix my original problem
tried to reset the password (just incase it had been set by the magical password fairies or something) using this technique: http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html#resetting-permissions-unix
that did nothing thought I would have a look at the logs there was nothing in /opt/local/var/log/mysql5/ but it was empter did some more chmod 777ing and now .turd_mysql5-server is appearing but its empty