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
_______________________________________________
macports-users mailing list
[email protected]
http://lists.macosforge.org/mailman/listinfo.cgi/macports-users
