MySQL
倚栏静望
让Bug呆一会儿
展开
-
解决com.mysql.jdbc.exceptions.jdbc4.CommunicationsException:
有时候mysql会遇到: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: The last packet successfully received from the server was 126,421,823 milliseconds ago. The last packet sent successfully to the...原创 2018-09-08 21:21:28 · 8071 阅读 · 0 评论 -
linux mysql目录迁移
使用linux下的软连接方法,具体操作如下:(以迁移到/home/mysql/目录为例) 先停止mysql: 代码如下 复制代码 /etc/init.d/mysqld stop 移动数据: mv /var/lib/mysql/* /home/mysql/ 创建软连接: ln -s /home/mysql/ /var/lib/mysql/ 启动mysql: /etc/init.d/mysqld st...原创 2018-10-10 00:13:20 · 984 阅读 · 0 评论 -
mysql重连,连接丢失: The last packet sent successfully to the server was 36,799,662 milliseconds ago.
出错信息: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: The last packet successfully received from the server was 36,799,660 milliseconds ago. The last packet sent successfully to the server w...原创 2018-10-21 10:56:49 · 1606 阅读 · 0 评论 -
linux centos7安装MySql 5.7.20 操作步骤
第一步:下载mysql wget http://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-5.7.20-linux-glibc2.12-x86_64.tar.gz 第二步:在安装目录中中解压压缩包,并改名为mysql,我的安装目录是/mnt cd /mnt tar -xzvf mysql-5.7.20-linux-glibc2.12-x86_64....原创 2019-06-01 19:02:42 · 303 阅读 · 0 评论