Shulou(Shulou.com)06/01 Report--

Execute the show table status command on the database and report the error as shown in the following figure:

But there are no empty users in the database, which is verified in the following figure:

Then you can determine that it is not the database user authorization problem, then it may be the database view. When you open the view of the library, the following error occurs:

Reason: this database view is created by the root@% user, but the user does not exist in the database and is rejected by default when executed with another user

Now look at the view defined by root@%:

Solution: change the view definer to the current user and execute the following sql statement:

Create or replace view hwu_new.hwu_goods_list_activity as select * from hwu_new.hwu_goods_activity

Continue to see that the definer of the view has become the current user:

Executing the show table status statement no longer reports an error.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.