I am trying to install MySQL on a Solaris 10 machine (x86). I have set up a mysql user and group and have even created a folder for the DB (/u01/app/mysql). During the package install process I get a message stating "ERROR: 1004 Can't create file '/var/tmp//install9Oa4rc/#sql4a6_1_0.frm' (errno: 13)". I can't figure this one out. I don't see any log entries to tell me whats going on. Below is a tail of the output. I tried starting the server, which is stupid as I know the system tables have not been created yet, but I was hopeful anyway. This also generated an error.
[ verifying class <none> ]
## Executing postinstall script.
ERROR: 1004 Can't create file '/var/tmp//install9Oa4rc/#sql4a6_1_0.frm' (errno: 13)
071009 9:52:56 [ERROR] Aborting
071009 9:52:56 [Note] /opt/mysql/mysql/bin/mysqld: Shutdown complete
Installation of system tables failed!
Examine the logs in /var/lib/mysql for more information.
You can try to start the mysqld daemon with:
/opt/mysql/mysql/bin/mysqld --skip-grant &
and use the command line tool
/opt/mysql/mysql/bin/mysql to connect to the mysql
database and look at the grant tables:
shell> /opt/mysql/mysql/bin/mysql -u root mysql
mysql> show tables
Try 'mysqld --help' if you have problems with paths. Using --log
gives you a log in /var/lib/mysql that may be helpful.
The latest information about MySQL is available on the web at
http://www.mysql.com
Please consult the MySQL manual section: 'Problems running mysql_install_db',
and the manual section that describes problems on your OS.
Another information source is the MySQL email archive.
Please check all of the above before mailing us!
And if you do mail us, you MUST use the ./bin/mysqlbug script!
Installation of <mysql> was successful.
# su - mysql
Sun Microsystems Inc. SunOS 5.10 Generic January 2005
-bash-3.00$ /opt/mysql/mysql/bin/mysqld --skip-grant &
[1] 1209
-bash-3.00$ 071009 9:54:02 InnoDB: Operating system error number 13 in a file operation.
InnoDB: The error means mysqld does not have the access rights to
InnoDB: the directory.
InnoDB: File name ./ibdata1
InnoDB: File operation call: 'open'.
InnoDB: Cannot continue operation.
[1]+ Exit 1 /opt/mysql/mysql/bin/mysqld --skip-grant
-bash-3.00$ /opt/mysql/mysql/bin/mysqld --skip-grant &
[1] 1212
-bash-3.00$ 071009 9:56:07 InnoDB: Operating system error number 13 in a file operation.
InnoDB: The error means mysqld does not have the access rights to
InnoDB: the directory.
InnoDB: File name ./ibdata1
InnoDB: File operation call: 'open'.
InnoDB: Cannot continue operation.
/opt/mysql/mysql/bin/mysql
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mys ql.sock' (2)
[1]+ Exit 1 /opt/mysql/mysql/bin/mysqld --skip-grant
-bash-3.00$ /opt/mysql/mysql/bin/mysql
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mys ql.sock' (2)
Edited 1 time(s). Last edit at 10/08/2007 06:54PM by Steven Benjamin.