一般情况下,开发者需要如下的账号权限1.开发者需要的权限grantselect,insert,update,delete,create,alter,drop,alter routine,create routine,create temporary tables,create view,execute,indexon hxl.* to dev@'172.16.66.199' identified by 'mysql' WITH GRANT OPTION;2.debug存储过程...【阅读全文】
连不上mysql时一般有以下四种报错:1:Can't connect to MySQL server2:Lost connection to MySQL server3:Sorry, due to line fault, temporarily unable to browse, we are dealing with.4:MySQL server has gone away一:Can't connect to MySQL server 可能的原因:1,mysql服务端没有启起来2,网络不通(ipta...【阅读全文】
mysql版本:社区版 5.6.341.导出数据到文件报错误mysql> select * from tb_test where id<=10 into outfile '/db/mysqlmha/output/tb_test.txt' fields terminated by '|' optionally enclosed by '"';ERROR 1290 (HY000): The MySQL server is running with the --secure-file-priv option so it cannot execute this s...【阅读全文】
mysql版本:社区版5.6.34告警信息:2016-12-13 15:55:11 4bc8b940 InnoDB: Error: Table "mysql"."innodb_table_stats" not found.2016-12-13 15:55:11 4bc8b940 InnoDB: Recalculation of persistent statistics requested for table "chenli"."cp_tb_test" but the required persistent statistics storage is not pr...【阅读全文】
SELECT user, sum(first) as sum_first , sum(last) as sum_last from zabbix.wpsuser_data group by user;SELECT user, count(user) as count_user from zabbix.wpsuser_data group by user;【阅读全文】
连不上mysql时一般有以下四种报错:1:Can't connect to MySQL server2:Lost connection to MySQL server3:Sorry, due to line fault, temporarily unable to browse, we are dealing with.4:MySQL server has gone away一:Can't connect to MySQL server 可能的原因:1,mysql服务端没有启起来2,网络不通(ipta...【阅读全文】