mysql能连接但无法查看表_MySQL连接正常, 查看表信息报错

MySQL连接正常, 查看表信息时候报错:

经搜索找到以下解释:

If you get an error for some queries of type:

Can't create/write to file '\\sqla3fe_0.ism'.

this means that MySQL can't create a temporary file for the result set in the given temporary directory. (The above error is a typical error message on Windows, and the Unix error message is similar.) The fix is to start mysqld with --tmpdir=path or to add to your option file:

[mysqld]

tmpdir=C:/temp

assuming that the `c:\\temp' directory exists. See section 4.1.2 `my.cnf' Option Files.

Check also the error code that you get with perror. One reason may also be a disk full error;

shell> perror 28

Error code 28: No space left on device

简单的说, 就是缓存文件无法写入, 系统问题, 联系系统管理员或者查看系统缓存路径是否可以写入.