Please Help - can't get mysql to run

[Bradley Giesbrecht]

On Oct 20, 2010, at 3:08 PM, Mo Issa wrote:

>> Hello all --
>>
>> 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)
>> 101020 15:57:13 [ERROR] Aborting
>>
>> 101020 15:57:13 [Note] /opt/local/libexec/mysqld: Shutdown complete
>>
>>
>> Installation of system tables failed!  Examine the logs in
>> /opt/local/var/db/mysql5 for more information.
>>
>> You can try to start the mysqld daemon with:
>>
>>     shell> /opt/local/libexec/mysqld --skip-grant &
>>
>> and use the command line tool /opt/local/lib/mysql5/bin/mysql
>> to connect to the mysql database and look at the grant tables:
>>
>>     shell> /opt/local/lib/mysql5/bin/mysql -u root mysql
>>     mysql> show tables
>>
>> Try 'mysqld --help' if you have problems with paths.  Using --log
>> gives you a log in /opt/local/var/db/mysql5 that may be helpful.
>>
>> Please consult the MySQL manual section
>> 'Problems running mysql_install_db', and the manual section that
>> describes problems on your OS.  Another information source are the
>> MySQL email archives available at http://lists.mysql.com/.
>>
>> Please check all of the above before mailing us!  And remember, if
>> you do mail us, you MUST use the /opt/local/lib/mysql5/bin/mysqlbug  
>> script!
>>
>>
>> I thought this was a permission issue but it still doesn’t work.  
>> Can any of you help. According to some research I’ve done,  
>> apparently the mysql user doesn’t have permission to write to the  
>> tmp directory so how do I go about giving it permission?
>>
>> Many Thanks!

Please create a new email for a new subject or it mess everyones  
message threading up.

Did you try the following?

sudo port load mysql5-server

man port
/load

Brad
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.macosforge.org/pipermail/macports-users/attachments/20101020/231d8cd1/attachment.html>