tmaczt的博客

背景：客户端连接mysql8.x出现“ERROR 2026 (HY000): SSL connection error: unknown error number” mysql -h 10.233.117.225 -P3306 -uroot -p 方案一（已过时）： mysql -h10.233.117.225 -P3306 -uroot -p --skip-ssl 方案二（推荐）： mysql -h10.233.117.225 -P3306 -uroot -p --ssl-mode=DISABLED

1、备份shell #!/bin/bash db_user="root" db_passwd='pwd' db_name="dbname" name="$(date +"%Y%m%d%H%M%S")" /usr/bin/mysqldump -u$db_user -p$db_passwd $db_name >>/opt/mysql/$name.sql ~

Q1:java.lang.IllegalArgumentException: “Host ‘XXX’ is not allowed to connect to this MySQL server” A1:修改mysql.user表 update mysql.user set Host=’%’ where user=‘root’ Q2:java.sql.SQLException: The server time zone value A2:连接串中增加serverTimezone=UTC ...

适用场景：批量更新数据前全表备份等 实现代码： //sqlserver select into table_name_new from table_name //oracle create table table_name_new as select * from table_name; //tidb(mysql应该也适用) create table table_name_new like table_name; insert into table_name_new select * from t