Please Help - can't get mysql to run

[Ryan Schmidt]

Replying back to list...

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

> Ryan Schmidt wrote:

> 
>> 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
> 
> This is what I get:
> 
> ls -ld /var/tmp
> drwxrwxrwt  38 root  wheel  1292 Oct 20 17:42 /var/tmp

Actually that looks fine.

Do you have the TMPDIR environment variable set? This bug report at Homebrew suggests having that variable set will cause this problem, so try unsetting that variable.

http://github.com/mxcl/homebrew/issuesearch?state=closed&q=1004#issue/2821