MySQL Show table status Error resolution

Execute the Show Table Status command on the database, as shown in the error:

650) this.width=650; "src=" Http://s1.51cto.com/wyfs02/M00/84/24/wKiom1eG-CLz8cC4AAAJas0Wtr4849.png "title=" error. png "alt=" Wkiom1eg-clz8cc4aaajas0wtr4849.png "/>

But there are no empty users on the database, verify that:

650) this.width=650; "src=" Http://s2.51cto.com/wyfs02/M01/84/24/wKiom1eG-VHgc3ttAAATOWrJrRQ915.png "title=" QQ picture 20160714103021.png "alt=" Wkiom1eg-vhgc3ttaaatowrjrrq915.png "/>

That can be judged not by the database user authorization problem, it may be a problem with the database view, when the view of the library opens, the following error occurs:

650) this.width=650; "src=" Http://s2.51cto.com/wyfs02/M02/84/24/wKioL1eG-snAVLBEAAAkYDrJtIQ322.png "title=" QQ picture 20160714103619.png "alt=" Wkiol1eg-snavlbeaaakydrjtiq322.png "/>

Cause: This database view is created by the [email protected]% user, but the user does not exist in the database and is rejected by default when executed with another user.

Now the view is defined by [email protected]%:

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M02/84/24/wKioL1eG_AfSaTIdAAAZ2j1RMj4848.png "title=" Modified before. png "alt=" Wkiol1eg_afsatidaaaz2j1rmj4848.png "/>

Workaround: Modify the view definition 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;

The person who continues to view the definition of the view has become the current user:

650) this.width=650; "src=" Http://s5.51cto.com/wyfs02/M02/84/24/wKioL1eG_RGT59-CAAAaV8ZD7IA471.png "title=" Modified. png "alt=" Wkiol1eg_rgt59-caaaav8zd7ia471.png "/>

Execution of the Show Table status statement no longer errors.

This article is from "My In Lushan" blog, please be sure to keep this source http://147546.blog.51cto.com/137546/1826286

MySQL Show table status Error resolution