在Mysql中创建临时表的时候发生错误:
- mysql> CREATE TEMPORARY TABLE `tname` ( `weekno` INT(11) NOT NULL );
- ERROR 1005 (HY000): Can't create table `tname` (errno: 13)
解决方法:
1. chmod 0777 /tmp
2. chown -R mysql:mysql /var/lib/mysql/database_name
阅读(2486) | 评论(0) | 转发(0) |