mysql>selectENGINE_LOCK_ID,ENGINE_TRANSACTION_ID,LOCK_MODE,LOCK_TYPE,INDEX_NAME,OBJECT_SCHEMA,OBJECT_NAME,LOCK_DATA,LOCK_STATUS,THREAD_ID from performance_schema.data_locks; mysql>selectlocked_table_name,locked_index,waiting_pid,waiting_lock_id,blocking_lock_id,blocking_pid from sys.innodb_lock_...
第六步:執(zhí)行命令:update user set authentication_string ='' where user = 'root'; 清空密碼。因為MySql8+, 和以前版本有點不同,user表沒有password字段了,而是authentication_string 。 第七步:輸入指令:flush privileges; 使改變生效。 exit 退出mysql。