mysql
USCWIFI
Talk is cheap,show me your code.
展开
-
三剑客20190714
最后wordpress项目: main.yml [root@jenkins wordpress_playbooks]# cat roles/wordpress/tasks/main.yml - name: Update yum dependency shell: 'yum update -y warn=False' - name: Disable system firewall ...原创 2019-07-14 22:32:50 · 437 阅读 · 0 评论 -
mysql导入数据报错ERROR 1290 (HY000): The MySQL server is running with the --secure-file-priv option so it
参考:https://blog.csdn.net/u011677147/article/details/64129606 参考:http://blog.itpub.net/31015730/viewspace-2152273/ 导入数据报错 mysql> LOAD DATA INFILE '/tmp/1.txt' INTO TABLE hr.employees; ERROR 1290...原创 2019-04-20 13:09:37 · 8535 阅读 · 2 评论 -
MySQL主从/主主同步部署
参考:https://www.cnblogs.com/kevingrace/p/6256603.html 参考:https://www.cnblogs.com/kevingrace/p/10228694.html 参考:http://www.cnblogs.com/gl-developer/p/6170423.html 环境描述: CentOS7.5 master(node1):10.0...原创 2019-01-08 20:46:05 · 487 阅读 · 0 评论 -
mysql主从同步概念(转载)
参考:https://www.cnblogs.com/kevingrace/p/10228694.html 参考:https://www.cnblogs.com/kevingrace/p/6256603.html Mysql复制概念 Mysql内建的复制功能是构建大型高性能应用程序的基础, 将Mysql数据分布到多个系统上,这种分布机制是通过将Mysql某一台主机数据复制到其它主机(slave...转载 2019-01-07 22:07:59 · 543 阅读 · 1 评论 -
zabbix自定义监控项总结
Zabbix自定义监控项: 监控项可以放在zabbix_agent.conf或者写入zabbix_agent.conf.d/*.conf 语法:UserParameter=key,command 一、检测mysql状态,有没有挂掉: 命令如下:mysqladmin -uroot -p123456 ping | grep alive 监控项配置如下: UserParameter=mysq...原创 2018-12-24 16:46:32 · 1180 阅读 · 0 评论 -
centos7.5修改mysql5.7.24默认密码
mysql是yum安装的,版本为5.7.24 装完后启动mysql,会产生个随机密码在/var/log/mysqld.log文件中 mysql> select version(); +-----------+ | version() | +-----------+ | 5.7.24 | +-----------+ 1 row in set (0.00 sec) 如下图:进去就报错,...转载 2018-12-15 17:54:45 · 1154 阅读 · 0 评论 -
ubuntu16.04重置mysql5.7密码
参考:https://blog.csdn.net/appleyuchi/article/details/79471025 参考:https://www.cnblogs.com/roadofstudy/p/7446690.html 参考:https://blog.csdn.net/hjf161105/article/details/78850658 mysql5.7采用默认的源apt安装的,没...原创 2018-11-12 10:58:43 · 442 阅读 · 0 评论