如果碰到1547错误，尤其是通过Navicat工具在导出数据库时会出现此问题，以Windows系统为例，解决办法如下：
首先，启动cmd命令，进入MySQL的安装目录，并执行mysql_upgrade -u root -p root 命令，根据提示要求输入root的密码
C:\Program Files\MySQL\MySQL Server 5.5\bin>mysql_upgrade -u root -p root
Enter password: ****
其次，系统会自动执行表更新操作，静待执行完毕，并关闭DOS窗口。
Looking for 'mysql.exe' as: C:\Program Files\MySQL\MySQL Server 5.5\bin\mysql.exe
Looking for 'mysqlcheck.exe' as: C:\Program Files\MySQL\MySQL Server 5.5\bin\mysqlcheck.exe
Running 'mysqlcheck' with connection arguments: "--port=3306"
Running 'mysqlcheck' with connection arguments: "--port=3306"
db_banzhuange01.wx_attachment OK
db_banzhuange01.wx_demo OK
db_banzhuange01.wx_image_text OK
db_banzhuange01.wx_moudle OK
db_banzhuange01.wx_router OK
db_banzhuange01.wx_template OK
db_banzhuange01.wx_text OK
db_banzhuange01.wx_token OK
db_banzhuange01.wx_user OK
db_banzhuange01.wx_user_log OK
dbvideo.t_booking_conf OK
dbvideo.t_conf OK
dbvideo.t_conf_collect OK
dbvideo.t_conf_terminal OK
dbvideo.t_confs_config OK
dbvideo.t_confs_record OK
dbvideo.t_dept OK
dbvideo.t_fd OK
dbvideo.t_fee OK
dbvideo.t_feedback OK
dbvideo.t_function OK
dbvideo.t_terminal OK
dbvideo.t_user OK
dbvideo.t_userlog1 OK
dbvideo.t_userlog2 OK
dbvideo.tb_user_function OK
jfinal_demo.blog OK
mysql.columns_priv OK
mysql.db OK
mysql.event OK
mysql.func OK
mysql.general_log OK
mysql.help_category OK
mysql.help_keyword OK
mysql.help_relation OK
mysql.help_topic OK
mysql.host OK
mysql.ndb_binlog_index OK
mysql.plugin OK
mysql.proc OK
mysql.procs_priv OK
mysql.proxies_priv OK
mysql.servers OK
mysql.slow_log OK
mysql.tables_priv OK
mysql.time_zone OK
mysql.time_zone_leap_second OK
mysql.time_zone_name OK
mysql.time_zone_transition OK
mysql.time_zone_transition_type OK
mysql.user OK
shiro.roles_permissions OK
shiro.user_roles OK
shiro.users OK
sydj_open_rua.locks OK
sydj_open_rua.rc2p_members_sessionid_tgt OK
systems.f_account OK
systems.f_attachment OK
systems.f_authority OK
systems.f_category OK
systems.f_coefficient OK
systems.f_column OK
systems.f_content OK
systems.f_content_url OK
systems.f_demo OK
systems.f_dept OK
systems.f_dosage_form OK
systems.f_drug OK
systems.f_extraction OK
systems.f_material OK
systems.f_moudle OK
systems.f_operation OK
systems.f_prescription OK
systems.f_price OK
systems.f_r_content_column OK
systems.f_r_dept_column OK
systems.f_r_material_category OK
systems.f_r_role_account OK
systems.f_r_role_authority OK
systems.f_registered_user OK
systems.f_role OK
systems.f_template OK
systems.f_user OK
systems.f_user_log OK
systems.sem_r_content_column OK
test.maxtext OK
test.proc OK
test.student OK
test.tbl_test OK
video.hr_attendance_info OK
video.proc_basic_info OK
video.sys_account OK
video.sys_authority OK
video.sys_category OK
video.sys_config OK
video.sys_data OK
video.sys_data_type OK
video.sys_dept OK
video.sys_duty OK
video.sys_generator_table OK
video.sys_moudle OK
video.sys_operation OK
video.sys_r_role_account OK
video.sys_r_role_authority OK
video.sys_resource OK
video.sys_role OK
video.sys_user OK
video.sys_user_log OK
video.sys_video OK
Running 'mysql_fix_privilege_tables'...
OK
C:\Program Files\MySQL\MySQL Server 5.5\bin>
***后，重新启动MySQL服务，就好啦~
参考来源：https://blog.csdn.net/hety119/article/details/45767225
4454
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
