Please Help - can't get mysql to run
ryandesign at macports.org
Wed Oct 20 16:04:29 PDT 2010
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.
More information about the macports-users