can't create/write to file '/tmp/#sql_23e6_0MYI'解决方法

今天使用navicat登陆mysql数据库打开表的时候报错can't create/write to file '/tmp/#sql_23e6_0MYI',在官网找到了解决问题的方法。

http://forums.mysql.com/read.php?11,101316,126000

解决方法：

                 mkdir /var/lib/mysql/tmp

                 chown  mysql:mysql /var/lib/mysql/tmp

                vi /etc/my.cnf

                tmpdir = /var/lib/mysql/tmp

                service mysqd restart

问题解决。