Please Help - can't get mysql to run

[Ryan Schmidt]

On Oct 20, 2010, at 17:08, Mo Issa wrote:

>> after I successfully installed mysql and the server port using macports, I rebooted, then I’ve been trying to create the initial database but it just won’t work. I researched this all day and it still won’t work. I’m on Mac OS X Leopard 10.5.8 and I keep on getting this error message when I execute the command to install the db:
>> 
>> sudo /opt/local/lib/mysql5/bin/mysql_install_db --user=mysql
>> Password:
>> Installing MySQL system tables...
>> ERROR: 1004  Can't create file '/var/tmp/#sqle6_1_0.frm' (errno: 9)

It sounds like your operating system's /var/tmp directory either doesn't exist or has the wrong permissions.

What is the output of the following command:

ls -ld /var/tmp