吕涵之的博客

摘要： python3 爬取全名k歌 代码： import re import requests import ssl ssl._create_default_https_context=ssl._create_unverified_context k=0 if __name__ == '__main__' 阅读全文

摘要： shell进度条 !/bin/sh b='' for ((i=0;$i 1:percent=1 show_str=('[%% %ds]' % width) % (int(percent width) ' ') print('\r%s %s%%' %(show_str,int(percent 100) 阅读全文

摘要： 下面的代码写到xxx.bat文件中 @echo off start /d "D:\software\WeChat\" WeChat.exe start /d "D:\software\WeChat\" WeChat.exe exit 双击xxx.bat,显示如下 阅读全文

摘要： centos7.5 做binlog server,拉取主库binlog报错 问题: [root@db03 53 binlog] mysqlbinlog R host=10.0.0.55 user=mha password=mha raw stop never mysql bin.000001 & [ 阅读全文

摘要： 问题: [root@db03 53 ~] masterha_check_repl conf=/etc/mha/app1.cnf Tue Apr 2 20:24:58 2019 [warning] Global configuration file /etc/masterha_default.cnf 阅读全文

摘要： centos7.5 做基于GTID的主从重启从库报错 问题: [root@db01 51 ~] tail 50 /application/mysql/data/db01 51.err 2019 04 01 15:33:16 31069 [ERROR] gtid mode=ON or UPGRADE_ 阅读全文

摘要： centos7.5 远程连接数据库报错 问题: [root@db04 54 ~] mysql urep p123 h172.16.1.51 Warning: Using a password on the command line interface can be insecure. ERROR 1 阅读全文

摘要： centos7.5 重启mysql报错 问题: [root@db01 51 ~] mysqladmin uroot p123 S /data/3307/data/mysql.sock shutdown Warning: Using a password on the command line int 阅读全文

摘要： centos7.5 binlog恢复数据失败 问题: mysql \. /tmp/inc.sql ERROR 1050 (42S01): Table 'new_1' already exists ERROR 1666 (HY000): Cannot execute statement: imposs 阅读全文

摘要： centos7.5 使用into outfile备份失败 问题: mysql select from world.city into outfile '/tmp/world_city.data'; ERROR 1290 (HY000): The MySQL server is running wit 阅读全文