数据库
爆破小能手
这个作者很懒,什么都没留下…
展开
-
mysql数据库down机后,innodb损坏不能启动
报错信息:2020-12-14 9:21:57 6 [Warning] Failed to load slave replication state from table mysql.gtid_slave_pos: 1932: Table 'mysql.gtid_slave_pos' doesn't exist in engine2020-12-14 9:21:57 0 [Note] Reading of all Master_info entries succeeded2020-12-14 ...原创 2020-12-14 16:01:46 · 913 阅读 · 0 评论 -
mysql慢查询
1.查看是否开启慢查询#show variables like “%slow_query%”;2.开启慢查询vi /etc/my.cnfslow_query_log = ONslow_query_log_file = /var/lib/mysql/mysql_slow.loglong_query_time = 2systemctl restart mysqld3.查看慢查询信息...原创 2019-12-18 17:13:59 · 70 阅读 · 0 评论 -
B+算法
原文见链接:https://cloud.tencent.com/developer/article/1461421原创 2019-11-22 15:55:00 · 328 阅读 · 0 评论 -
mysql数据库存储路径迁移
1.查看数据库存储路径vi /etc/my.cnf2.暂停mysql服务systemctl stop mysqld3.创建存储的目标路径:mkdir /mysqldbmount /dev/sdb1 /mysqldbcp -R /var/lib/mysql/* /mysqldb4.更改目标路径的用户组chown -R mysql:mysql mysqldb5.修改my.cnf配置...原创 2019-07-16 10:40:26 · 825 阅读 · 0 评论 -
Navicat 10.0连接mysql 8.0报错
1.报错信息:Client does not support authentication protocol requested by server; consider upgrading MySQL client2.解决方法:#查看root用户的hostmysql> select user,host from user where user=‘root’;±-----±-----...原创 2019-07-03 12:55:25 · 457 阅读 · 0 评论 -
mysql读写报错“ERROR 2006”
1.报错信息ERROR 2006 (HY000): MySQL server has gone awayNo connection. Trying to reconnect…2019-06-25 12:38:26 93349 [Note] InnoDB: 5.6.44 started; log sequence number 406579732019-06-25 12:38:26 9334...原创 2019-06-26 21:25:43 · 1980 阅读 · 0 评论 -
linux忘记mysql密码解决方法
执行如下脚本保存至.sh文件,并使用chmod +x 改变文件的属性,并执行改脚本#!/usr/bin/bashecho “skip-grant-tables”>>/etc/my.cnfsystemctl restart mysqldmysql -e “select user,host,authentication_string from mysql.user where us...原创 2019-06-11 14:24:28 · 135 阅读 · 0 评论 -
mysql 8.0 root用户误删如何恢复
1.修改配置文件,获取权限登录root@localhost#vi /etc/my,cnf添加:–skip-grant-tablesroot@localhost#systemctl restart mysqld2.登录创建root用户root@localhost#mysqlmysql>use mysql;mysql>insert into user(User,authent...原创 2018-10-24 21:58:50 · 2881 阅读 · 0 评论 -
shell实现每天00:00自动收集mysql日志并上传到服务器
每天00:00将mysql日志上传到日志服务器,并清空服务器日志1.创建日志上传脚本#collect_log.sh directory is /home/admin/auto_shellfileName=$(date '+%Y-%m-%d)tar -czvf $fileName.tar.gz /var/log/mysqlftp -nv <<!open x.x.x.x ...原创 2018-11-19 19:44:11 · 379 阅读 · 0 评论