问题: mysql5.1, 从别人数据库导一份数据到本地,发现视图不可用报错.
show full fields from `vmall`.`front_order_item_related`
SELECT command denied to user ''@'%' for column 'id' in table 'order_item'
解决办法: 此处是英文两数据库用户名不一样 修改创建视图中用户即可
CREATE ALGORITHM=UNDEFINED DEFINER=`<span style="color:#ff0000;">user</span>`@`%` SQL SECURITY DEFINER VIEW