大菠萝就很棒的博客

Expression #31 of SELECT list is not in GROUP BY clause and contains nonaggregated column‘youtable.your.field’ which is not functionally dependent oncolumns in GROUP BY clause; this is incompatible...

解决办法，修改配置文件：max_allowed_packet=3500Mwait_timeout=288000 #等待时间interactive_timeout = 288000执行：set global max_allowed_packet = 50010241024; 即500M在命令行窗口（命令：show VARIABLES like ‘%max_allowed_packe...

一、启动方式1、使用 service 启动：service mysqld start2、使用 mysqld 脚本启动：/etc/inint.d/mysqld start3、使用 safe_mysqld 启动：safe_mysqld&二、停止1、使用 service 启动：service mysqld stop2、使用 mysqld 脚本启动：/etc/inint.d/mysql...

ERROR 1698 (28000): Access denied for user ‘root’@'localhost解决方案：步骤一：登录mysqlsudo mysql -u root -p步骤二：查看user表：select user, plugin from mysql.user;结果如下：mysql> select user, plugin from mysql....

1. 创建一个 delete.sh 文件，代码如下#!/bin/bashfind /root/test/ -mtime +30 -name "*.log" | xargs -i mv {} /root/copy/;解读:find 查找 /root/test/ 指定目录-mtime +30 30天前的（天数可自定义）-name “*.log” 所有.log结尾的文件 | xargs ...