![](https://img-blog.csdnimg.cn/20201014180756919.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
mysql
tmaczt
一个热爱生活的程序员
展开
-
mysql 客户端SSL错误2026 (HY000)
背景:客户端连接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原创 2022-05-10 20:19:05 · 21131 阅读 · 12 评论 -
mysql 定时备份
1、备份shell#!/bin/bashdb_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~原创 2022-05-01 16:31:58 · 885 阅读 · 0 评论 -
java mysql问题汇总
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 valueA2:连接串中增加serverTimezone=UTC...原创 2020-11-25 15:25:25 · 83 阅读 · 0 评论 -
TiDB select into from替代方案
适用场景:批量更新数据前全表备份等实现代码://sqlserverselect 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原创 2020-08-20 11:16:00 · 1524 阅读 · 0 评论