mysqldump Couldn't execute 'show create table.....的错误
[root@csfdpdev data]# mysqldump -ucsfdp -pcsfdp web_cdp > web_cdp_26_20110907.sqlmysqldump: Couldn't execute 'show create table `listed_cpny_item_fin_data_0`': View 'web_cdp.listed_cpny_item_fin_data_0' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them (1356)
[root@csfdpdev data]# mysqldump -ucsfdp -pcsfdp web_cdp > web_cdp_26_20110907.sqlmysqldump: Couldn't execute 'show create table `listed_cpny_item_fin_data_0`': View 'web_cdp.listed_cpny_item_fin_data_0' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them (1356)
解决方案 »
- 【求助】关于mysql执行存储过程显示结果集的问题!
- mysql数据的运算问题,急!急!急!急!急!
- 如何用mySql事件定时更新表数据
- 几个小问题。
- 求助:mysql无法安装成功........
- 简单问题(数学家)请进
- 请问,在LINUX上关闭postgresql的指令是什么?
- 以前用MYSQL 3.23.55 挺好的,一但升级到 3.23.57 或更高的版本时,原来的PHP程序提示数据库用户名密码不正确,怎么回事?
- 请问如何将数据导入到MYSQL(因数据量大,只能非远程),如何备份数据(在主机上)?如果回答确有帮助,分数最高300分
- 错误应用程序 mysqld-nt.exe,版本 0.0.0.0,错误模块 mysqld-nt.exe
- 高分求解 急!!!!
- 我的这个mysqlfront怎么跟mysql连接呢?
检查listed_cpny_item_fin_data_0表是否有问题,用户是否有相应权限
delimiter $$CREATE ALGORITHM=UNDEFINED DEFINER=`skyman.man`@`%` SQL SECURITY DEFINER VIEW `web_cdp`.`listed_cpny_rpt_fin_style_0` AS select `cdp`.`listed_cpny_rpt_fin_style_0`.`excel_id` AS `excel_id`,`cdp`.`listed_cpny_rpt_fin_style_0`.`rpt_id` AS `rpt_id`,`cdp`.`listed_cpny_rpt_fin_style_0`.`acc_std` AS `acc_std`,`cdp`.`listed_cpny_rpt_fin_style_0`.`prd_year` AS `prd_year`,`cdp`.`listed_cpny_rpt_fin_style_0`.`prd_qtr` AS `prd_qtr`,`cdp`.`listed_cpny_rpt_fin_style_0`.`accumulate` AS `accumulate`,`cdp`.`listed_cpny_rpt_fin_style_0`.`biz_cd` AS `biz_cd`,`cdp`.`listed_cpny_rpt_fin_style_0`.`acc_cd` AS `acc_cd`,`cdp`.`listed_cpny_rpt_fin_style_0`.`row_num` AS `row_num`,`cdp`.`listed_cpny_rpt_fin_style_0`.`col_num` AS `col_num`,`cdp`.`listed_cpny_rpt_fin_style_0`.`col_unit` AS `col_unit`,`cdp`.`listed_cpny_rpt_fin_style_0`.`col_cur` AS `col_cur`,`cdp`.`listed_cpny_rpt_fin_style_0`.`row_unit` AS `row_unit`,`cdp`.`listed_cpny_rpt_fin_style_0`.`row_cur` AS `row_cur`,`cdp`.`listed_cpny_rpt_fin_style_0`.`data_id` AS `data_id`,`cdp`.`listed_cpny_rpt_fin_style_0`.`item_cd` AS `item_cd`,`cdp`.`listed_cpny_rpt_fin_style_0`.`data_val` AS `data_val`,`cdp`.`listed_cpny_rpt_fin_style_0`.`data_trans_comment` AS `data_comment`,`cdp`.`listed_cpny_rpt_fin_style_0`.`trace_flag` AS `upd_stmp` from `cdp`.`listed_cpny_rpt_fin_style_0`$$
GRANT ALL ON *.* TO 'root'@'%';
再执行
检查一下目录的权限
到底需要root账号赋予website账号啥权限啊?
都赋予了权限了,用的是all,另外这个不是table,是view,为什么会报show create table 的错误呢?