Please Help - can't get mysql to run
brad at pixilla.com
Wed Oct 20 15:09:56 PDT 2010
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
>> 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
>> 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
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the macports-users