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