Please Help - can't get mysql to run

[Mo Issa]

> I tried the unset TMPDIR command and I still get the same error. This is
> driving me insane. Any help from you guys will be great!
> 
> Many Thanks,
> 
> Mo.
> 
> 
> 
> 
> 
> 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
> 
> 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.macosforge.org/pipermail/macports-users/attachments/20101021/d1769da2/attachment.html>