ERROR: 1004 Can't create file '/var/tmp/#sqlcf9_1_0.frm' (errno: 9)

[Sebastian Wojtowicz]

Thx, I'm further now through:

sudo chown -R mysql:mysql /opt/local/var/db/mysql5
sudo chmod u+rwx,go= /opt/local/var/db/mysql5

But now I can't set the password. Is this related to the initial problem ?

I started mysql...
sudo /opt/local/share/mysql5/mysql/mysql.server start

and now I struggle with...
allisones-mac:~ Allisone$ sudo /opt/local/lib/mysql5/bin/mysqladmin -u root
password 'new-password'
/opt/local/lib/mysql5/bin/mysqladmin: connect to server at 'localhost'
failed
error: 'Access denied for user 'root'@'localhost' (using password: NO)'

or
allisones-mac:~ Allisone$ sudo /opt/local/lib/mysql5/bin/mysqladmin -u root
password 'new-password'
/opt/local/lib/mysql5/bin/mysqladmin: connect to server at 'localhost'
failed
error: 'Access denied for user 'root'@'localhost' (using password: NO)'
allisones-mac:~ Allisone$ sudo /opt/local/lib/mysql5/bin/mysqladmin -u root
-h allisones-mac.fritz.box password 'new-password'
/opt/local/lib/mysql5/bin/mysqladmin: connect to server at
'allisones-mac.fritz.box' failed
error: 'Host 'localhost' is not allowed to connect to this MySQL server'

I remember this steps to be straight forward, what is happening now that
this doesn't work out of the box ?

2010/12/5 Jasper Frumau <jasperfrumau at gmail.com>

> Maybe a file/folder permissions issue. See also
> http://forums.freebsd.org/showthread.php?s=0d9db79ab2a610ba86748801aa3c0565&t=19807&page=2(page two of similar thread @ BSD) Using DiskUtilities you can check disc
> file permissions as well for the whole disc. But none of my
> suggestions/solutions are warranted. I just use MAP for web development..
>
> On Sun, Dec 5, 2010 at 7:25 AM, Sebastian Wojtowicz <
> trust.sebastian at googlemail.com> wrote:
>
>> Forgot to say, that error comes on
>> sudo /opt/local/lib/mysql5/bin/mysql_install_db --user=mysql
>>
>> 2010/12/5 Sebastian Wojtowicz <trust.sebastian at googlemail.com>
>>
>> Has someone found a solution to this problem ? Cause I see posts, but no
>>> working solution in the internet.
>>> This night I have reinstalled Mac OSX Snow Leopard, updated to the newest
>>> version 10.6.5, Installed XCode newest Version 3.2.5, installed newest
>>> macports, did a selfupdate and then did a "sudo port install mysql5".... all
>>> that TWICE
>>> Tried "unset TMPDIR"
>>> tried to set "tmpdir = /tmp/" in "/opt/local/etc/mysql5/my.cnf"
>>>
>>> I always get the same error message.
>>>
>>> Thanks for the help
>>>
>>
>>
>> _______________________________________________
>> macports-users mailing list
>> macports-users at lists.macosforge.org
>> http://lists.macosforge.org/mailman/listinfo.cgi/macports-users
>>
>>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.macosforge.org/pipermail/macports-users/attachments/20101205/c52fbb5a/attachment.html>