execution: [[email protected] lamp]# mysqldump-f-r-e--master-data=2-p-A--single-transactionappears on consolemysqldump:couldn ' t execute ' Show table status like ' V\_bid\_bad ': "SELECT command denied to user" @ '% ' for column ' I d ' in table ' T_bids ' (1143)A select * from V_bid_bad appears in Workbench :10:29:20 SELECT * from Sp.v_bid_bad LIMIT 0, 50000 Error code:1449. The user specified as a definer (' root ' @ '% ') does not exist 0.000 secis a permission issueThere are two ways to modify this:1. Add [email protected]% account and PermissionsGrant All on * * to ' root ' @ '% ' identified by ' 00000 '; 2. Modify the view's DefinerIt is generally used in this machine:Select Concat ("Alter definer= ' root ' @ ' localhost ' SQL SECURITY definer View", Table_schema, ".", TABLE_NAME, "as", VIEW _definition, ";") From INFORMATION_SCHEMA. Views Wheretable_schema= ' SP '; executes the output statement again. successfully resolved this issue.
Mysqldump:couldn ' t execute ' Show table status ' workaround
