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

Mysqldump-uroot-p-- single-transaction-- databases A B C D E F G H-- master-data=2 > backup.sql

The following error occurred:

Mysqldump: Couldn't execute 'show table status like' view\ _ frist\ _ order'': SELECT command denied to user'@ 'localhost' for column' usr_user_id' in table 'ord_order' (1143)

Modify the definer of view

Select concat ("alter DEFINER= `root` @ `localhost` SQL SECURITY DEFINER VIEW", TABLE_SCHEMA, ".", TABLE_NAME, "as", VIEW_DEFINITION, ";") from information_schema.VIEWS whereTABLE_SCHEMA='sp'

Then execute the output statement.

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.