mysql5 doesn't start

[davidc1947@…]

sudo port install mysql5 +server
sudo port install ruby
sudo port install rb-rubygems
sudo port install rb-termios
sudo port install rb-mysql
sudo port install subversion +tools
sudo ln -s /opt/local/var/run/mysql5/mysqld.sock /tmp/mysql.sock
sudo mysql_install_db5 --user=mysql 

 mysql5 ERROR: 1004 mysql5 Can't create file '/var/tmp/#sql149ef_1_0.frm' (errno: 9)
 mysql5
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/opt/local/var/run/mysql5/mysqld.sock' (2)

[ryandesign@…]

Replying to davidc1947@…:

sudo port install mysql5 +server

There hasn't been any such thing as a +server variant for the mysql5 port in several years. If we still have instructions out there that say to do this, please let us know the URL so that we can correct the instructions.

sudo ln -s /opt/local/var/run/mysql5/mysqld.sock /tmp/mysql.sock

There should be no need to do this. Why do you believe this should be done?

sudo mysql_install_db5 --user=mysql 

mysql5 ERROR: 1004 mysql5 Can't create file '/var/tmp/#sql149ef_1_0.frm' (errno: 9)
mysql5
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/opt/local/var/run/mysql5/mysqld.sock' (2)

Have you followed the instructions at wiki:howto/MAMP#mysql?