MySQL 遇到错误以及解决
连接错误 1146：Table performance_schema.session_variables doesn`t exist:
解决办法：在bin文件夹下执行一个mysql_upgrade -u root -p --force命令（记得以上操作均是以管理员身份进行的）；
C:\Program Files\MySQL\MySQL Server 5.7\bin>mysql_upgrade -u root -p --force Enter password: ****** Checking server version. Running queries to upgrade MySQL server. Checking system database. mysql.columns_priv OK mysql.db OK mysql.engine_cost OK mysql.event OK mysql.func OK mysql.general_log OK mysql.gtid_executed OK mysql.help_category OK mysql.help_keyword OK mysql.help_relation OK mysql.help_topic OK mysql.innodb_index_stats OK mysql.innodb_table_stats OK mysql.ndb_binlog_index OK mysql.plugin OK mysql.proc OK mysql.procs_priv OK mysql.proxies_priv OK mysql.server_cost OK mysql.servers OK mysql.slave_master_info OK mysql.slave_relay_log_info OK mysql.slave_worker_info 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 Found outdated sys schema version 1.5.1. Upgrading the sys schema. Checking databases. aliexpressshopcollect.productinfo OK aliexpressshopcollect.storeinfo OK carcommentcrawling.carcommententity OK carcommentcrawling.searchcarentity OK dycommentcollectionproject.connentinfo OK ksebusinesscollect.sendlog OK ksebusinesscollect.sendmessageshopinfo OK ksebusinesscollect.shopcategoryinfo OK ksebusinesscollect.shopinfo OK mallcloud.admin_day_statics OK mallcloud.admin_gen_table OK mallcloud.admin_gen_table_column OK mallcloud.admin_sys_config OK mallcloud.admin_sys_dept OK mallcloud.admin_sys_dict_data OK mallcloud.admin_sys_dict_type OK mallcloud.admin_sys_job OK mallcloud.admin_sys_job_log OK mallcloud.admin_sys_logininfor OK mallcloud.admin_sys_menu OK mallcloud.admin_sys_notice OK mallcloud.admin_sys_oper_log OK mallcloud.admin_sys_post OK mallcloud.admin_sys_role OK mallcloud.admin_sys_role_dept OK mallcloud.admin_sys_role_menu OK mallcloud.admin_sys_user OK mallcloud.admin_sys_user_online OK mallcloud.admin_sys_user_post OK mallcloud.admin_sys_user_role OK mallcloud.area OK mallcloud.bak_brand OK mallcloud.bak_category OK mallcloud.bak_goods OK mallcloud.bill_aftersales OK mallcloud.bill_aftersales_images OK mallcloud.bill_aftersales_items OK mallcloud.bill_delivery OK mallcloud.bill_delivery_items OK mallcloud.bill_lading OK mallcloud.bill_payments OK mallcloud.bill_payments_rel OK mallcloud.bill_refund OK mallcloud.bill_reship OK mallcloud.bill_reship_items OK mallcloud.city OK mallcloud.cms_employ_info OK mallcloud.cms_favorite OK mallcloud.cms_help OK mallcloud.cms_help_category OK mallcloud.cms_member_report OK mallcloud.cms_parter OK mallcloud.cms_prefrence_area OK mallcloud.cms_prefrence_area_product_relation OK mallcloud.cms_subject OK mallcloud.cms_subject_category OK mallcloud.cms_subject_comment OK mallcloud.cms_subject_product_relation OK mallcloud.cms_topic OK mallcloud.cms_topic_category OK mallcloud.cms_topic_comment OK mallcloud.cms_topic_member OK mallcloud.college OK mallcloud.file_info OK mallcloud.invoice_record OK mallcloud.oauth_client_details OK mallcloud.oms_cart_item OK mallcloud.oms_company_address OK mallcloud.oms_express_company OK mallcloud.oms_express_info OK mallcloud.oms_order OK mallcloud.oms_order_item OK mallcloud.oms_order_operate_history OK mallcloud.oms_order_return_apply OK mallcloud.oms_order_return_reason OK mallcloud.oms_order_setting OK mallcloud.oms_payments OK mallcloud.oms_ship OK mallcloud.pms_album OK mallcloud.pms_album_pic OK mallcloud.pms_brand OK mallcloud.pms_comment OK mallcloud.pms_comment_replay OK mallcloud.pms_favorite OK mallcloud.pms_feight_template OK mallcloud.pms_gifts OK mallcloud.pms_gifts_category OK mallcloud.pms_member_price OK mallcloud.pms_product OK mallcloud.pms_product_attribute OK mallcloud.pms_product_attribute_category OK mallcloud.pms_product_attribute_value OK mallcloud.pms_product_category OK mallcloud.pms_product_category_attribute_relation OK mallcloud.pms_product_consult OK mallcloud.pms_product_full_reduction OK mallcloud.pms_product_ladder OK mallcloud.pms_product_operate_log OK mallcloud.pms_product_vertify_record OK mallcloud.pms_sku_stock OK mallcloud.pms_small_navicon_category OK mallcloud.province OK mallcloud.qrtz_blob_triggers OK mallcloud.qrtz_calendars OK mallcloud.qrtz_cron_triggers OK mallcloud.qrtz_fired_triggers OK mallcloud.qrtz_job_details OK mallcloud.qrtz_locks OK mallcloud.qrtz_paused_trigger_grps OK mallcloud.qrtz_scheduler_state OK mallcloud.qrtz_simple_triggers OK mallcloud.qrtz_simprop_triggers OK mallcloud.qrtz_triggers OK mallcloud.school OK mallcloud.shopping_favorite OK mallcloud.shopping_store OK mallcloud.sms_bargain_config OK mallcloud.sms_bargain_record OK mallcloud.sms_basic_gifts OK mallcloud.sms_basic_marking OK mallcloud.sms_configure OK mallcloud.sms_coupon OK mallcloud.sms_coupon_history OK mallcloud.sms_coupon_product_category_relation OK mallcloud.sms_coupon_product_relation OK mallcloud.sms_detailed_commission OK mallcloud.sms_draw OK mallcloud.sms_draw_user OK mallcloud.sms_experience OK mallcloud.sms_flash_promotion OK mallcloud.sms_flash_promotion_log OK mallcloud.sms_flash_promotion_product_relation OK mallcloud.sms_flash_promotion_session OK mallcloud.sms_group OK mallcloud.sms_group_activity OK mallcloud.sms_group_member OK mallcloud.sms_home_advertise OK mallcloud.sms_home_brand OK mallcloud.sms_home_new_product OK mallcloud.sms_home_recommend_product OK mallcloud.sms_home_recommend_subject OK mallcloud.sms_paimai OK mallcloud.sms_paimai_log OK mallcloud.sms_red_packet OK mallcloud.sms_share OK mallcloud.sms_sign_activity OK mallcloud.sms_sign_config OK mallcloud.sms_sign_record OK mallcloud.sms_user_red_packet OK mallcloud.spot_trans_pending OK mallcloud.sys_admin_log OK mallcloud.sys_applet_set OK mallcloud.sys_area OK mallcloud.sys_dict OK mallcloud.sys_member_area OK mallcloud.sys_message OK mallcloud.sys_notice OK mallcloud.sys_permission OK mallcloud.sys_permission_category OK mallcloud.sys_qiniu_config OK mallcloud.sys_qiniu_content OK mallcloud.sys_role OK mallcloud.sys_role_menu OK mallcloud.sys_role_permission OK mallcloud.sys_role_user OK mallcloud.sys_school OK mallcloud.sys_sms OK mallcloud.sys_store OK mallcloud.sys_user OK mallcloud.sys_user_permission OK mallcloud.sys_web_log OK mallcloud.t_logger OK mallcloud.t_tx_exception OK mallcloud.tb_health_push_task OK mallcloud.tb_health_push_task_user OK mallcloud.tb_panel OK mallcloud.tb_panel_content OK mallcloud.tb_user_from_id OK mallcloud.ums_collect OK mallcloud.ums_employ_info OK mallcloud.ums_growth_change_history OK mallcloud.ums_integration_change_history OK mallcloud.ums_integration_consume_setting OK mallcloud.ums_member OK mallcloud.ums_member_blance_log OK mallcloud.ums_member_level OK mallcloud.ums_member_location OK mallcloud.ums_member_login_log OK mallcloud.ums_member_member_tag_relation OK mallcloud.ums_member_product_category_relation OK mallcloud.ums_member_receive_address OK mallcloud.ums_member_rule_setting OK mallcloud.ums_member_statistics_info OK mallcloud.ums_member_tag OK mallcloud.ums_member_task OK mallcloud.ums_reward_log OK mallcloud.ums_reward_logs OK mallcloud.ums_system_message OK mallcloud.user_bankcards OK mallcloud.user_tocash OK news.news OK patentinquireproject.patentapplyinfo OK patentinquireproject.patentdispatchinfo OK patentinquireproject.searchinfo OK sys.sys_config OK tbenterprise.searchinfo OK tbenterprise.shopinfo OK wechartarticlecollect.articleentity OK wechartarticlecollect.keywordentity OK Upgrade process completed successfully. Checking if update is needed.
在data中会有新增2个文件夹：OK了
