修改用户名后操作view 报1449 错误

今天接到一开发反应，他们项目远程连接mysql ，有一张视图不能访问，出现以下错误：

因为每个项目都是单独分用户出去

[root@localhost ~]# mysql -u root -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 25538
Server version: 5.5.29-log MySQL Community Server (GPL)


Copyright (c) 2000, 2012, Oracle and/or its affiliates. All rights reserved.


Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.


Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> select * from v_challenge_rank;
ERROR 1449 (HY000): The user specified as a definer ('root'@'%') does not exist

mysql> select table_schema,table_name,definer from views;

+---------------+------------------+---------+
| table_schema  | table_name       | definer |
+---------------+------------------+---------+
| wx_characters | v_challenge_rank | root@%  |
+---------------+------------------+---------+

 因为mysql 用root用户创建视图，权限只会赋给创建视图的用户

 这个视图不是他们项目组用户创建的，所以用户没有权限访问。

 用该用户重建视图、恢复正常！ 

 show create view c_challenge

create or replace view v_challenge as select * from challenge