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

Sebastian Wojtowicz trust.sebastian at googlemail.com
Sun Dec 5 07:57:08 PST 2010


I cleaned my disk and reinstalled Mac OSX. Followed by the following
actions.
Why isn't this working ? Is the mysql port defect ? Have reinstalled OS X
and MySQL 3 times now. Everything I found on google didn't help.

* I ran the OS X Software Update (5 updates)
* restart
* I ran the OS X Software Update (2 updates)
* restart
* Installed Xcode 3.2.5
* restart
* macport install
* restart
* sudo port selfupdate
* sudo port install mysql5 +server
* sudo /opt/local/lib/mysql5/bin/mysql_install_db --user=mysql
Password:
Installing MySQL system tables...
ERROR: 1004  Can't create file '/var/tmp/#sqla0_1_0.frm' (errno: 9)
101205 16:04:06 [ERROR] Aborting

101205 16:04:06 [Note] /opt/local/libexec/mysqld: Shutdown complete
[...and more text...]
* sudo /opt/local/lib/mysql5/bin/mysqld_safe &
[1] 260
Sebastian-Wojtowiczs-MacBook:~ Allisone$ 101205 16:12:36 mysqld_safe Logging
to '/opt/local/var/db/mysql5/Sebastian-Wojtowiczs-MacBook.local.err'.
mkdir: /opt/local/var/run: No such file or directory
chown: /opt/local/var/run/mysql5: No such file or directory
chmod: /opt/local/var/run/mysql5: No such file or directory
101205 16:12:36 mysqld_safe Starting mysqld daemon with databases from
/opt/local/var/db/mysql5
101205 16:12:42 mysqld_safe mysqld from pid file
/opt/local/var/db/mysql5/Sebastian-Wojtowiczs-MacBook.local.pid ended

* sudo mkdir /opt/local/var/run
* sudo chmod g+w /opt/local/var/run
* sudo mkdir /opt/local/var/run/mysql5
* sudo chown mysql /opt/local/var/run/mysql5
* mysqladmin5 -u root -p ping
Enter password:
mysqladmin5: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: NO)'
* /opt/local/lib/mysql5/bin/mysqladmin -u root password 'mypass'
/opt/local/lib/mysql5/bin/mysqladmin: connect to server at 'localhost'
failed
error: 'Access denied for user 'root'@'localhost' (using password: NO)'

* sudo chown -R mysql:mysql /opt/local/var/db/mysql5
* sudo chmod u+rwx,go= /opt/local/var/db/mysql5
* sudo /opt/local/lib/mysql5/bin/mysql_install_db --user=mysql
Installing MySQL system tables...
OK
Filling help tables...
OK
[...and more text...]
* mysqladmin5 -u root password
mysqladmin5: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: NO)'


2010/12/5 Sebastian Wojtowicz <trust.sebastian at googlemail.com>

> 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/776eb6d8/attachment.html>


More information about the macports-users mailing list