Please Help - can't get mysql to run

[Mo Issa]

> 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!
> 
> bigmo

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