第一次启动MySQL时报错
[root@localhost~]#/usr/local/webserver/mysql/bin/mysql_install_db --basedir=/usr/local/webserver/mysql --datadir=/data0/mysql/3306/data --user=mysql
Installing MySQL system tables...
ERROR: 1 Can‘t create/write to file ‘/tmp/#sql_2b11_0.MYI‘ (Errcode: 13)
120807 17:40:27 [ERROR] Aborting
120807 17:40:27 [Note] /usr/local/webserver/mysql/libexec/mysqld: Shutdown complete
Installation of system tables failed! Examine the logs in
/data0/mysql/3306/data for more information.
You can try to start the mysqld daemon with:
shell> /usr/local/webserver/mysql/libexec/mysqld --skip-grant &
and use the command line tool /usr/local/webserver/mysql/bin/mysql
to connect to the mysql database and look at the grant tables:
shell> /usr/local/webserver/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 /data0/mysql/3306/data 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 /usr/local/webserver/mysql/scripts/mysqlbug script!
[root@localhost ~]#
解决方法：
/tmp目录没有写入权限，使用chmod 777 /tmp即可
郑重声明：本站内容如果来自互联网及其他传播媒体，其版权均属原媒体及文章作者所有。转载目的在于传递更多信息及用于网络分享，并不代表本站赞同其观点和对其真实性负责，也不构成任何其他建议。
