今天在给一个数据库服务器做数据备份时出现下面的错误,大大们帮帮我。
 Error Could not fetch schema table status我打开MySQL Administrator工具左边的Catalogs,在Schemata里面点击任意一个数据库名称就出现以上提示。服务器环境:FreeBSD 8.0
MySQL:6.0alpha

解决方案 »

  1.   

    先检查你的权限。 你的登录账号是什么?show grants 贴出来看一下。
      

  2.   

    我用的是cessoftuser账户
    +-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
    | Grants for cessoftuser@%                                                                                                                                                                                                                |
    +-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
    | GRANT USAGE ON *.* TO 'cessoftuser'@'%' IDENTIFIED BY PASSWORD '*E24C56E49292B2C38110AB6DCD90F8091A7AE1ED'                                                                                                                              |
    | GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, REFERENCES, INDEX, ALTER, CREATE TEMPORARY TABLES, LOCK TABLES, EXECUTE, CREATE VIEW, SHOW VIEW, CREATE ROUTINE, ALTER ROUTINE ON `cesmis`.* TO 'cessoftuser'@'%' WITH GRANT OPTION |
    +-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
    2 rows in set (0.00 sec)以下是数据库里面的账号明细:
    mysql> select  host, user,password from user;
    +------------+-------------+-------------------------------------------+
    | host       | user        | password                                  |
    +------------+-------------+-------------------------------------------+
    | localhost  | root        |                                           |
    | dxfs.local | root        |                                           |
    | 127.0.0.1  | root        |                                           |
    | localhost  |             |                                           |
    | dxfs.local |             |                                           |
    | %          | cessoftuser | *E24C56E49292B2C38110AB6DCD90F8091A7AE1ED |
    +------------+-------------+-------------------------------------------+
      

  3.   

    权限不足。你直接用root 吧
      

  4.   

    我用root账户试了,也不行。也会弹出那个错误提示。
    MySQL Administrator Error
      Could not fetch schema table status.