Step 2: set mysql env optionssystemctl set-environment MYSQLD_OPTS=--skip-grant-tablesStep 4: Update Password using querymysql> UPDATE mysql.user SET authentication_string = PASSWORD ('ENTER_NEW_PASSWORD') WHERE User = 'root' AND Host = 'localhost...【阅读全文】
1.删除canal用户DROP USER 'canal'@'%'2.添加canal用户CREATE USER canal IDENTIFIED BY 'canal'; GRANT SELECT, REPLICATION SLAVE, REPLICATION CLIENT ON *.* TO 'canal'@'%';-- GRANT ALL PRIVILEGES ON *.* TO 'canal'@'%' ;FLUSH PRIVILEGES;【阅读全文】
max_execution_time applies to read-only SELECT statements.mysql> show variables like 'max_execution_time'; select /*+ max_execution_time(3000)*/ count(*) from t1 where status=0;【阅读全文】