u012232730的博客

启动从时报错：mysql> start slave;ERROR 1872 (HY000): Slave failed to initialize relay log info structure from the repositoryreset slave之后可以：mysql> reset slave;Query OK, 0 rows affected (0.00 sec)mysql> change master to master_host='192...

根据时间戳定时归档#!/bin/sh#source ~/.bash_profile#Get current timestampcurrent=`date "+%Y-%m-%d %H:%M"`timeStamp=`date -d "$current" +%s`#echo $timeStamp#currentTimeStamp=$((timeStamp*1000+`date "+%N"`/1000000))currentTimeStamp=$((timeStamp*1000))echo $c

MySql 这个垃圾，从8.0开始修改密码有了变化，在user表加了字段authentication_string，修改密码前先检查authentication_string是否为空1、如果不为空use mysql;update user set authentication_string='' where user='root';--将字段置为空ALTERuser'root...

1、首先修改my.cnf文件里面的sql_mode值，因认5.6之后的默认值就是下面的两个sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES需要把STRICT_TRANS_TABLES去掉，即改为：# vi /usr/local/mysql/my.cnfsql_mode=NO_ENGINE_SUBSTITUTION注：简单来说S...